/* Formatted on 07-May-09 5:33:36 PM (QP5 v5.115.810.9015) */
CREATE TABLE STK_ALOC_MAST
(
   RO_NO     VARCHAR2 (9),
   REMARKS   VARCHAR2 (30)
)
TABLESPACE CSSU
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (INITIAL 1 M
         NEXT 1 M
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         FREELISTS 1
         FREELIST GROUPS 1
         BUFFER_POOL DEFAULT)
LOGGING
NOCACHE
NOPARALLEL;

SET DEFINE OFF;

INSERT INTO STK_ALOC_MAST (RO_NO, REMARKS)
  VALUES   ('RA01', NULL);

INSERT INTO STK_ALOC_MAST (RO_NO, REMARKS)
  VALUES   ('RA02', NULL);

INSERT INTO STK_ALOC_MAST (RO_NO, REMARKS)
  VALUES   ('RA03', NULL);

INSERT INTO STK_ALOC_MAST (RO_NO, REMARKS)
  VALUES   ('RA04', NULL);

INSERT INTO STK_ALOC_MAST (RO_NO, REMARKS)
  VALUES   ('RA05', NULL);

COMMIT;

CREATE TABLE STK_RO_HDR
(
   RO_NO   VARCHAR2 (9),
   ID      VARCHAR2 (9)
)
TABLESPACE CSSU
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (INITIAL 1 M
         NEXT 1 M
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         FREELISTS 1
         FREELIST GROUPS 1
         BUFFER_POOL DEFAULT)
LOGGING
NOCACHE
NOPARALLEL;

SET DEFINE OFF;

INSERT INTO STK_RO_HDR (RO_NO, ID)
  VALUES   ('RA01', '1');

INSERT INTO STK_RO_HDR (RO_NO, ID)
  VALUES   ('RA02', '2');

INSERT INTO STK_RO_HDR (RO_NO, ID)
  VALUES   ('RA03', '3');

INSERT INTO STK_RO_HDR (RO_NO, ID)
  VALUES   ('RA04', '4');

INSERT INTO STK_RO_HDR (RO_NO, ID)
  VALUES   ('RA05', '5');

COMMIT;

CREATE TABLE STK_RO_JOBS
(
   ROHD_ID    VARCHAR2 (9),
   JOB_CODE   VARCHAR2 (9),
   JOB_DESC   VARCHAR2 (30)
)
TABLESPACE CSSU
PCTUSED 40
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (INITIAL 1 M
         NEXT 1 M
         MINEXTENTS 1
         MAXEXTENTS UNLIMITED
         PCTINCREASE 0
         FREELISTS 1
         FREELIST GROUPS 1
         BUFFER_POOL DEFAULT)
LOGGING
NOCACHE
NOPARALLEL;

SET DEFINE OFF;

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('1', 'R0500', 'R0500');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('1', 'R0505', 'R0505');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('1', 'T0102', 'T0102');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('2', 'J0500', 'J0500');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('2', 'L1234', 'L1234');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('3', 'W0104', 'W0104');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('4', 'T0505', 'T0505');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('3', 'T0100', 'T0100');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('5', 'T0107', 'T0107');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('5', 'R0100', 'R0100');

INSERT INTO STK_RO_JOBS (ROHD_ID, JOB_CODE, JOB_DESC)
  VALUES   ('5', 'B0500', 'B0500');

COMMIT;