--- ABS-15967
---------------------   OOSACTION   ----------------------------------
INSERT INTO OOSACTION
 (OOSACTION_ID, 
   FACTORYDESCRIPTION, 
   SYSTEMUSER_ID, 
   TIMESTAMP)
VALUES 
   (4, 'Reserve items from stockroom', GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

---------------------   OOSACTIONRESTRICTION   -----------------------
INSERT INTO OOSACTIONRESTRICTION
   (OOSACTIONRESTRICTION_ID,
    OOSACTION_ID,
    OOSRESTRICTION_ID,
    SYSTEMUSER_ID,
    TIMESTAMP)
VALUES
   (SEQ_OOSACTIONRESTRICTION.NEXTVAL, 4, 1, GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

INSERT INTO OOSACTIONRESTRICTION
   (OOSACTIONRESTRICTION_ID,
    OOSACTION_ID,
    OOSRESTRICTION_ID,
    SYSTEMUSER_ID,
    TIMESTAMP)
VALUES
   (SEQ_OOSACTIONRESTRICTION.NEXTVAL, 4, 2, GETMINSYSTEMUSER(), SYSDATE);
COMMIT;
	
INSERT INTO OOSACTIONRESTRICTION
   (OOSACTIONRESTRICTION_ID,
    OOSACTION_ID,
    OOSRESTRICTION_ID,
    SYSTEMUSER_ID,
    TIMESTAMP)
VALUES
   (SEQ_OOSACTIONRESTRICTION.NEXTVAL, 4, 5, GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

--------------------   STOCKROOMOOSACTIONS   -------------------------
INSERT INTO STOCKROOMOOSACTIONS
(SELECT SEQ_STOCKROOMOOSACTIONS.NEXTVAL,
       S.STOCKROOM_ID,
       4,
       1,
       GETMINSYSTEMUSER(),
       TIMESTAMP
FROM STOCKROOM S);
COMMIT;

