--ABS-68455/ ABS-70023

---------------------MULTIREADEXCEPTIONREASON  table-----------------

INSERT INTO MULTIREADEXCEPTIONREASON (MULTIREADEXCEPTIONREASON_ID, FACTORYDESCRIPTION, STORELOGYN, SYSTEMUSER_ID, TIMESTAMP) 
     VALUES (33, 'Maximum number of rewashes', 'Y', GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

INSERT INTO MULTIREADEXCEPTIONREASON (MULTIREADEXCEPTIONREASON_ID, FACTORYDESCRIPTION, STORELOGYN, SYSTEMUSER_ID, TIMESTAMP) 
     VALUES (34, 'Too many times rewashed', 'Y', GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

---------------------MULTIREADEXCEPTIONREASON_DESC  table---------------------

INSERT INTO MULTIREADEXCEPTIONREASON_DESC (MULTIREADEXCEPTIONREASON_ID, LANGUAGE_ID, DESCRIPTION, SYSTEMUSER_ID, TIMESTAMP)
SELECT M.MULTIREADEXCEPTIONREASON_ID,
    L.LANGUAGE_ID, 
    M.FACTORYDESCRIPTION,
    GETMINSYSTEMUSER(),
    SYSDATE
  FROM MULTIREADEXCEPTIONREASON M, LANGUAGES L
  WHERE L.TRANSLATEDESCRIPTION = 'Y'
  AND M.MULTIREADEXCEPTIONREASON_ID in (33, 34);
COMMIT;