Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

oracle query

Posted on 2015-01-07
12
Medium Priority
?
100 Views
Last Modified: 2015-01-13
http://www.experts-exchange.com/Database/Oracle/Q_28591381.html

Requirements changed.

tab1, tab2 and tab3 are reconstructed with sample data.

tab1 is blood_drives
tab2 is donations
tab3 is donation_attributes

Below is my original query. case statement6 has changed to count(unit_id) since the user wants only donations and not products.

select area_rep_no,drive_date,site_code,sponsor_group_code,
       procedure_code,count(unit_id) as cnt
  from blood_drives bd,donations_don d
 where 'DRV'||bd.drive_id = d.drive_id
   and drive_date between To_date('02-jan-2015', 'dd-mon-yyyy') AND To_date( 
                                    '02-jan-2015', 'dd-mon-yyyy') 
   and d.unit_id is not null
   and not exists (select transaction_id 
                             from donation_attributes_don da
                          where da.attrib_code = 'VENI'
	             and d.transaction_id = da.transaction_id
                             and da.attrib_value in ('04','05'))
  group by drive_date,area_rep_no,procedure_code,site_code,sponsor_group_code
   order by 1,2,5

Open in new window


CREATE TABLE TAB1
(
  DRIVE_DATE          DATE                      NOT NULL,
  DRIVE_ID            NUMBER(7)                 NOT NULL,
  SITE_CODE           VARCHAR2(5 BYTE)          NOT NULL,
  SPONSOR_GROUP_CODE  VARCHAR2(5 BYTE)          NOT NULL,
  AREA_REP_NO         NUMBER(4)                 NOT NULL
)



Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2026338, 'CH02', 'CH02', 10);
Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2026437, 'GV08', 'GV08', 5);
Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2026365, 'LF03', 'LF03', 15);
Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2026366, 'LF05', 'LF05', 15);
Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2025666, 'NA06', 'NA06', 8);
Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2026311, 'OK18', 'OK18', 12);
Insert into TAB1
   (DRIVE_DATE, DRIVE_ID, SITE_CODE, SPONSOR_GROUP_CODE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 2026337, 'OP04', 'OP04', 10);
COMMIT;

Open in new window


