[Home] [Help]
60: CURSOR c_txn_id IS
61: SELECT transaction_id
62: FROM rcv_transactions rct,
63: rcv_shipment_lines rsl,
64: po_headers poh
65: WHERE transaction_date = x_max_trans_date
66: AND rct.transaction_type = 'RECEIVE'
67: AND rct.transaction_date between x_cum_period_start_date - 1
68: and nvl(x_cum_period_end_date,rct.transaction_date+1) + 1
144:
145: -- Get the last receipt transaction date and receipt transaction
146: -- during the cum period.
147: -- Note: That we do not store the vendor site id in rcv_transactions
148: -- when we create the receipt. So we must join back to po headers
149: -- to verify that we are pointing to the correct vendor site.
150: x_progress := '020';
151:
152: BEGIN
156: */
157:
158: -- Bug 3656241(forward fix of 3549677)
159: -- Following SQL split into 2 sqls for performance improvement.
160: -- Also driving off of po_headers by making poh.vendor_id = x_vendor_id
161:
162:
163: /* Bug 5674055
164: SELECT max(transaction_date)
163: /* Bug 5674055
164: SELECT max(transaction_date)
165: INTO x_max_trans_date
166: FROM rcv_transactions rct2,
167: po_headers poh2,
168: rcv_shipment_lines rsl2
169: WHERE rct2.transaction_type = 'RECEIVE'
170: AND rct2.transaction_date between
171: x_cum_period_start_date - 1
186: /* SELECT max(transaction_id)
187: INTO x_last_receipt_transaction_id
188: FROM rcv_transactions rct,
189: rcv_shipment_lines rsl,
190: po_headers poh
191: WHERE transaction_date = x_max_trans_date
192: (
193: SELECT max(transaction_date)
194: FROM rcv_transactions rct2,
191: WHERE transaction_date = x_max_trans_date
192: (
193: SELECT max(transaction_date)
194: FROM rcv_transactions rct2,
195: po_headers poh2,
196: rcv_shipment_lines rsl2
197: WHERE rct2.transaction_type = 'RECEIVE'
198: AND rct2.transaction_date between
199: x_cum_period_start_date - 1