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.INV_LABEL_PVT3 dependencies on RCV_TRANSACTIONS

Line 57: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables

53: SELECT rti.lpn_id lpn_id
54: , pha.segment1 purchase_order
55: , rti.subinventory
56: , rti.locator_id
57: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
58: WHERE rti.interface_transaction_id = p_transaction_id
59: AND rti.po_header_id = pha.po_header_id(+);
60:
61: CURSOR c_rti_lpn_inspection IS

Line 66: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables

62: SELECT rti.transfer_lpn_id transfer_lpn_id
63: , pha.segment1 purchase_order
64: , rti.subinventory
65: , rti.locator_id
66: FROM rcv_transactions_interface rti, po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
67: WHERE rti.interface_transaction_id = p_transaction_id
68: AND rti.po_header_id = pha.po_header_id(+);
69:
70: CURSOR c_mmtt_lpn IS

Line 182: FROM rcv_transactions rt

178: SELECT lpn_id
179: , po_header_id
180: , subinventory
181: , locator_id
182: FROM rcv_transactions rt
183: WHERE lpn_id IS NOT NULL
184: AND rt.group_id = p_transaction_id
185: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
186: AND p_label_type_info.business_flow_code = 2)

Line 201: FROM wms_license_plate_numbers lpn, rcv_transactions rt

197: SELECT lpn.parent_lpn_id
198: , rt.po_header_id
199: , rt.subinventory
200: , rt.locator_id
201: FROM wms_license_plate_numbers lpn, rcv_transactions rt
202: WHERE lpn.lpn_id = rt.lpn_id
203: -- AND lpn.parent_lpn_id <> rt.lpn_id
204: AND rt.group_id = p_transaction_id
205: AND lpn.parent_lpn_id is not null

Line 222: FROM wms_license_plate_numbers lpn, rcv_transactions rt

218: SELECT lpn.outermost_lpn_id
219: , rt.po_header_id
220: , rt.subinventory
221: , rt.locator_id
222: FROM wms_license_plate_numbers lpn, rcv_transactions rt
223: WHERE lpn.lpn_id = rt.lpn_id
224: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
225: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id
226: AND rt.group_id = p_transaction_id

Line 243: FROM rcv_transactions rt

239: SELECT transfer_lpn_id lpn_id
240: , po_header_id
241: , subinventory
242: , locator_id
243: FROM rcv_transactions rt
244: WHERE
245: --rt.transfer_lpn_id <> rt.lpn_id AND
246: rt.group_id = p_transaction_id
247: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')

Line 263: FROM wms_license_plate_numbers lpn, rcv_transactions rt

259: SELECT lpn.parent_lpn_id
260: , rt.po_header_id
261: , rt.subinventory
262: , rt.locator_id
263: FROM wms_license_plate_numbers lpn, rcv_transactions rt
264: WHERE lpn.lpn_id = rt.transfer_lpn_id
265: -- AND rt.transfer_lpn_id <> rt.lpn_id
266: -- AND lpn.parent_lpn_id <> lpn.lpn_id
267: AND lpn.parent_lpn_id is not null

Line 285: FROM wms_license_plate_numbers lpn, rcv_transactions rt

281: SELECT lpn.outermost_lpn_id
282: , rt.po_header_id
283: , rt.subinventory
284: , rt.locator_id
285: FROM wms_license_plate_numbers lpn, rcv_transactions rt
286: WHERE lpn.lpn_id = rt.transfer_lpn_id
287: -- AND rt.transfer_lpn_id <> rt.lpn_id
288: -- AND lpn.outermost_lpn_id <> lpn.lpn_id
289: -- AND lpn.outermost_lpn_id <> lpn.parent_lpn_id