CREATE TABLE TAB2
(
  PROCEDURE_CODE  VARCHAR2(5 BYTE),
  TRANSACTION_ID  VARCHAR2(10 BYTE)             NOT NULL,
  COLL_DATE       DATE                          NOT NULL,
  UNIT_ID         VARCHAR2(15 BYTE)
)

Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361509', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714951000');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361510', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996895');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361512', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996770');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361514', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996767');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361515', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996894');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361516', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996762');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361518', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996771');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361520', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996763');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361522', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996882');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361524', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996764');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361527', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996765');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361528', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996887');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361529', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996893');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361530', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996885');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361531', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996766');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361532', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996896');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361533', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996768');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361534', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996892');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361535', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996886');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361536', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977326');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361158', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977196');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361169', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977238');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361170', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977200');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361511', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950772');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361513', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950774');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361517', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950773');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361519', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361521', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361523', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361525', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361526', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361571', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05362055', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996703');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05362056', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996707');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05362057', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996712');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05362058', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990287');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05362098', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361172', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977198');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361178', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977232');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361182', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977225');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361187', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977233');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361188', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361189', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361201', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977226');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361202', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977227');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361203', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977343');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361207', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977229');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361236', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977235');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361246', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977230');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361190', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714993911');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361191', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998654');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361193', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998649');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361194', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998673');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361195', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998672');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361196', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998671');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361197', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998670');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361198', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998681');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361199', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998627');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361200', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998684');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361209', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998680');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361222', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361163', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994847');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361165', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994845');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361167', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987485');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361168', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994840');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361171', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994843');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361175', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987484');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361177', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987482');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361179', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987481');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361180', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994850');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361183', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992065');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361184', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994846');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PL', 'TR05361204', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987066');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361205', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994853');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361229', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992064');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361231', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987480');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361232', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992025');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361234', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994851');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('RP', 'TR05361248', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992024');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361250', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994849');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361211', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984679');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361214', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984680');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361218', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984677');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361221', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984764');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361226', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984678');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361227', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984765');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361230', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984776');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361235', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361237', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361238', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361243', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714955127');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361208', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361228', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361210', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998697');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361212', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998698');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361213', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998678');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361215', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998675');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361216', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998679');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361219', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714995040');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361220', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998676');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361223', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998674');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361224', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998696');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361225', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998677');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361239', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998648');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361240', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714995991');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361241', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998699');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361242', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998695');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361244', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998622');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361245', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714993910');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361247', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998690');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361249', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998693');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361255', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986625');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361257', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986623');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361263', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986622');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361265', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986621');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361271', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992023');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('RP', 'TR05361283', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990144');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361286', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990172');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361288', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990171');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361290', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990289');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361292', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990288');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361294', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990202');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361296', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990227');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361298', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990225');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361300', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990206');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361301', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990204');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361303', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990211');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361304', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990201');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361305', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990203');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361306', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990220');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361307', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990229');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361308', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990224');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361309', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990200');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361310', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990222');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361311', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990226');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361314', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990979');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361317', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977332');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361319', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990987');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361321', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990978');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361322', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990986');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361324', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990989');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361327', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977328');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361164', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979713');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('HH', 'TR05361166', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979789');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361173', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979911');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361174', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979915');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361176', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979918');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361181', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361185', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979914');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361186', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979908');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361217', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979712');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361233', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979913');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361329', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977329');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361331', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977330');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361334', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977254');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361335', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977253');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361336', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977333');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361337', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977334');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361338', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977336');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361339', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361341', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361344', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977248');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361347', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977327');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361349', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977325');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361352', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977324');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361353', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990728');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361355', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977335');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361358', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977316');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361360', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977315');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361362', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977310');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361364', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977313');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361366', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361368', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977309');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361370', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977323');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361372', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977314');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361374', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977312');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361382', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989420');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361386', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989421');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361388', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989412');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361390', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989415');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361393', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989423');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361395', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989417');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361396', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989416');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361397', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989483');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361398', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989481');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361399', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989482');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361400', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989485');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361401', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989462');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('RS', 'TR05361408', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973486');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361411', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973499');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361412', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970136');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361413', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973464');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361414', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973463');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361415', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973462');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361417', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973459');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361418', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973461');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361420', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973460');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361425', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361426', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361428', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986901');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361430', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996194');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361433', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986898');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361436', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996205');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361438', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996197');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361441', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996201');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361444', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986903');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361446', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996193');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361450', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986904');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361451', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986900');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361452', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996200');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361453', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996192');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361454', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977199');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361455', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977201');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361456', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361457', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977234');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361458', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977237');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('RP', 'TR05361459', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977342');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PL', 'TR05361460', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991626');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PL', 'TR05361251', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994773');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361252', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994915');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361253', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994970');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361254', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970401');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361256', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970060');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361258', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970402');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361259', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970063');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361260', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969710');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361261', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969521');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361262', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970245');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361264', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969515');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361266', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969517');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361267', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987977');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361268', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969514');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361269', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969516');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361270', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970249');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361272', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970247');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361273', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970251');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361274', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970262');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361275', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970257');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361276', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969520');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361277', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970256');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361278', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987981');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361279', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987984');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361280', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970260');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PL', 'TR05361461', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991976');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361462', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991924');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361463', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991919');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361464', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991824');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361465', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991823');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361466', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991917');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361467', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991918');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361468', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991891');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361469', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991889');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361470', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991888');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361471', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991895');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361472', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991890');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361473', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991887');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361474', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991886');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361475', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991885');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361476', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991883');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361477', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991884');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361478', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991862');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361479', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991860');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361480', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991864');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361481', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991867');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361482', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991865');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361483', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991894');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361487', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361489', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361492', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361494', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361496', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361498', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361500', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361501', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361281', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970255');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361282', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970263');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361284', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970258');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361285', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970261');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361287', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970259');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361289', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970264');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361291', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970246');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361293', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969519');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361295', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969518');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361297', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969513');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361299', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969512');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361302', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987983');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361312', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963446');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361313', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963261');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361315', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963262');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361316', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963447');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361318', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963378');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361320', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963374');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361323', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963376');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361325', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963377');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361326', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963371');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361328', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963370');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361330', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963368');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361332', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963367');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361333', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963369');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361340', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989899');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361342', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989826');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('CO', 'TR05361343', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989827');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361345', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989828');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361346', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989829');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361348', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989831');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('PP', 'TR05361350', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989830');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361351', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986586');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361354', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986577');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361356', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986578');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361357', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986587');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361359', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986576');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361361', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986590');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361363', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986589');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361365', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989904');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361367', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989898');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361369', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989901');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361371', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989906');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361373', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989900');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361375', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989896');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361376', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989903');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361377', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989902');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361378', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989905');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361379', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989897');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361380', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989895');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361381', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989459');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361383', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989410');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361384', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989409');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361385', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989411');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361387', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989413');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361389', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989422');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361391', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989419');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361392', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989418');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361394', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989414');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361402', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984686');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361403', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984689');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361404', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984683');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361405', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984682');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361406', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984684');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361407', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984681');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361409', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984687');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361410', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984685');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361416', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361419', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361421', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361422', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361423', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361424', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361427', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969094');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361429', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969091');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361431', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996196');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361432', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986906');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361434', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986893');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361435', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986895');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361437', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996195');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361439', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986905');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361440', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996202');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361442', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996198');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361443', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986902');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361445', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986899');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361447', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996206');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361448', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986896');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361449', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986897');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('DR', 'TR05361484', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950987');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361485', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996720');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361486', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996714');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361488', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996716');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361490', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996715');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361491', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996713');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361493', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996709');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361495', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996717');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361497', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996719');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361499', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996710');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361502', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361503', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361504', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361505', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361506', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361507', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID)
 Values
   ('WB', 'TR05361508', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL);
