--ABS-46843 / ABS-70649
------------------------ MULTIREADEXCEPTIONREASON ------------------------
INSERT INTO MULTIREADEXCEPTIONREASON (MULTIREADEXCEPTIONREASON_ID, FACTORYDESCRIPTION, STORELOGYN, SYSTEMUSER_ID, TIMESTAMP) 
     VALUES (32, 'Already scanned as Clean Return', 'Y', GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

------------------------ MULTIREADEXCEPTIONREASON_DESC ------------------------
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 = 32;
COMMIT;
