PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Course Of The Month
2 days, 8 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
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
An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.
One of a set of tools we're offering as a way of saying thank you for being a part of the community.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime? I'm talking things like:
* Dropping columns
* Shrinking allocated space
* Removing chained blocks and restoring the PCTFREE
* Re-or…
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…
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month2 days, 8 hours left to enroll
Earn Certification
Certified Information Systems Auditor (CISA)
$99.00$89.10
719 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.