COMMIT;

Open in new window


CREATE TABLE TAB3
(
  TRANSACTION_ID  VARCHAR2(10 BYTE)             NOT NULL,
  ATTRIB_CODE     VARCHAR2(5 BYTE)              NOT NULL,
  ATTRIB_VALUE    VARCHAR2(25 BYTE)             NOT NULL
)

Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361536', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361310', 'REACT', 'PS');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361285', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361512', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361614', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361614', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361809', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361806', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361809', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361811', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361813', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361813', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361813', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361824', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361908', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361921', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361259', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361261', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361262', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361264', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361281', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361295', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361312', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361312', 'REACT', 'IN');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361340', 'VENI', '06');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361345', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361345', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361385', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361431', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05360863', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05360863', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361131', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05360820', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361049', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361317', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361372', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361257', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361314', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361428', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361430', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361433', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361454', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361466', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361466', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361466', 'REACT', 'IN');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361717', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361735', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361802', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361721', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361723', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361720', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361728', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361736', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361736', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361736', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361736', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361756', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361757', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361757', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361779', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361779', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361783', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361799', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361804', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361804', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361206', 'VENI', '06');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05358709', 'VENI', '06');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361192', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361192', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361192', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361655', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361510', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361510', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361530', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361530', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361468', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361513', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361190', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361190', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361190', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361199', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361200', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361200', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361200', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361209', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361566', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361566', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361648', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361657', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361657', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361151', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361151', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361152', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361153', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361153', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361154', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361155', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361155', 'VENI', '06');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361156', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361156', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361156', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361156', 'REACT', 'HE');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361157', 'VENI', '02');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361180', 'VENI', '01');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361613', 'VENI', '05');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05360894', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05360894', 'REACT', 'MO');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361000', 'VENI', '07');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361000', 'REACT', 'MI');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05360894', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361596', 'VENI', '04');
Insert into TAB3
   (TRANSACTION_ID, ATTRIB_CODE, ATTRIB_VALUE)
 Values
   ('TR05361166', 'VENI', '01');
COMMIT;

Open in new window


expected data
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
  • 9
  • 3
12 Comments
 
LVL 6

Author Comment

by:anumoses
ID: 40535725
As I had mentioned in my previous question about qns- the query will be ( which is the last column in the expected data)

and  exists (select transaction_id
                             from donation_attributes_don da
                          where da.attrib_code = 'VENI'
                   and d.transaction_id = da.transaction_id
                             and da.attrib_value in ('04','05'))
0
 
LVL 6

Author Comment

by:anumoses
ID: 40535738
In my report I created a function to get the last column. This has to be optimized as its taking time. That is why need your help as you can put everything in one query.

select count(unit_id)
  from blood_drives bd,donations_don d
 where 'DRV'||bd.drive_id = d.drive_id
   and drive_date between :start_date and :end_date
   and d.unit_id is not null
   and area_rep_no = :area_rep_no
   and drive_date = :drive_date
   and procedure_code = :procedure_code
   and exists (select transaction_id
                             from donation_attributes_don da
                          where da.attrib_code = 'VENI'
                   and d.transaction_id = da.transaction_id
                             and da.attrib_value in ('04','05'));
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40535762
TAB2 does not have a DRIVE_ID column in the sample data.  That seems to be the join column.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
LVL 6

