APPS.CHV_CUM_PERIODS_S2 dependencies on RCV_TRANSACTIONS

Line 44: FROM rcv_transactions rct2,

40: Modified the sql in the cursor c_trxn_date as per the receiving
41: team advice.*/
42: cursor c_trxn_date is
43: SELECT /*+ FIRST_ROWS */ transaction_date
44: FROM rcv_transactions rct2,
45: rcv_shipment_lines rsl2
46: WHERE rct2.transaction_type = 'RECEIVE'
47: AND rct2.transaction_date between
48: x_cum_period_start_date - 1

Line 62: FROM rcv_transactions rct,

58: ORDER BY transaction_date desc;
59:
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'

Line 147: -- Note: That we do not store the vendor site id in rcv_transactions

143: --dbms_output.put_line('Get Cum Info'||x_rtv_update_cum_flag);
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:

Line 166: FROM rcv_transactions rct2,

162:
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

Line 188: FROM rcv_transactions rct,

184:
185: -- Bug 5674055 commented the following code.
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: (

Line 194: FROM rcv_transactions rct2,

190: po_headers poh
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