Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.
Solved
Oracle query- combine 3 different queries into 1
Posted on 2015-01-12
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
5-
4
9 Comments
Active today
first, a small suggestion
you can simplify this...
substr(to_char(trunc(sysda
to this...
to_char(sysdate-2,'DY')
you can simplify this...
substr(to_char(trunc(sysda
to this...
to_char(sysdate-2,'DY')
Active today
I don't get the same registrations count you do, in your expected results,
not even using your sample query
I left out the "unit_id is not null" condition because it's implicit in the count. Aggregates only apply to not null values. You can put it back in though; it's possible it could help on compound indexes with the other columns.
SELECT lt_location_id,
projected_procs,
(SELECT COUNT(donor_id)
FROM tab1
WHERE drive_date = TRUNC(SYSDATE - 2) AND tab1.location_id = lt_location_id)
registrations,
(SELECT COUNT(unit_id)
FROM tab1
WHERE drive_date = TRUNC(SYSDATE - 2)
AND tab1.location_id = lt_location_id
AND term_date IS NULL
-- and unit_id is not null
)
success_procedures
FROM ( SELECT s.lt_location_id,
NVL(
SUM(
DECODE(
TO_CHAR(SYSDATE - 2, 'DY'),
'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),
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)
WHERE lt_location_id = 'LOCN100008';
not even using your sample query
I left out the "unit_id is not null" condition because it's implicit in the count. Aggregates only apply to not null values. You can put it back in though; it's possible it could help on compound indexes with the other columns.
SELECT lt_location_id,
projected_procs,
(SELECT COUNT(donor_id)
FROM tab1
WHERE drive_date = TRUNC(SYSDATE - 2) AND tab1.location_id = lt_location_id)
registrations,
(SELECT COUNT(unit_id)
FROM tab1
WHERE drive_date = TRUNC(SYSDATE - 2)
AND tab1.location_id = lt_location_id
AND term_date IS NULL
-- and unit_id is not null
)
success_procedures
FROM ( SELECT s.lt_location_id,
NVL(
SUM(
DECODE(
TO_CHAR(SYSDATE - 2, 'DY'),
'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),
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)
WHERE lt_location_id = 'LOCN100008';
Active today
and another version as a join
SELECT lt_location_id,
projected_procs,
COUNT(tab1.donor_id) registrations,
COUNT(CASE WHEN term_date IS NULL THEN tab1.unit_id END) success_procedures
FROM tab1,
( SELECT s.lt_location_id,
NVL(
SUM(
DECODE(
TO_CHAR(SYSDATE - 2, 'DY'),
'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),
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)
WHERE lt_location_id = 'LOCN100008'
AND drive_date = TRUNC(SYSDATE - 2)
AND tab1.location_id = lt_location_id
GROUP BY lt_location_id, projected_procs;
SELECT lt_location_id,
projected_procs,
COUNT(tab1.donor_id) registrations,
COUNT(CASE WHEN term_date IS NULL THEN tab1.unit_id END) success_procedures
FROM tab1,
( SELECT s.lt_location_id,
NVL(
SUM(
DECODE(
TO_CHAR(SYSDATE - 2, 'DY'),
'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),
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)
WHERE lt_location_id = 'LOCN100008'
AND drive_date = TRUNC(SYSDATE - 2)
AND tab1.location_id = lt_location_id
GROUP BY lt_location_id, projected_procs;
Active today
>>> But the query you gave me shows the data that I said in the expected data.
Then something is different between your real data and the sample data you posted.
Either of the queries I posted should be correct.
Using the data you posted and this query you posted.
SELECT location_id, COUNT(donor_id) registrations
FROM tab1
WHERE drive_date = TRUNC(SYSDATE - 2)
GROUP BY location_id
ORDER BY 1
I get a count of 52 registrations.
But, if you get 60 and my query returns 60, then it should be correct
Then something is different between your real data and the sample data you posted.
Either of the queries I posted should be correct.
Using the data you posted and this query you posted.
SELECT location_id, COUNT(donor_id) registrations
FROM tab1
WHERE drive_date = TRUNC(SYSDATE - 2)
GROUP BY location_id
ORDER BY 1
I get a count of 52 registrations.
But, if you get 60 and my query returns 60, then it should be correct
I think we are on the right track. Similarly I am adding more required columns. So far on track. Thanks
Featured Post
New feature! Upgrade and increase expert visibility of your issues with Priority Questions.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax:
(CODE)
This way, I guessed, I would ensure that use…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface. I made a script to download the Alert Log, look for errors, and email me the trace files. In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
Suggested Courses
Course of the Month9 days, 10 hours left to enroll
610 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.