Author Comment

by:anumoses
ID: 40535768
OOPS SORRY

CREATE TABLE TAB2
(
  PROCEDURE_CODE  VARCHAR2(5 BYTE),
  TRANSACTION_ID  VARCHAR2(10 BYTE)             NOT NULL,
  COLL_DATE       DATE                          NOT NULL,
  UNIT_ID         VARCHAR2(15 BYTE),
  DRIVE_ID        VARCHAR2(10 BYTE)             NOT NULL
)


Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361509', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714951000', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361510', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996895', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361512', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996770', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361514', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996767', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361515', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996894', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361516', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996762', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361518', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996771', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361520', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996763', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361522', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996882', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361524', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996764', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361527', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996765', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361528', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996887', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361529', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996893', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361530', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996885', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361531', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996766', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361532', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996896', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361533', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996768', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361534', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996892', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361535', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996886', 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361536', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977326', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361158', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977196', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361169', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977238', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361170', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977200', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361511', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950772', 'DRV2026311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361513', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950774', 'DRV2026311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361517', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950773', 'DRV2026311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361519', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361521', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361523', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026311');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361525', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361526', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026338');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361571', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05362055', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996703', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05362056', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996707', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05362057', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996712', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05362058', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990287', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05362098', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361172', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977198', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361178', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977232', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361182', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977225', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361187', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977233', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361188', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361189', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361201', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977226', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361202', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977227', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361203', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977343', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361207', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977229', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361236', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977235', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361246', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977230', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361190', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714993911', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361191', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998654', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361193', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998649', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361194', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998673', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361195', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998672', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361196', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998671', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361197', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998670', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361198', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998681', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361199', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998627', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361200', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998684', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361209', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998680', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361222', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361163', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994847', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361165', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994845', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361167', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987485', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361168', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994840', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361171', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994843', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361175', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987484', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361177', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987482', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361179', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987481', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361180', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994850', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361183', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992065', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361184', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994846', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PL', 'TR05361204', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987066', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361205', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994853', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361229', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992064', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361231', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987480', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361232', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992025', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361234', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994851', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('RP', 'TR05361248', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992024', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361250', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994849', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361211', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984679', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361214', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984680', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361218', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984677', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361221', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984764', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361226', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984678', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361227', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984765', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361230', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984776', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361235', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361237', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361238', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361243', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714955127', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361208', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361228', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361210', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998697', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361212', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998698', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361213', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998678', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361215', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998675', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361216', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998679', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361219', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714995040', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361220', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998676', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361223', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998674', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361224', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998696', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361225', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998677', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361239', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998648', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361240', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714995991', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361241', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998699', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361242', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998695', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361244', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998622', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361245', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714993910', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361247', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998690', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361249', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714998693', 'DRV5548800');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361255', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986625', 'DRV2026366');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361257', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986623', 'DRV2026366');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361263', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986622', 'DRV2026365');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361265', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986621', 'DRV2026365');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361271', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714992023', 'DRV5549424');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('RP', 'TR05361283', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990144', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361286', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990172', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361288', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990171', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361290', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990289', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361292', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990288', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361294', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990202', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361296', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990227', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361298', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990225', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361300', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990206', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361301', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990204', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361303', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990211', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361304', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990201', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361305', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990203', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361306', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990220', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361307', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990229', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361308', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990224', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361309', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990200', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361310', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990222', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361311', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990226', 'DRV5546980');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361314', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990979', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361317', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977332', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361319', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990987', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361321', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990978', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361322', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990986', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361324', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990989', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361327', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977328', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361164', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979713', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('HH', 'TR05361166', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979789', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361173', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979911', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361174', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979915', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361176', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979918', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361181', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979916', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361185', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979914', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361186', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979908', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361217', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979712', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361233', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714979913', 'DRV5547604');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361329', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977329', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361331', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977330', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361334', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977254', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361335', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977253', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361336', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977333', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361337', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977334', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361338', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977336', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361339', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977337', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361341', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977338', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361344', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977248', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361347', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977327', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361349', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977325', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361352', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977324', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361353', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714990728', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361355', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977335', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361358', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977316', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361360', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977315', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361362', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977310', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361364', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977313', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361366', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977311', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361368', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977309', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361370', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977323', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361372', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977314', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361374', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977312', 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361382', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989420', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361386', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989421', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361388', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989412', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361390', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989415', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361393', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989423', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361395', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989417', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361396', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989416', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361397', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989483', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361398', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989481', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361399', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989482', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361400', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989485', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361401', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989462', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('RS', 'TR05361408', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973486', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361411', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973499', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361412', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970136', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361413', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973464', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361414', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973463', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361415', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973462', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361417', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973459', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361418', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973461', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361420', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714973460', 'DRV5546668');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361425', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361426', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5548228');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361428', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986901', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361430', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996194', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361433', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986898', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361436', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996205', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361438', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996197', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361441', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996201', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361444', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986903', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361446', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996193', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361450', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986904', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361451', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986900', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361452', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996200', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361453', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996192', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361454', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977199', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361455', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977201', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361456', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977228', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361457', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977234', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361458', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977237', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('RP', 'TR05361459', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714977342', 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PL', 'TR05361460', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991626', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PL', 'TR05361251', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994773', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361252', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994915', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361253', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714994970', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361254', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970401', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361256', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970060', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361258', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970402', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361259', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970063', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361260', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969710', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361261', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969521', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361262', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970245', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361264', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969515', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361266', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969517', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361267', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987977', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361268', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969514', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361269', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969516', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361270', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970249', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361272', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970247', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361273', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970251', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361274', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970262', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361275', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970257', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361276', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969520', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361277', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970256', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361278', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987981', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361279', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987984', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361280', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970260', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PL', 'TR05361461', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991976', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361462', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991924', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361463', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991919', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361464', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991824', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361465', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991823', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361466', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991917', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361467', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991918', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361468', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991891', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361469', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991889', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361470', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991888', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361471', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991895', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361472', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991890', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361473', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991887', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361474', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991886', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361475', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991885', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361476', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991883', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361477', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991884', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361478', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991862', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361479', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991860', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361480', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991864', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361481', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991867', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361482', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991865', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361483', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714991894', 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361487', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361489', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5549112');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361492', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361494', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361496', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361498', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361500', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361501', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547916');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361281', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970255', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361282', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970263', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361284', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970258', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361285', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970261', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361287', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970259', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361289', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970264', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361291', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714970246', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361293', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969519', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361295', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969518', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361297', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969513', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361299', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969512', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361302', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714987983', 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361312', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963446', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361313', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963261', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361315', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963262', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361316', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963447', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361318', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963378', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361320', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963374', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361323', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963376', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361325', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963377', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361326', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963371', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361328', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963370', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361330', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963368', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361332', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963367', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361333', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714963369', 'DRV5546044');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361340', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989899', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361342', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989826', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('CO', 'TR05361343', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989827', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361345', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989828', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361346', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989829', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361348', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989831', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('PP', 'TR05361350', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989830', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361351', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986586', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361354', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986577', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361356', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986578', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361357', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986587', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361359', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986576', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361361', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986590', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361363', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986589', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361365', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989904', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361367', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989898', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361369', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989901', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361371', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989906', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361373', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989900', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361375', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989896', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361376', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989903', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361377', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989902', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361378', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989905', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361379', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989897', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361380', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989895', 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361381', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989459', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361383', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989410', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361384', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989409', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361385', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989411', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361387', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989413', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361389', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989422', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361391', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989419', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361392', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989418', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361394', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714989414', 'DRV5546356');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361402', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984686', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361403', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984689', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361404', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984683', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361405', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984682', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361406', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984684', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361407', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984681', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361409', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984687', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361410', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714984685', 'DRV5549736');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361416', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361419', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361421', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5547292');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361422', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361423', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361424', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV5545732');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361427', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969094', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361429', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714969091', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361431', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996196', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361432', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986906', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361434', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986893', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361435', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986895', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361437', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996195', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361439', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986905', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361440', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996202', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361442', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996198', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361443', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986902', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361445', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986899', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361447', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996206', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361448', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986896', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361449', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714986897', 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('DR', 'TR05361484', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714950987', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361485', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996720', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361486', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996714', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361488', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996716', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361490', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996715', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361491', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996713', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361493', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996709', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361495', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996717', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361497', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996719', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361499', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 'W039714996710', 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361502', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361503', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361504', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2026337');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361505', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361506', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361507', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2025666');
Insert into TAB2
   (PROCEDURE_CODE, TRANSACTION_ID, COLL_DATE, UNIT_ID, DRIVE_ID)
 Values
   ('WB', 'TR05361508', TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, 'DRV2025666');
