DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on RCV_SHIPMENT_LINES

Line 897: FROM rcv_shipment_lines rsl,

893: CURSOR c_rcv_shipmt_lines IS
894: SELECT rsl.shipment_line_id,
895: rsl.item_id,
896: pll.unit_meas_lookup_code
897: FROM rcv_shipment_lines rsl,
898: po_line_locations_all pll
899: WHERE rsl.lcm_shipment_line_id IS NOT NULL
900: AND pll.line_location_id = rsl.po_line_location_id
901: AND rsl.po_line_location_id = p_parent_id

Line 991: -- Iterate through all RCV Shipment Lines based on a given PLL.

987: p_procedure_name => l_api_name,
988: p_var_name => 'p_tolerable_quantity',
989: p_var_value => p_tolerable_quantity);
990:
991: -- Iterate through all RCV Shipment Lines based on a given PLL.
992: FOR l_rcv_shipmt_lines IN c_rcv_shipmt_lines
993: LOOP
994: l_debug_info := 'Call RCV_QUANTITIES_S.get_available_quantity - RSL';
995: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,