--- ABS-11726
-----------------------DBCONSISTENCYCHECK--------------------------
 insert into DBCONSISTENCYCHECK
      (DBCONSISTENCYCHECK_ID,
       DESCRIPTION,
       SQLSTATEMENT,
       ERRORMESSAGE,
       EXACTLYONEROW,
       ADDITIONALERRORMESSAGE,
       ACTIVE)
    values
      (66,
       'Check if STOCKCOUNTSCHEDULE _LINK table is correctly filled',
       'select a.code, a.description, a.customer_id, timestamp
       from stockcountschedule a
       where not exists (select x.stockcountschedule_id
       from stockcountschedule_link x
       where x.stockcountschedule_id = a.stockcountschedule_id)
       order by 1',
       'There are records in STOCKCOUNTSCHEDULE table with no related record in STOCKCOUNTSCHEDULE_LINK table!',
       'N',
       null,
       'Y');
COMMIT;