COMMIT;

Open in new window

0
 
LVL 35

Accepted Solution

by:
johnsone earned 2000 total points
ID: 40535814
Did you even try to do this?

Here is the query I came up with:
SELECT bd.area_rep_no, 
       bd.drive_date, 
       bd.site_code, 
       bd.sponsor_group_code, 
       d.procedure_code, 
       SUM(CASE 
             WHEN da.attrib_value IN ( '04', '05' ) THEN 0 
             ELSE 1 
           END) AS cnt, 
       SUM(CASE 
             WHEN da.attrib_value IN ( '04', '05' ) THEN 1 
             ELSE 0 
           END) AS qnc_cnt 
FROM   (tab1 bd 
        join tab2 d 
          ON 'DRV' 
             ||bd.drive_id = d.drive_id) 
       left outer join tab3 da 
                    ON ( d.transaction_id = da.transaction_id 
                         AND da.attrib_value IN ( '04', '05' ) 
                         AND da.attrib_code = 'VENI' ) 
WHERE  bd.drive_date BETWEEN To_date('02-jan-2015', 'dd-mon-yyyy') AND To_date( 
                                    '02-jan-2015', 'dd-mon-yyyy') 
       AND d.unit_id IS NOT NULL 
GROUP  BY bd.area_rep_no, 
          bd.drive_date, 
          bd.site_code, 
          bd.sponsor_group_code, 
          d.procedure_code 
