Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Oracle query- combine 3 different queries into 1

Posted on 2015-01-12
9
Medium Priority
?
159 Views
Last Modified: 2015-01-13
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;

Open in new window



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;

Open in new window


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;

Open in new window


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;

Open in new window



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

Open in new window


 select location_id,
	   count(donor_id) registrations
  from tab1
where drive_date = trunc(sysdate-2)  
group by location_id
 order by 1  	

Open in new window


 
 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 

Open in new window



Expected date

If we take location id LOCN100008

 Expected_data
 
 Location_id, projected_procs,registrations,success_procedures
 
  LOCN100008        78                60                 52


Need help to combine all queries into one
0
Comment
Question by:anumoses
[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
 
LVL 74

Expert Comment

by:sdstuber
ID: 40544770
first, a small suggestion

you can simplify this...

substr(to_char(trunc(sysdate-2), 'DAY'), 1, 3)

to this...

to_char(sysdate-2,'DY')
0
 
LVL 6

Author Comment

by:anumoses
ID: 40544785
Ok thanks
0
 
LVL 74

Accepted Solution

by:
sdstuber earned 2000 total points
ID: 40544801
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), 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)
 WHERE lt_location_id = 'LOCN100008';
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 
LVL 6

Author Comment

by:anumoses
ID: 40544812
But the query you gave me shows the data that I said in the expected data.

data
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 2000 total points
ID: 40544829
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), 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)
   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;
0
 
LVL 74

Assisted Solution

by:sdstuber
sdstuber earned 2000 total points
ID: 40544836
>>> 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
0
 
LVL 74

Expert Comment

by:sdstuber
ID: 40545079
Do you need anything else on either of the queries?
0
 
LVL 6

Author Comment

by:anumoses
ID: 40545083
I think we are on the right track. Similarly I am adding more required columns. So far on track. Thanks
0
 
LVL 6

Author Closing Comment

by:anumoses
ID: 40547359
Thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that useā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question