Solved

oracle query

Posted on 2015-01-07
12
98 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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 500 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

627 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