Solved

oracle query

Posted on 2015-01-06
20
129 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
ID: 40533404
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
ID: 40533415
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
ID: 40533419
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
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 34

Expert Comment

by:johnsone
ID: 40533452
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
ID: 40533462
The table donation_attributes_don has that transaction _id

qns data
0
 
LVL 6

Author Comment

by:anumoses
ID: 40533465
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
ID: 40533483
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
ID: 40533501
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
ID: 40533534
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
ID: 40533592
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
 
LVL 6

Author Comment

by:anumoses
ID: 40533608
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
ID: 40533610
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
ID: 40533895
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
ID: 40535373
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
ID: 40535599
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
ID: 40535600
Thanks
0
 
LVL 34

Expert Comment

by:johnsone
ID: 40535641
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
ID: 40535645
now its count(unit_id) instead of case
0
 
LVL 34

Expert Comment

by:johnsone
ID: 40535661
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
ID: 40535669
thanks. I am posting now
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql query 5 80
Best RAID for a BDD Oracle 4 67
Fastest way to replace data in Oracle 5 62
Repeat query 13 46
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  â€¦
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

813 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