ORDER  BY 1, 
          2, 
          3; 

Open in new window

That is the exact query from the previous question, with the line removed that I said to remove.  Then I added in the new columns and group by and I get your results.

You should have been able to do that on your own and at least try it before posting a new question.
0
 
LVL 6

Author Comment

by:anumoses
ID: 40535830
your output from thr query posted above
Its missing qns count of 1 for rep 10 WB

10   01/02/2015   OP04  OP04  DR  1     0
                                                  WB 12   1
0
 
LVL 6

Author Comment

by:anumoses
ID: 40535834
Its not that I had not tried your query before posting. Was getting the same data as you have shown me.
0
 
LVL 6

Author Comment

by:anumoses
ID: 40535855
Dont worry I am investigating on my side. There is some kind of data update. So no qns found on that record. Thanks anyways.
0
 
LVL 6

Author Comment

by:anumoses
ID: 40535942
I have one question on the join

FROM   (tab1 bd
        join tab2 d
          ON 'DRV'
             ||bd.drive_id = d.drive_id)
       left outer join tab4 da
                    ON (
-----
In case I have 4 tables so left outer join tab3 becomes tab4.

from tab1,
       tab2,
      tab3
 where coll_date between :start_date and :end_date
   and unit_id is not null
   and tab1.drive_id = tab2.drive_id
   and tab3.location_id = tab2.location_id
and not exists.......here is our join for tab4 as usual

can i use and after  1st join?
0
 
LVL 35

Expert Comment

by:johnsone
ID: 40535952
I have no idea what the use of tab4 is.  If it is the subquery in your original, it is not needed.  Also, that is a subquery, not a join.
0
 
LVL 6

Author Comment

by:anumoses
ID: 40536094
There was a second query that had 3 tables before the outer join for sub centers. 1st query was for mobile blood drives. But based on the example you gave I did that and getting the correct data. Thanks.

select coll_date,location_name,
       procedure_code,
         SUM(CASE
             WHEN da.attrib_value IN ( '04', '05' ) THEN 0
             ELSE 1
           END) AS cnt,
       SUM(CASE
             WHEN da.attrib_value IN ( '04', '05' ) THEN 1
             ELSE 0
           END) AS qns_cnt
  FROM   (drives@pdon_new bd
        join donations_don d
          ON bd.drive_id = d.drive_id
            JOIN locations@pdon_new l on l.location_id = bd.location_id        )
       left outer join donation_attributes_don da
                    ON ( d.transaction_id = da.transaction_id
                         AND da.attrib_value IN ( '04', '05' )
                         AND da.attrib_code = 'VENI' )
WHERE  bd.drive_date BETWEEN To_date('02-jan-2015', 'dd-mon-yyyy') AND To_date(
                                    '02-jan-2015', 'dd-mon-yyyy')
       AND d.unit_id IS NOT NULL
         and bd.drive_id like 'DRV5%'
GROUP  BY coll_date,location_name,procedure_code
ORDER  BY 1,
          2;
0
 
LVL 6

Author Closing Comment

by:anumoses
ID: 40547364
thanks
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

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

Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
This video shows how to recover a database from a user managed backup
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

722 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