CREATE TABLE TEMPA
(
  P_UNIQUEID       NUMBER(8),
  COMPCODE         NUMBER(4),
  COUNTRYCD        NUMBER(4),
  STATECD          NUMBER(4),
  DISTRICTCD       NUMBER(4),
  PRODUCTCD        VARCHAR2(50 BYTE),
  STARTDATE        DATE,
  DISCONTINUEDATE  DATE
)
LOGGING 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE TABLE TEMPB
(
  COUNTRYCD  NUMBER(4)
)
LOGGING 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE TABLE TEMPC
(
  COUNTRYCD  NUMBER(4),
  STATECD    NUMBER(4)
)
LOGGING 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE TABLE TEMPD
(
  COUNTRYCD   NUMBER(4),
  STATECD     NUMBER(4),
  DISTRICTCD  NUMBER(4)
)
LOGGING 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE TABLE TEMPE
(
  COMPCODE         NUMBER(4)                    NOT NULL,
  PRODUCTCD        VARCHAR2(50 BYTE)            NOT NULL,
  COUNTRYCD        NUMBER(4),
  STATECD          NUMBER(4),
  DISTRICTCD       NUMBER(4),
  SCHEMECD         NUMBER(8)                    NOT NULL,
  PARTYCODE        VARCHAR2(10 BYTE),
  USERID           VARCHAR2(30 BYTE)            NOT NULL,
  SCHEMEFRDATE     DATE                         NOT NULL,
  SCHEMETODATE     DATE                         NOT NULL,
  SCHEMESHORTDESC  VARCHAR2(30 BYTE)            NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL
NOMONITORING;


CREATE TABLE TEMPF
(
  COMPCODE    NUMBER(4)                         NOT NULL,
  PRODUCTCD   VARCHAR2(50 BYTE)                 NOT NULL,
  SCHEMETYPE  VARCHAR2(5 BYTE)                  NOT NULL,
  SCHEMECD    NUMBER(8)                         NOT NULL
)
LOGGING 
NOCACHE
NOPARALLEL
NOMONITORING;



SET DEFINE OFF;
Insert into TEMPA
   (P_UNIQUEID, COMPCODE, COUNTRYCD, STATECD, DISTRICTCD, 
    PRODUCTCD, STARTDATE, DISCONTINUEDATE)
 Values
   (5233, 3, 1, 3, 999, 
    'WB-BROKENS-500 GMS-POUCH', TO_DATE('10/11/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/9999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
Insert into TEMPA
   (P_UNIQUEID, COMPCODE, COUNTRYCD, STATECD, DISTRICTCD, 
    PRODUCTCD, STARTDATE, DISCONTINUEDATE)
 Values
   (5234, 3, 1, 3, 999, 
    'WB-BROKENS-1 KGS-POUCH', TO_DATE('10/11/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/31/9999 00:00:00', 'MM/DD/YYYY HH24:MI:SS'));
COMMIT;

SET DEFINE OFF;
Insert into TEMPB
   (COUNTRYCD)
 Values
   (1);
Insert into TEMPB
   (COUNTRYCD)
 Values
   (999);
COMMIT;

SET DEFINE OFF;
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (1, 3);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (1, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (2, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (3, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (4, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (5, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (6, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (7, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (8, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (9, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (10, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (11, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (12, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (13, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (14, 999);
Insert into TEMPC
   (COUNTRYCD, STATECD)
 Values
   (999, 999);
COMMIT;

SET DEFINE OFF;
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (1, 14, 22);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (1, 14, 23);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (1, 14, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (1, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (2, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (3, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (4, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (5, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (6, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (7, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (8, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (9, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (10, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (11, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (12, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (13, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (14, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (15, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (16, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (17, 999, 999);
Insert into TEMPD
   (COUNTRYCD, STATECD, DISTRICTCD)
 Values
   (999, 999, 999);
COMMIT;

SET DEFINE OFF;
Insert into TEMPE
   (COMPCODE, PRODUCTCD, COUNTRYCD, STATECD, DISTRICTCD, 
    SCHEMECD, PARTYCODE, USERID, SCHEMEFRDATE, SCHEMETODATE, 
    SCHEMESHORTDESC)
 Values
   (3, 'WB-BROKENS-500 GMS-POUCH', 1, 14, 999, 
    1554, '999', 'chintan.patel', TO_DATE('12/25/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/07/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    '50gmWBMasalaOnWBLeaf500gm');
Insert into TEMPE
   (COMPCODE, PRODUCTCD, COUNTRYCD, STATECD, DISTRICTCD, 
    SCHEMECD, PARTYCODE, USERID, SCHEMEFRDATE, SCHEMETODATE, 
    SCHEMESHORTDESC)
 Values
   (3, 'WB-BROKENS-500 GMS-POUCH', 1, 3, 999, 
    1554, '999', 'chintan.patel', TO_DATE('12/25/2010 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('01/07/2011 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 
    '50gmWBMasalaOnWBLeaf500gm');
COMMIT;

SET DEFINE OFF;
Insert into TEMPF
   (COMPCODE, PRODUCTCD, SCHEMETYPE, SCHEMECD)
 Values
   (3, 'WB-BROKENS-500 GMS-POUCH', 'DIFWP', 1554);
COMMIT;