Solved

oracle query

Posted on 2015-01-06
20
119 Views
Last Modified: 2015-01-07
This request is an extension to the request below

http://www.experts-exchange.com/Database/Oracle/Q_28590835.html

CREATE TABLE TAB1
(
  DRIVE_DATE      DATE                          NOT NULL,
  AREA_REP_NO     NUMBER(4)                     NOT NULL,
  PROCEDURE_CODE  VARCHAR2(5 BYTE),
  TRANSACTION_ID  VARCHAR2(10 BYTE)             NOT NULL
)


Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'DR', 'TR05361509');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361510');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361512');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361514');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361515');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361516');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361518');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361520');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361522');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361524');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361527');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361528');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361529');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361530');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361531');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361532');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361533');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361534');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361535');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15, 'WB', 'TR05361263');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15, 'WB', 'TR05361265');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15, 'WB', 'TR05361255');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15, 'WB', 'TR05361257');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361428');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361430');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361433');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361436');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361438');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361441');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361444');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361446');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361450');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361451');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361452');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361453');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'DR', 'TR05361427');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'DR', 'TR05361429');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361431');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361432');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361434');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361435');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361437');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361439');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361440');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361442');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361443');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361445');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361447');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361448');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8, 'WB', 'TR05361449');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12, 'WB', 'TR05361511');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12, 'WB', 'TR05361513');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12, 'WB', 'TR05361517');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05362055');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05362056');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05362057');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'DR', 'TR05361484');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361485');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361486');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361488');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361490');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361491');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361493');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361495');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361497');
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO, PROCEDURE_CODE, TRANSACTION_ID)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10, 'WB', 'TR05361499');
COMMIT;

Open in new window


SELECT drive_date, 
       area_rep_no, 
       procedure_code, 
       SUM(CASE 
             WHEN procedure_code = 'DR' THEN 2 
             ELSE 1 
           END) AS cnt 
FROM   tab1 a
where not exists (select transaction_id 
                     from donation_attributes_don da
                    where da.attrib_code = 'VENI'
					  and a.transaction_id = da.transaction_id
                      and da.attrib_value in ('04','05')) 
GROUP  BY drive_date, 
          area_rep_no, 
          procedure_code 

Open in new window


I am adding a clause to remove QNS testing records.
I am enclosing image of before adding this extra clause and after adding the clause. The query works fine.

data
My requirement is to add another column called qns_cnt after cnt

expected data
expected data
0
Comment
Question by:anumoses
  • 13
  • 7
20 Comments
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
What have you tried?  It seems like it should be easy to do, add to the case statement to make the records you want to exclude 0, then add another column like the one you have to sum for the QN count.

I don't see enough information here to help you more than that.  Based on the sample data you gave, one of the following records qualfiies as a QN record:
DRIVE_DATE          AREA_REP_NO PROCE TRANSACTIO
------------------- ----------- ----- ----------
01/02/2015 00:00:00          10 WB    TR05361510
01/02/2015 00:00:00          10 WB    TR05361512
01/02/2015 00:00:00          10 WB    TR05361514
01/02/2015 00:00:00          10 WB    TR05361515
01/02/2015 00:00:00          10 WB    TR05361516
01/02/2015 00:00:00          10 WB    TR05361518
01/02/2015 00:00:00          10 WB    TR05361520
01/02/2015 00:00:00          10 WB    TR05361522
01/02/2015 00:00:00          10 WB    TR05361524
01/02/2015 00:00:00          10 WB    TR05361527
01/02/2015 00:00:00          10 WB    TR05361528
01/02/2015 00:00:00          10 WB    TR05361529
01/02/2015 00:00:00          10 WB    TR05361530
01/02/2015 00:00:00          10 WB    TR05361531
01/02/2015 00:00:00          10 WB    TR05361532
01/02/2015 00:00:00          10 WB    TR05361533
01/02/2015 00:00:00          10 WB    TR05361534
01/02/2015 00:00:00          10 WB    TR05361535
01/02/2015 00:00:00          10 WB    TR05362055
01/02/2015 00:00:00          10 WB    TR05362056
01/02/2015 00:00:00          10 WB    TR05362057
01/02/2015 00:00:00          10 WB    TR05361485
01/02/2015 00:00:00          10 WB    TR05361486
01/02/2015 00:00:00          10 WB    TR05361488
01/02/2015 00:00:00          10 WB    TR05361490
01/02/2015 00:00:00          10 WB    TR05361491
01/02/2015 00:00:00          10 WB    TR05361493
01/02/2015 00:00:00          10 WB    TR05361495
01/02/2015 00:00:00          10 WB    TR05361497
01/02/2015 00:00:00          10 WB    TR05361499

