DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on RCV_TRANSACTIONS_INTERFACE

Line 977: FROM rcv_transactions_interface rti,

973: WHERE rsl.lcm_shipment_line_id IS NOT NULL
974: AND pll.line_location_id = rsl.po_line_location_id
975: AND rsl.po_line_location_id = p_parent_id
976: AND NOT EXISTS(SELECT 1
977: FROM rcv_transactions_interface rti,
978: rcv_transactions rt
979: WHERE rti.shipment_line_id (+) = rt.shipment_line_id -- Bug #8235573
980: AND rsl.shipment_line_id = rt.shipment_line_id);
981:

Line 12053: FROM rcv_transactions_interface rti,

12049: IF NVL(l_pending_update_flag, 'N') = 'Y' AND p_caller = 'U' THEN
12050:
12051: SELECT COUNT(1)
12052: INTO l_rcv_running
12053: FROM rcv_transactions_interface rti,
12054: inl_ship_lines_all sl
12055: WHERE rti.transaction_type = 'RECEIVE'
12056: AND rti.processing_status_code = 'RUNNING'
12057: AND rti.lcm_shipment_line_id = sl.ship_line_id