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 41: rcv_shipment_lines rsl2

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

Line 57: rcv_shipment_lines rsl,

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

Line 162: rcv_shipment_lines rsl2

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

Line 183: rcv_shipment_lines rsl,

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

Line 190: rcv_shipment_lines rsl2

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