APPS.INL_SHIPMENT_PVT dependencies on RCV_TRANSACTIONS

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 978: rcv_transactions rt

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:
982: l_rcv_shipmt_lines c_rcv_shipmt_lines%ROWTYPE;

Line 5377: rcv_transactions rt,

5373: um.uom_code
5374: INTO l_rt_transaction_id,
5375: l_rt_uom_code
5376: FROM mtl_units_of_measure um,
5377: rcv_transactions rt,
5378: inl_ship_lines sl
5379: WHERE um.unit_of_measure = rt.unit_of_measure
5380: AND rt.destination_type_code = 'RECEIVING'
5381: AND ((rt.transaction_type = 'RECEIVE'

Line 5533: rcv_transactions rt,

5529: um.uom_code
5530: INTO l_rt_transaction_id,
5531: l_rt_uom_code
5532: FROM mtl_units_of_measure um,
5533: rcv_transactions rt,
5534: inl_ship_lines sl
5535: WHERE um.unit_of_measure = rt.unit_of_measure
5536: AND rt.destination_type_code = 'RECEIVING'
5537: AND ((rt.transaction_type = 'RECEIVE'

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