eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CHV_CUM_PERIODS_S2 dependencies on RCV_SHIPMENT_LINES

Line 45: rcv_shipment_lines rsl2

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
49: and

Line 63: rcv_shipment_lines rsl,

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'
67: AND rct.transaction_date between x_cum_period_start_date - 1

Line 168: rcv_shipment_lines rsl2

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
172: and

Line 189: rcv_shipment_lines rsl,

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: (
193: SELECT max(transaction_date)

Line 196: rcv_shipment_lines rsl2

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
200: and