[Home] [Help]
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'
61: AND rct.transaction_date between x_cum_period_start_date - 1
62: and nvl(x_cum_period_end_date,rct.transaction_date+1) + 1
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:
146: BEGIN
150: */
151:
152: -- Bug 3656241(forward fix of 3549677)
153: -- Following SQL split into 2 sqls for performance improvement.
154: -- Also driving off of po_headers by making poh.vendor_id = x_vendor_id
155:
156:
157: /* Bug 5674055
158: SELECT max(transaction_date)
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
165: x_cum_period_start_date - 1
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: (
187: SELECT max(transaction_date)
188: FROM rcv_transactions rct2,
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
193: x_cum_period_start_date - 1