DBA Data[Home] [Help]

APPS.INV_LABEL_PVT3 dependencies on RCV_TRANSACTIONS_INTERFACE

Line 55: FROM rcv_transactions_interface rti, po_headers_all pha

51: SELECT rti.lpn_id lpn_id
52: , pha.segment1 purchase_order
53: , rti.subinventory
54: , rti.locator_id
55: FROM rcv_transactions_interface rti, po_headers_all pha
56: WHERE rti.interface_transaction_id = p_transaction_id
57: AND rti.po_header_id = pha.po_header_id(+);
58:
59: CURSOR c_rti_lpn_inspection IS

Line 64: FROM rcv_transactions_interface rti, po_headers_all pha

60: SELECT rti.transfer_lpn_id transfer_lpn_id
61: , pha.segment1 purchase_order
62: , rti.subinventory
63: , rti.locator_id
64: FROM rcv_transactions_interface rti, po_headers_all pha
65: WHERE rti.interface_transaction_id = p_transaction_id
66: AND rti.po_header_id = pha.po_header_id(+);
67:
68: CURSOR c_mmtt_lpn IS