CREATE TABLE MPS.MPS_V_INV_GST
(
INV_NO   VARCHAR2(3),
INV_DATE DATE,
GROSS    NUMBER,
MRQ_NO   VARCHAR2(3),
MRQ_DATE DATE,
INVNO    VARCHAR2(3),
MRQ_GROSS NUMBER
)
LOGGING 
NOCACHE
NOPARALLEL;

SET DEFINE OFF;
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5040, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3031.6, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/01/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1820.63, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9562.8, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7906.8, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13256.21, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2900.85, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9069.95, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/03/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5000.58, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1380.7, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4686.7, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/04/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5947.14, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/05/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5152.6, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/05/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4011.4, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/05/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 9661.72, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/06/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1955.3, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/06/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 3161, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/06/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10711.05, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8467.35, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7799.4, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/08/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1463.01, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/09/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1406.55, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/09/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 16019.4, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/09/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 17397.74, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/10/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2779.75, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/10/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 7985.14, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/10/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 27124.68, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/11/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1527.2, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/11/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5994.8, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/11/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13321.26, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/12/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 651.35, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/12/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12524.95, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/12/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 19748.25, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 700.25, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 1125, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 13415.1, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 6358.65, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4545.5, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 4376.44, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOC', TO_DATE('09/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2925.8, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOI', TO_DATE('09/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2088.45, 0);
Insert into MPS_V_INV_GST
   (INV_NO, INV_DATE, GROSS, MRQ_GROSS)
 Values
   ('MOS', TO_DATE('09/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10280.16, 0);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOI', 316.4);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/02/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOS', 40.8);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/09/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOS', 136);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/10/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOI', 2194.3);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/11/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOI', 702.4);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/11/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOS', 6455.63);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/13/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOI', 732);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/15/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOS', 63);
Insert into MPS_V_INV_GST
   (GROSS, MRQ_NO, MRQ_DATE, INVNO, MRQ_GROSS)
 Values
   (0, 'MRQ', TO_DATE('09/16/2008 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'MOS', 7131.64);
COMMIT;