-------------------------------------------------------- -- File created - Thursday-April-16-2009 -------------------------------------------------------- -------------------------------------------------------- -- DDL for Table ST_COLIFT -------------------------------------------------------- CREATE TABLE "ST_COLIFT" ( "COLIFTID" NUMBER(10,0), "FIELDID" NUMBER(10,0), "PARTNERID" NUMBER(10,0), "SYSTEMID" NUMBER(10,0), "STARTDATE" DATE, "ENDDATE" DATE, "GROUPID" NUMBER(10,0), "LIFTINGCOORDINATOR" NUMBER(1,0) ) ; -------------------------------------------------------- -- DDL for Table ST_LIFTING -------------------------------------------------------- CREATE TABLE "ST_LIFTING" ( "LIFTINGID" NUMBER(10,0), "LOWERLOADDATE" DATE, "UPPERLOADDATE" DATE, "OTOSENT" DATE, "ETS" DATE, "ETA" DATE, "COMMENTS" VARCHAR2(500), "DOCSRECEIVED" DATE, "DOCSSENT" DATE, "FINALPRICE" NUMBER(13,3), "FINALRATE" NUMBER(13,3), "QUANTITYLOADED" NUMBER(13,3), "QUANTITYDISCHARGED" NUMBER(13,3), "VOYAGENO" NUMBER(10,0), "CARGONO" VARCHAR2(25), "EXTCARGOREF" VARCHAR2(25), "SOLDTO" NUMBER(10,0), "SADSENT" DATE, "DESTINATION" VARCHAR2(50), "PARTNERLIFTING" VARCHAR2(1), "PURCHASEPRICE" NUMBER(13,3), "OTOSENTDATE" DATE, "OTONOMINATEDDATE" DATE, "EOMLIFTING" NUMBER(1,0), "EOMLIFTINGID" NUMBER(10,0), "PAYMENTDUEDATE" DATE, "DEALID" NUMBER(10,0), "CAPTAINID" NUMBER(10,0), "AGENTID" NUMBER(10,0), "VESSELID" NUMBER(10,0), "LIFTINGSTATUSID" NUMBER(10,0), "NETVOLBBLS" NUMBER(13,3), "SYSTEMID" NUMBER(10,0), "CARGONOCOUNTER" NUMBER(10,0), "FIXEDPERIOD" NUMBER(1,0) DEFAULT 0, "CARGOSIZE" NUMBER(6,0), "JOINTLIFTINGID" NUMBER(10,0), "FIXEDLIFTING" NUMBER(1,0), "SPLIT" NUMBER(1,0) DEFAULT 0 ) ; -------------------------------------------------------- -- DDL for Table ST_PARCEL -------------------------------------------------------- CREATE TABLE "ST_PARCEL" ( "PARCELID" NUMBER(10,0), "PARCELDATE" DATE, "ACTUALVOL" NUMBER(13,3), "NOMINATEDVOL" NUMBER(13,3), "VOLINTONNES" NUMBER(13,3), "SOLDTO" NUMBER(10,0), "CARGONO" VARCHAR2(50), "DOCSRECEIVED" DATE, "DOCSSENT" DATE, "DISCHARGEVOL" NUMBER(13,3), "FIELDID" NUMBER(10,0), "LIFTINGID" NUMBER(10,0), "PRODUCTID" NUMBER(10,0), "PARTNERID" NUMBER(10,0), "CARGONOCOUNTER" NUMBER(10,0), "COLIFTID" NUMBER(10,0), "CONSIGNEE" NUMBER(10,0) ) ; --------------------------------------------------- -- DATA FOR TABLE ST_PARCEL -- FILTER = liftingid in (select liftingid from st_lifting where systemid = 100028 and lowerloaddate >= '30-apr-2009') --------------------------------------------------- REM INSERTING into ST_PARCEL Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327764,to_timestamp('07-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),486592.593,null,0,null,'S-243\HD144',null,null,null,100088,202357,29,100008,144,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327765,to_timestamp('07-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),13407.407,null,0,null,'S-243\HD144',null,null,null,100088,202357,29,100401,144,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327766,to_timestamp('21-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),40076.336,null,null,null,'S-244A\DO100A',null,null,null,100088,202358,29,100402,100,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327767,to_timestamp('21-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),209923.664,null,null,null,'S-244A\DO100A',null,null,null,100088,202358,29,100403,100,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327785,to_timestamp('17-JUN-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),13407.407,null,null,null,'S-245\HD145',null,null,null,100088,202359,29,100401,145,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327784,to_timestamp('17-JUN-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),486592.593,null,null,null,'S-245\HD145',null,null,null,100088,202359,29,100008,145,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327786,to_timestamp('14-JUL-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),486592.593,null,null,null,'S-246\HD146',null,null,null,100088,202360,29,100008,146,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327787,to_timestamp('14-JUL-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),13407.407,null,null,null,'S-246\HD146',null,null,null,100088,202360,29,100401,146,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327788,to_timestamp('11-AUG-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),80152.672,null,null,null,'S-247\DO101',null,null,null,100088,202361,29,100402,101,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327789,to_timestamp('11-AUG-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),419847.328,null,null,null,'S-247\DO101',null,null,null,100088,202361,29,100403,101,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327790,to_timestamp('08-SEP-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),486592.593,null,null,null,'S-248\HD147',null,null,null,100088,202362,29,100008,147,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327791,to_timestamp('08-SEP-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),13407.407,null,null,null,'S-248\HD147',null,null,null,100088,202362,29,100401,147,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327792,to_timestamp('07-OCT-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),80152.672,null,null,null,'S-249\DO102',null,null,null,100088,202363,29,100402,102,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327793,to_timestamp('07-OCT-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),419847.328,null,null,null,'S-249\DO102',null,null,null,100088,202363,29,100403,102,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327794,to_timestamp('06-NOV-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),486592.593,null,null,null,'S-250\HD148',null,null,null,100088,202375,29,100008,148,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327795,to_timestamp('06-NOV-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),13407.407,null,null,null,'S-250\HD148',null,null,null,100088,202375,29,100401,148,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327798,to_timestamp('24-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),40076.336,null,null,null,'S-244B\DO100B',null,null,null,100088,202443,29,100402,100,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327799,to_timestamp('24-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),209923.664,null,null,null,'S-244B\DO100B',null,null,null,100088,202443,29,100403,100,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327782,to_timestamp('02-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),40076.336,null,0,null,'S-242B\DO99B',null,null,null,100088,202442,29,100402,99,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327783,to_timestamp('02-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),209923.664,null,0,null,'S-242B\DO99B',null,null,null,100088,202442,29,100403,99,100013,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327796,to_timestamp('06-DEC-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),486592.593,null,null,null,'S-251\HD149',null,null,null,100088,202441,29,100008,149,100012,null); Insert into ST_PARCEL (PARCELID,PARCELDATE,ACTUALVOL,NOMINATEDVOL,VOLINTONNES,SOLDTO,CARGONO,DOCSRECEIVED,DOCSSENT,DISCHARGEVOL,FIELDID,LIFTINGID,PRODUCTID,PARTNERID,CARGONOCOUNTER,COLIFTID,CONSIGNEE) values (1327797,to_timestamp('06-DEC-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),13407.407,null,null,null,'S-251\HD149',null,null,null,100088,202441,29,100401,149,100012,null); --------------------------------------------------- -- END DATA FOR TABLE ST_PARCEL --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE ST_LIFTING -- FILTER = systemid = 100028 and lowerloaddate >= '30-apr-2009' --------------------------------------------------- REM INSERTING into ST_LIFTING Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202357,to_timestamp('07-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('07-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,0,0,0,0,'S-243',null,null,null,null,null,0,null,null,0,0,null,null,null,null,100025,3,null,100028,243,0,0,0,1,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202358,to_timestamp('20-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('22-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-244A',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,244,0,null,0,1,1); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202359,to_timestamp('14-JUN-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('20-JUN-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-245',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,245,0,null,0,0,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202360,to_timestamp('11-JUL-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('17-JUL-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-246',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,246,0,null,0,0,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202361,to_timestamp('08-AUG-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('14-AUG-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-247',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,247,0,null,0,0,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202362,to_timestamp('05-SEP-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('11-SEP-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-248',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,248,0,null,0,0,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202363,to_timestamp('04-OCT-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('10-OCT-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-249',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,249,0,null,0,0,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202375,to_timestamp('03-NOV-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('09-NOV-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-250',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,250,0,null,0,0,0); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202443,to_timestamp('23-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('25-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-244B',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,244,0,null,0,1,1); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202442,to_timestamp('01-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('01-MAY-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,0,0,0,0,'S-242B',null,null,null,null,null,0,null,null,0,0,null,null,null,null,100025,3,null,100028,242,0,0,0,1,1); Insert into ST_LIFTING (LIFTINGID,LOWERLOADDATE,UPPERLOADDATE,OTOSENT,ETS,ETA,COMMENTS,DOCSRECEIVED,DOCSSENT,FINALPRICE,FINALRATE,QUANTITYLOADED,QUANTITYDISCHARGED,VOYAGENO,CARGONO,EXTCARGOREF,SOLDTO,SADSENT,DESTINATION,PARTNERLIFTING,PURCHASEPRICE,OTOSENTDATE,OTONOMINATEDDATE,EOMLIFTING,EOMLIFTINGID,PAYMENTDUEDATE,DEALID,CAPTAINID,AGENTID,VESSELID,LIFTINGSTATUSID,NETVOLBBLS,SYSTEMID,CARGONOCOUNTER,FIXEDPERIOD,CARGOSIZE,JOINTLIFTINGID,FIXEDLIFTING,SPLIT) values (202441,to_timestamp('03-DEC-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),to_timestamp('09-DEC-09 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,null,null,null,null,null,null,null,null,null,null,'S-251',null,null,null,null,null,null,null,null,null,null,null,null,null,null,100025,2,null,100028,251,0,null,0,0,0); --------------------------------------------------- -- END DATA FOR TABLE ST_LIFTING --------------------------------------------------- --------------------------------------------------- -- DATA FOR TABLE ST_COLIFT -- FILTER = groupid = 100013 --------------------------------------------------- REM INSERTING into ST_COLIFT Insert into ST_COLIFT (COLIFTID,FIELDID,PARTNERID,SYSTEMID,STARTDATE,ENDDATE,GROUPID,LIFTINGCOORDINATOR) values (200575,100088,100403,100028,to_timestamp('01-JUN-99 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,100013,1); Insert into ST_COLIFT (COLIFTID,FIELDID,PARTNERID,SYSTEMID,STARTDATE,ENDDATE,GROUPID,LIFTINGCOORDINATOR) values (200576,100088,100402,100028,to_timestamp('01-JUN-99 00.00.00.000000000','DD-MON-RR HH24.MI.SS.FF'),null,100013,0); --------------------------------------------------- -- END DATA FOR TABLE ST_COLIFT ---------------------------------------------------