Solved

oracle query

Posted on 2015-01-07
12
96 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
  • 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
Independent Software Vendors: 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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
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.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

685 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