Oracle query- combine 3 different queries into 1
CREATE TABLE TAB1
(
LOCATION_ID VARCHAR2(10 BYTE) NOT NULL,
DONOR_ID VARCHAR2(10 BYTE),
DRIVE_ID VARCHAR2(10 BYTE) NOT NULL,
DRIVE_DATE DATE NOT NULL,
UNIT_ID VARCHAR2(15 BYTE),
TERM_DATE DATE
)
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00189451', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969081',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00185854', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969531',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20336378', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969568',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20089289', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969571',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00176740', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969672',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20014126', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008548',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20227768', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008537',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00331942', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969073',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00577736', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969796',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20312150', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994534',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20250554', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008526',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00326914', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969662',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00372642', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008545',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00157915', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008525',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00556441', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008544',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00018711', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715008524',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00529004', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969529',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20185057', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970489',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20295280', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969569',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00409932', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969567',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00166168', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969528',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00371716', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969527',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00214596', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969526',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00060250', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969525',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20138326', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970488',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20251512', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970487',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00576966', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970491',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20249583', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969551',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00478059', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970490',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00112009', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969523',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00496612', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969522',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20347087', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969524',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20335034', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970495',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00001841', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969530',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00418514', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969532',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20305783', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969535',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20239499', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969536',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00153002', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969577',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20307239', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969533',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20227299', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969534',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20174249', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969576',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00486087', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969575',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20333650', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969572',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00272111', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969574',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00014624', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969573',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00383435', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969570',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00452122', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970486',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00223275', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969791',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20347090', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970492',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN20318024', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970494',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00207602', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970493',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100008', 'DN00594492', 'DRV5545739', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969550',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20074403', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715000049',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20051365', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977450',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN00211739', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977451',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN00419750', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977416',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20326946', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977406',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN00191108', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977407',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN00579185', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977409',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20061195', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977408',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20259824', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977456',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20309947', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977454',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN00112978', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977453',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN20111541', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977455',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100009', 'DN00450581', 'DRV5549119', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977452',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00131142', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001503',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00472404', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001544',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00240364', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001509',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00198337', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001528',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20284166', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001512',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20190520', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001518',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20281674', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001527',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00545173', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001507',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00285865', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001508',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00002889', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001545',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00229169', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001506',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00219035', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715001511',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20284691', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992035',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00508229', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992043',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00016736', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992112',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20055788', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992048',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00349124', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992050',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20014217', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992044',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00371948', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992031',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00152044', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992045',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00483703', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992032',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20334732', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992042',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00240109', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992037',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00465182', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992041',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20335099', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992036',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00499732', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992038',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00223705', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992039',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00526340', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992040',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00131525', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992034',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20279436', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992033',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20118376', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992118',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00343796', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992119',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20186732', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992120',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20106465', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992117',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00062045', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992115',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20097868', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992116',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00089394', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992114',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00151195', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992113',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00302842', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992111',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00112695', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992108',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00249130', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992110',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN00064378', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992109',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100024', 'DN20243641', 'DRV5549431', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992107',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20049094', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990390',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20314903', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990271',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00522798', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990239',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20333527', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990247',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00302711', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990309',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00067886', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990234',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00286042', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990308',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20305359', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990241',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00268129', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990310',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00138117', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990243',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00465594', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990249',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20281663', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990237',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00165604', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990233',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00164156', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990235',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20320093', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990238',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20000788', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990311',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20320096', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990231',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20021591', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990274',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00219727', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990443',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20039930', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990236',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00536522', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990312',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00243118', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990377',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20191350', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990272',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN20340395', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990269',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100014', 'DN00320860', 'DRV5546987', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990444',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20335638', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012045',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20293710', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012046',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00463432', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012044',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20338697', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012048',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00547072', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012028',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00296468', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012049',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00528712', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012056',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20026128', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012047',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00378008', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012091',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00196999', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012053',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20247258', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012054',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00454593', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012058',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20046910', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012050',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20297458', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012052',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00566966', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012057',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20285549', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977299',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20095348', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977301',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20322186', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012051',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20127698', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977298',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20086061', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977300',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00306022', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012095',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20323603', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977297',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20257166', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990961',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00133705', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977305',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20240881', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977296',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00107062', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977302',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20096417', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977303',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20250498', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970479',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20087654', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012011',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00304312', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970478',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20058769', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990960',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20126511', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970480',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00518838', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970481',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00453932', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970485',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00494738', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970482',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00407784', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970483',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN20285747', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970484',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00483186', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970474',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200034', 'DN00604642', 'DRV5548235', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970473',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00206322', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002052',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00228216', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002053',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00049434', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991912',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20245882', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002047',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00586195', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002048',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00176425', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002091',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20104034', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002092',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00344877', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002049',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20092642', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002051',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20134505', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002055',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00447085', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002093',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20196048', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002056',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00417664', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002054',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20246919', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002095',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20054436', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002057',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN00303077', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002058',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100319', 'DN20205540', 'DRV5547923', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002059',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN20343324', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979976',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00481390', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002531',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN20291728', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979982',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00381392', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979973',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00524078', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979975',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN20088076', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979983',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00454880', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979981',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00377839', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979972',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00250134', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979979',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00481514', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002540',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN20292546', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979984',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00567417', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979977',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00568196', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979980',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN20263639', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979985',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN00483078', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715002537',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100326', 'DN20221707', 'DRV5547611', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979986',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20206469', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989979',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20219523', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989943',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00116029', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003058',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00054535', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989948',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00185110', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989946',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20221024', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989945',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20188491', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989944',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20042259', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989947',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00313601', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003023',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00590454', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989976',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00085433', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989937',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20332998', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989940',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00346946', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989941',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00092555', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989942',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20265633', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989934',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20125746', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989935',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00599301', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989936',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20243267', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989939',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20286534', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003091',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00343074', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003103',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20216369', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003093',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20110045', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989923',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00281400', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989977',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00508080', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003092',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20302103', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003104',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00376130', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003105',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN00479913', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003097',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20120511', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003096',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20347082', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003100',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20331036', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003098',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20127747', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715003099',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN102725', 'DN20105580', 'DRV5547299', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989978',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00591546', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714995983',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00398939', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998781',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20239583', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998904',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00054513', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998859',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20227748', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998906',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20123541', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998909',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20266789', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998860',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20133034', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998902',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20254530', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998903',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00080548', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998857',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20303816', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998858',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20048224', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998913',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20253442', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998871',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20227150', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998870',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00239891', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998866',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20271296', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998865',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00325070', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998864',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20216326', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998863',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00547845', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998862',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20337119', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998907',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20282893', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998905',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20138679', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998908',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00431621', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998782',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20013716', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998784',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20155789', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998861',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20347083', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998761',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20340319', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998868',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20081685', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998867',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00511454', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998869',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20280787', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998771',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20300130', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998783',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN20050911', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998770',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN100373', 'DN00350440', 'DRV5548807', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998774',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00283818', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010026',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00300917', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990365',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20171823', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990364',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00509605', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990368',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00481929', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970067',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00057918', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990367',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00485006', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010002',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20336013', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990372',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20087574', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970065',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20114978', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970068',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00424718', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970064',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20043045', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010024',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00533471', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990370',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00143946', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010023',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20196218', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010025',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20266873', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010027',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00305105', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010001',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20347081', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010034',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00592055', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010006',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20334475', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010020',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00363563', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010033',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20269175', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010021',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20130486', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010029',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20171884', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010022',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00386794', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010028',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20343179', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010048',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20331527', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010030',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN20078990', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010032',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00382414', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010046',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00501902', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010005',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN101661', 'DN00116404', 'DRV5546363', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715010044',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00432772', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984825',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20062847', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984820',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00312147', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012506',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20335664', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984822',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00337989', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984826',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20280680', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984824',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20048890', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984827',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00562407', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012539',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00376446', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012563',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00592120', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012541',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20181516', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012511',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20200841', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012545',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00526023', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012546',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20203533', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012540',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20276209', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012544',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20281620', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012552',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00563949', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012542',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20136195', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984814',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00349485', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012512',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20271650', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984813',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00064913', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984815',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20271339', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984817',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20222808', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984818',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00209884', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984821',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20318933', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984819',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN00444622', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715012520',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201860', 'DN20252181', 'DRV5549743', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984823',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN00287680', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963434',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20092894', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963433',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20317221', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963486',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20341562', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963489',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20347093', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963487',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20241934', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963482',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN00483689', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963416',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20280400', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963488',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20264558', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963484',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20264238', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963483',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20238190', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963481',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20238223', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963476',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20091046', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963480',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20093121', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963479',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20331157', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963414',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20009850', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963477',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20189422', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963413',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN00371929', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963411',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20094372', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963418',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20308634', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963412',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20163006', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963415',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN202068', 'DN20072647', 'DRV5546051', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963417',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN20267287', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013040',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN20076047', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013077',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00170815', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013078',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00484433', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013079',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00194065', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013095',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00331808', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013042',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00011105', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013041',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00007030', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013052',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00382001', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013053',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00090813', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013055',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00085051', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013056',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00257686', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013067',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00084444', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013054',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00094457', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013068',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00593435', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013070',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00185552', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013069',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00567203', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013071',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00509036', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013075',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00509035', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013076',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00440305', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013073',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN200492', 'DN00083775', 'DRV5546675', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039715013072',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN00114154', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978809',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN00039504', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978813',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN20092045', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978810',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN00203834', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978814',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN20216153', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978812',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN20166354', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978811',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN00508717', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978816',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN20142897', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978818',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN00424978', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978815',
NULL);
Insert into TAB1
(LOCATION_ID, DONOR_ID, DRIVE_ID, DRIVE_DATE, UNIT_ID,
TERM_DATE)
Values
('LOCN201102', 'DN20293646', 'DRV5548545', TO_DATE('01/10/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714978817',
NULL);
COMMIT;CREATE TABLE TAB2
(
DEPT_ID NUMBER NOT NULL,
PROC_CODE VARCHAR2(2 BYTE) NOT NULL,
DAY_SUNDAY NUMBER(4) NOT NULL,
DAY_MONDAY NUMBER(4) NOT NULL,
DAY_TUESDAY NUMBER(4) NOT NULL,
DAY_WEDNESDAY NUMBER(4) NOT NULL,
DAY_THURSDAY NUMBER(4) NOT NULL,
DAY_FRIDAY NUMBER(4) NOT NULL,
DAY_SATURDAY NUMBER(4) NOT NULL
)
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(10, 'PP', 0, 29, 29,
22, 22, 20, 30);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(90, 'PP', 0, 5, 5,
5, 5, 5, 5);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(11, 'PP', 0, 3, 3,
3, 3, 3, 4);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(12, 'PP', 0, 3, 3,
2, 2, 2, 3);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(13, 'PP', 0, 5, 5,
4, 4, 5, 5);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(14, 'PP', 0, 3, 3,
2, 2, 2, 3);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(20, 'PP', 0, 3, 3,
2, 2, 2, 3);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(3, 'PP', 0, 3, 3,
2, 2, 2, 3);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(21, 'PP', 0, 4, 4,
4, 4, 4, 5);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(22, 'PP', 0, 4, 4,
4, 4, 4, 5);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(23, 'PP', 0, 5, 5,
5, 5, 3, 6);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(24, 'PP', 0, 3, 3,
3, 3, 3, 3);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(33, 'PP', 0, 3, 3,
2, 2, 2, 3);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(10, 'DR', 0, 2, 2,
2, 2, 2, 2);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(10, 'WB', 0, 36, 36,
36, 36, 36, 46);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(33, 'WB', 0, 12, 12,
12, 12, 10, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(3, 'WB', 0, 20, 20,
20, 20, 15, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(24, 'WB', 0, 13, 13,
13, 13, 10, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(12, 'WB', 0, 14, 14,
14, 14, 11, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(31, 'WB', 0, 8, 8,
8, 8, 8, 8);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(21, 'WB', 0, 17, 17,
17, 17, 13, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(20, 'WB', 0, 17, 17,
17, 17, 13, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(11, 'WB', 0, 26, 26,
26, 26, 20, 30);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(39, 'WB', 0, 8, 8,
8, 8, 8, 8);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(22, 'WB', 0, 21, 21,
21, 21, 16, 25);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(27, 'WB', 0, 12, 12,
12, 12, 0, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(37, 'WB', 0, 0, 0,
0, 0, 0, 0);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(90, 'WB', 0, 27, 27,
27, 27, 27, 30);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(14, 'WB', 0, 18, 18,
18, 18, 14, 22);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(13, 'WB', 0, 18, 18,
18, 18, 14, 22);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(23, 'WB', 0, 13, 13,
13, 13, 13, 20);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(90, 'DR', 0, 1, 1,
1, 1, 1, 1);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(11, 'DR', 0, 1, 1,
1, 1, 1, 1);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(13, 'DR', 0, 1, 1,
1, 1, 1, 1);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(21, 'DR', 0, 1, 1,
1, 1, 1, 1);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(22, 'DR', 0, 1, 1,
1, 1, 1, 1);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(23, 'DR', 0, 1, 1,
1, 1, 1, 1);
Insert into TAB2
(DEPT_ID, PROC_CODE, DAY_SUNDAY, DAY_MONDAY, DAY_TUESDAY,
DAY_WEDNESDAY, DAY_THURSDAY, DAY_FRIDAY, DAY_SATURDAY)
Values
(24, 'DR', 0, 1, 1,
1, 1, 1, 1);
COMMIT;CREATE TABLE TAB3
(
DEPT_ID NUMBER,
LT_LOCATION_ID VARCHAR2(10 BYTE) NOT NULL
)
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(11, 'LOCN100319');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(20, 'LOCN100326');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(10, 'LOCN100008');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(14, 'LOCN100009');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(22, 'LOCN200034');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(90, 'LOCN100373');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(3, 'LOCN101661');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(21, 'LOCN102725');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(12, 'LOCN100014');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(13, 'LOCN100024');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(24, 'LOCN200492');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(31, 'LOCN201120');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(23, 'LOCN201860');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(39, 'LOCN201749');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(37, 'LOCN201489');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(33, 'LOCN202068');
Insert into TAB3
(DEPT_ID, LT_LOCATION_ID)
Values
(27, 'LOCN201102');
COMMIT;CREATE TABLE TAB4
(
DEPT_ID NUMBER NOT NULL,
PROC_CODE VARCHAR2(2 BYTE) NOT NULL,
GOAL_OVERRIDE_DATE DATE NOT NULL,
OVERRIDE_GOAL NUMBER(4)
)
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'PP', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 28);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'PP', TO_DATE('01/03/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 34);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'PP', TO_DATE('01/05/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 27);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'PP', TO_DATE('01/06/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 27);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(22, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(22, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(22, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(22, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(22, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(27, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(90, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(90, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(90, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(90, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(90, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(14, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(14, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(14, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(14, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(13, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(13, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(13, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(13, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(23, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(23, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(23, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(23, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(23, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(10, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(33, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(33, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(33, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(33, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(3, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(3, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(3, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(3, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(24, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(24, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(24, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(24, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(24, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(12, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(12, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(12, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(12, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(21, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(21, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(21, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(21, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(21, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(20, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(20, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(20, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(20, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(11, 'WB', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(11, 'PP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(11, 'JP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(11, 'CP', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
Insert into TAB4
(DEPT_ID, PROC_CODE, GOAL_OVERRIDE_DATE, OVERRIDE_GOAL)
Values
(11, 'DR', TO_DATE('01/01/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 0);
COMMIT;select s.lt_location_id,nvl(sum(decode(substr(to_char(trunc(sysdate-2), 'DAY'), 1, 3), 'SUN', g.day_sunday,
'MON', g.day_monday,
'TUE', g.day_tuesday,
'WED', g.day_wednesday,
'THU', g.day_thursday,
'FRI', g.day_friday,
'SAT', g.day_saturday)), 0) projected_procs
from tab2 g,
tab3 s
where g.proc_code in ('WB','PP','DR')
and g.dept_id = s.dept_id
and s.lt_location_id not in ('LOCN201749' , 'LOCN201489', 'LOCN201120')
and not exists(select 'x'
from tab4 go
where go.dept_id = g.dept_id
and go.proc_code = g.proc_code
and go.goal_override_date = trunc(sysdate-2)
and go.override_goal is not null)
group by s.lt_location_id
union all
select s.lt_location_id,nvl(sum(go.override_goal),0)
from tab4 go,
tab3 s
where go.proc_code in ('WB','PP','DR')
and go.goal_override_date = trunc(sysdate-2)
and go.override_goal is not null
and go.dept_id = s.dept_id
and s.lt_location_id not in ('LOCN201749' , 'LOCN201489', 'LOCN201120')
group by s.lt_location_id select location_id,
count(donor_id) registrations
from tab1
where drive_date = trunc(sysdate-2)
group by location_id
order by 1
select location_id,
count(unit_id) success_procedures
from tab1
where drive_date = trunc(sysdate-2)
and term_date is null
and unit_id is not null
group by location_id
order by 1 Expected date
If we take location id LOCN100008
 Expected_data
Â
 Location_id, projected_procs,registrati
Â
 LOCN100008     78         60         52
Need help to combine all queries into one
ASKER
Ok thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
But the query you gave me shows the data that I said in the expected data.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Do you need anything else on either of the queries?
ASKER
I think we are on the right track. Similarly I am adding more required columns. So far on track. Thanks
ASKER
Thanks
you can simplify this...
substr(to_char(trunc(sysda
to this...
to_char(sysdate-2,'DY')