Open in new window

I cannot tell which one it is.  If you could tell us more about how to determine which record qualifies, that would be helpful.
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
QNS record
This is the transaction that is QNS

SELECT drive_date,
       area_rep_no,
       procedure_code, transaction_id,
       SUM(CASE
             WHEN procedure_code = 'DR' THEN 2
             ELSE 1
           END) AS cnt
FROM   tab1 a
where  exists (select transaction_id
                     from donation_attributes_don da
                    where da.attrib_code = 'VENI'
                                and a.transaction_id = da.transaction_id
                      and da.attrib_value in ('04','05'))
GROUP  BY drive_date,
          area_rep_no,
          procedure_code,transaction_id
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
I did get the query for NON QNS records and that is cnt column. In the same query how can I add another column to get qns records. That was a problem for me.
0
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
You highlighting the record isn't helpful.  What within those 4 fields determines it is a QNS record?
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
The table donation_attributes_don has that transaction _id

qns data
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
where da.attrib_code = 'VENI'
    and da.attrib_value in ('04','05')

This determines that it is QNS
0
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
You did not include sample data for the subquery.  I'm taking a guess.  See if this is what you are looking for.
SELECT a.drive_date, 
       a.area_rep_no, 
       a.procedure_code, 
       a.transaction_id, 
       SUM(CASE 
             WHEN da.attrib_value IN ( '04', '05' ) THEN 0 
             WHEN a.procedure_code = 'DR' THEN 2 
             ELSE 1 
           END) AS cnt, 
       SUM(CASE 
             WHEN da.attrib_value IN ( '04', '05' ) THEN 1 
             ELSE 0 
           END) qnc_cnt 
FROM   tab1 a 
       join donation_attributes_don da 
         ON a.transation_id = da.transaction_id 
WHERE  EXISTS (SELECT transaction_id 
               FROM   donation_attributes_don das 
               WHERE  das.attrib_code = 'VENI' 
                      AND a.transaction_id = das.transaction_id 
                      AND das.attrib_value IN ( '04', '05' )) 
GROUP  BY drive_date, 
          area_rep_no, 
          procedure_code, 
          transaction_id; 

Open in new window

0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
Nothing is close to my expected data. I will send my actual data from the tables. that will help us to nail down
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
CREATE TABLE TAB1
(
  DRIVE_DATE   DATE                             NOT NULL,
  AREA_REP_NO  NUMBER(4)                        NOT NULL
)


Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10);
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5);
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15);
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15);
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8);
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12);
Insert into TAB1
   (DRIVE_DATE, AREA_REP_NO)
 Values
   (TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10);
COMMIT;

Open in new window


TAB1 is our blood_drives table
TAB2 is donations table
TAB3 is donation_attributes table

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

0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
select drive_date,area_rep_no,
       procedure_code,SUM(CASE 
             WHEN procedure_code = 'DR' THEN 2 
             ELSE 1 
           END) AS cnt 
  from blood_drives bd,donations_don d
 where 'DRV'||bd.drive_id = d.drive_id
   and drive_date between '02-jan-2015' and '02-jan-2015' 
   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
   order by 1,2,3

