[Home] [Help]
36:
37: --Bug5674055 commented the existing code and implemented the same using cursors.
38: cursor c_trxn_date is
39: SELECT /*+ FIRST_ROWS */ transaction_date
40: FROM rcv_transactions rct2,
41: rcv_shipment_lines rsl2
42: WHERE rct2.transaction_type = 'RECEIVE'
43: AND rct2.transaction_date between
44: x_cum_period_start_date - 1
52: ORDER BY transaction_date desc;
53:
54: CURSOR c_txn_id IS
55: SELECT transaction_id
56: FROM rcv_transactions rct,
57: rcv_shipment_lines rsl,
58: po_headers poh
59: WHERE transaction_date = x_max_trans_date
60: AND rct.transaction_type = 'RECEIVE'
137: --dbms_output.put_line('Get Cum Info'||x_rtv_update_cum_flag);
138:
139: -- Get the last receipt transaction date and receipt transaction
140: -- during the cum period.
141: -- Note: That we do not store the vendor site id in rcv_transactions
142: -- when we create the receipt. So we must join back to po headers
143: -- to verify that we are pointing to the correct vendor site.
144: x_progress := '020';
145:
156:
157: /* Bug 5674055
158: SELECT max(transaction_date)
159: INTO x_max_trans_date
160: FROM rcv_transactions rct2,
161: po_headers poh2,
162: rcv_shipment_lines rsl2
163: WHERE rct2.transaction_type = 'RECEIVE'
164: AND rct2.transaction_date between
178:
179: -- Bug 5674055 commented the following code.
180: /* SELECT max(transaction_id)
181: INTO x_last_receipt_transaction_id
182: FROM rcv_transactions rct,
183: rcv_shipment_lines rsl,
184: po_headers poh
185: WHERE transaction_date = x_max_trans_date
186: (
184: po_headers poh
185: WHERE transaction_date = x_max_trans_date
186: (
187: SELECT max(transaction_date)
188: FROM rcv_transactions rct2,
189: po_headers poh2,
190: rcv_shipment_lines rsl2
191: WHERE rct2.transaction_type = 'RECEIVE'
192: AND rct2.transaction_date between