DBA Data[Home] [Help]

APPS.INV_LABEL_PVT2 dependencies on RCV_TRANSACTIONS_INTERFACE

Line 141: FROM rcv_transactions_interface rti, mtl_serial_numbers msn,

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,
142: po_lines_trx_v pol, -- CLM project, bug 9403291
143: wms_lpn_contents wlc,
144: po_headers_trx_v pha -- CLM project, bug 9403291
145: WHERE wlc.parent_lpn_id = rti.lpn_id

Line 301: FROM rcv_transactions_interface rti

297: , rti.vendor_id
298: , rti.vendor_site_id
299: , rti.oe_order_header_id --Bug 4582954
300: , rti.oe_order_line_id --Bug 4582954
301: FROM rcv_transactions_interface rti
302: , mtl_serial_numbers_temp msnt
303: , mtl_transaction_lots_temp mtlt
304: , po_lines_trx_v pol -- CLM project, bug 9403291
305: , po_headers_trx_v pha -- CLM project, bug 9403291

Line 459: -- FROM rcv_transactions_interface rti

455: -- Repaced the query with rcv_transactions.
456: -- To get org type.
457: -- CURSOR rti_get_org_cur IS
458: -- SELECT to_organization_id
459: -- FROM rcv_transactions_interface rti
460: -- WHERE rti.interface_transaction_id = p_transaction_id;
461:
462: -- To get org type.
463: CURSOR rt_get_org_cur IS