Open in new window


The above code works fine to get non-qns data. Just need to add another column to after cnt to show the qns.
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 6

Author Comment

by:anumoses
Comment Utility
Some columns were missing

CREATE TABLE TAB1
(
  DRIVE_ID     NUMBER(7)                        NOT NULL,
  DRIVE_DATE   DATE                             NOT NULL,
  AREA_REP_NO  NUMBER(4)                        NOT NULL
)




Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2026338, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 10);
Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2026437, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 5);
Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2026365, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15);
Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2026366, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 15);
Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2025666, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 8);
Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2026311, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 12);
Insert into TAB1
   (DRIVE_ID, DRIVE_DATE, AREA_REP_NO)
 Values
   (2026337, TO_DATE('01/02/2015 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), 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),
  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 6

Author Comment

by:anumoses
Comment Utility
select drive_date,area_rep_no,
       procedure_code,SUM(CASE 
             WHEN procedure_code = 'DR' THEN 2 
             ELSE 1 
           END) AS cnt 
  from tab1 bd,tab2 d
 where 'DRV'||bd.drive_id = d.drive_id
   and drive_date between '02-jan-2015' and '02-jan-2015' 
   and d.unit_id is not null
   and not exists (select transaction_id 
                     from tab3 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
   order by 1,2,3 

Open in new window

0
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
Sorry, I cannot spend any more time on this right now.

This is very close:
SELECT bd.drive_date, 
       bd.area_rep_no, 
       d.procedure_code, 
       SUM(CASE 
             WHEN da.attrib_value IN ( '04', '05' ) THEN 0 
             WHEN d.procedure_code = 'DR' THEN 2 
             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 
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 drive_date, 
          area_rep_no, 
          procedure_code 
ORDER  BY 1, 
          2, 
          3; 

Open in new window

There is some sort of limiting criteria on the outer join that I am missing.  You should be able to find that and add it.  It somehow is getting 2 extra records for AREA_REP_NO = 10 and PROCEDURE_CODE = 'WB'.  It could have something to do with a ATTRIB_CODE != 'VENI', but that seems to only account for 1 record.
0
 
LVL 34

Accepted Solution

by:
johnsone earned 500 total points
Comment Utility
I think I figured out the joins now.  This is the modified version:
SELECT bd.drive_date, 
       bd.area_rep_no, 
       d.procedure_code, 
       SUM(CASE 
             WHEN da.attrib_value IN ( '04', '05' ) THEN 0 
             WHEN d.procedure_code = 'DR' THEN 2 
             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 drive_date, 
          area_rep_no, 
          procedure_code 
ORDER  BY 1, 
          2, 
          3; 

Open in new window

It comes out with the same results as your original with the one extra record counted in the QNC_CNT field.

You will also notice that dates are explicitly converted using TO_DATE.  I'm sure this has been recommended in the past, if it has not, I will highly recommend it.  You can never depend on defaults, they can be easily overridden.
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
There is a little change in the requirement. But the latest solution is helping me. The requirement is that if DR we dont have to do times 2. So I will be closing this and open a new question. Please check that and its a simple query but I need help in doing the joins that you have given in the above query. Apologies. Users keep changing requirements. Thanks for the help
0
 
LVL 6

Author Closing Comment

by:anumoses
Comment Utility
Thanks
0
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
All you should have to do is to remove this line:

WHEN d.procedure_code = 'DR' THEN 2

That would stop counting DR as 2 and would count it as 1.
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
now its count(unit_id) instead of case
0
 
LVL 34

Expert Comment

by:johnsone
Comment Utility
Then you need to open a new question with a full set of requirements.

There is no difference between taking out the when clause for DR records and using count(unit_id) or count(1) or count(*).
0
 
LVL 6

Author Comment

by:anumoses
Comment Utility
thanks. I am posting now
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Via a live example show how to connect to RMAN, make basic configuration settings changes and then take a backup of a demo database
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.

772 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now