DBA Data[Home] [Help]

APPS.INV_LABEL_PVT3 dependencies on RCV_TRANSACTIONS_INTERFACE

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