DBA Data[Home] [Help]

APPS.INL_SHIPMENT_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 898: po_line_locations_all pll

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
902: AND NOT EXISTS(SELECT 1

Line 1259: l_debug_info := 'Verify in po_line_locations_all the Over-Receipt Quantity Control Action';

1255: l_shipln_duplicated := TRUE;
1256: END IF;
1257: -- In Receiving (RCV_QUANTITIES_S) the rcv_exception_code is checked FOR POs only.
1258: IF p_ship_line_src_type_code = 'PO' THEN
1259: l_debug_info := 'Verify in po_line_locations_all the Over-Receipt Quantity Control Action';
1260: INL_LOGGING_PVT.Log_Statement (p_module_name => g_module_name,
1261: p_procedure_name => l_proc_name,
1262: p_debug_info => l_debug_info) ;
1263: SELECT DECODE (pll.qty_rcv_exception_code, 'NONE', 'Y', 'N')