-- ABS-11734

----------- TRANSACTIONTYPE ----------- 
INSERT INTO  TRANSACTIONTYPE
  (TRANSACTIONTYPE_ID, FACTORYDESCRIPTION, SYSTEMUSER_ID, TIMESTAMP)
VALUES 
  (55, 'Clean Return Scan', GETMINSYSTEMUSER(), SYSDATE);
 
COMMIT;
----------- TRANSACTIONTYPE_DESC ----------- 
INSERT INTO TRANSACTIONTYPE_DESC
  (TRANSACTIONTYPE_ID, LANGUAGE_ID, DESCRIPTION, SYSTEMUSER_ID, TIMESTAMP)

  SELECT T.TRANSACTIONTYPE_ID,
         L.LANGUAGE_ID,
         T.FACTORYDESCRIPTION,
         GETMINSYSTEMUSER(),
         SYSDATE
    FROM TRANSACTIONTYPE T, LANGUAGES L
   WHERE L.TRANSLATEDESCRIPTION = 'Y'
     AND T.TRANSACTIONTYPE_ID = 55;
	 
COMMIT;

