--- ABS-20501
------------------------   OOSACTION   -----------------------------------
INSERT INTO OOSACTION
 (OOSACTION_ID, 
   FACTORYDESCRIPTION, 
   SYSTEMUSER_ID, 
   TIMESTAMP)
VALUES 
   (10, 'Allocate items for Backorder', GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

INSERT INTO OOSACTION
 (OOSACTION_ID, 
   FACTORYDESCRIPTION, 
   SYSTEMUSER_ID, 
   TIMESTAMP)
VALUES 
   (11, 'Order items for stock replenishment', GETMINSYSTEMUSER(), SYSDATE);
COMMIT;

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

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

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

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

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

INSERT INTO STOCKROOMOOSACTIONS
(SELECT SEQ_STOCKROOMOOSACTIONS.NEXTVAL,
       S.STOCKROOM_ID,
       11,
       2,
       GETMINSYSTEMUSER(),
       TIMESTAMP
FROM STOCKROOM S);
COMMIT;