DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on RCV_TRANSACTIONS_INTERFACE

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