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_PVT2 dependencies on RCV_TRANSACTIONS

Line 141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn, po_lines_all pol, wms_lpn_contents wlc, po_headers_all pha

137: , rti.vendor_id
138: , rti.vendor_site_id
139: , rti.oe_order_header_id --Bug 4582954
140: , rti.oe_order_line_id --Bug 4582954
141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn, po_lines_all pol, wms_lpn_contents wlc, po_headers_all pha
142: WHERE wlc.parent_lpn_id = rti.lpn_id
143: AND pol.po_line_id(+) = rti.po_line_id
144: AND pha.po_header_id(+) = rti.po_header_id
145: AND msn.lpn_id = rti.lpn_id

Line 189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol

185: , rt.vendor_site_id
186: , rt.uom_code
187: , rt.oe_order_header_id --Bug 4582954
188: , rt.oe_order_line_id --Bug 4582954
189: FROM rcv_transactions rt, rcv_serials_supply rss, po_lines_all pol
190: -- , po_distributions_all pod --Commented as part of Bug# 3586116
191: , po_headers_all pha, rcv_shipment_lines rsl
192: , wms_license_plate_numbers wlpn -- Bug 3836623
193: WHERE rss.transaction_id = rt.transaction_id

Line 236: FROM rcv_transactions rt

232: , rt.vendor_site_id
233: , rt.uom_code
234: , rt.oe_order_header_id --Bug 4582954
235: , rt.oe_order_line_id --Bug 4582954
236: FROM rcv_transactions rt
237: , mtl_transaction_lot_numbers mtln
238: , mtl_unit_transactions mut
239: -- , po_distributions_all pod --Commented as part of Bug# 3586116
240: , po_lines_all pol

Line 296: FROM rcv_transactions_interface rti

292: , rti.vendor_id
293: , rti.vendor_site_id
294: , rti.oe_order_header_id --Bug 4582954
295: , rti.oe_order_line_id --Bug 4582954
296: FROM rcv_transactions_interface rti
297: , mtl_serial_numbers_temp msnt
298: , mtl_transaction_lots_temp mtlt
299: , po_lines_all pol
300: , po_headers_all pha

Line 450: -- Repaced the query with rcv_transactions.

446:
447: -- End of Flow csr
448:
449: -- Commented as part of bug fix for Bug 3472432.
450: -- Repaced the query with rcv_transactions.
451: -- To get org type.
452: -- CURSOR rti_get_org_cur IS
453: -- SELECT to_organization_id
454: -- FROM rcv_transactions_interface rti

Line 454: -- FROM rcv_transactions_interface rti

450: -- Repaced the query with rcv_transactions.
451: -- To get org type.
452: -- CURSOR rti_get_org_cur IS
453: -- SELECT to_organization_id
454: -- FROM rcv_transactions_interface rti
455: -- WHERE rti.interface_transaction_id = p_transaction_id;
456:
457: -- To get org type.
458: CURSOR rt_get_org_cur IS

Line 460: FROM rcv_transactions rt

456:
457: -- To get org type.
458: CURSOR rt_get_org_cur IS
459: SELECT organization_id
460: FROM rcv_transactions rt
461: WHERE rt.GROUP_ID = p_transaction_id;
462:
463: -- Fix For Bug: 4907062
464: -- a) Included Project Number in the cursor