-- ABS-51098/ ABS-59811
---- MULTIREADEXCEPTIONREASON ----
INSERT INTO MULTIREADEXCEPTIONREASON (MULTIREADEXCEPTIONREASON_ID, FACTORYDESCRIPTION, STORELOGYN, SYSTEMUSER_ID, TIMESTAMP)
VALUES (29, 'Item does not exist in Clean Room Batch', '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 = 29;
COMMIT;