APPS.INL_SHIPMENT_PVT dependencies on PO_LINE_LOCATIONS

Line 972: po_line_locations_all pll

968: SELECT rsl.shipment_line_id,
969: rsl.item_id,
970: pll.unit_meas_lookup_code
971: FROM rcv_shipment_lines rsl,
972: po_line_locations_all pll
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

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

1464: l_shipln_duplicated := TRUE;
1465: END IF;
1466: -- In Receiving (RCV_QUANTITIES_S) the rcv_exception_code is checked FOR POs only.
1467: IF p_ship_line_src_type_code = 'PO' THEN
1468: l_debug_info := 'Verify in po_line_locations_all the Over-Receipt Quantity Control Action';
1469: INL_LOGGING_PVT.Log_Statement (
1470: p_module_name => g_module_name,
1471: p_procedure_name => l_program_name,
1472: p_debug_info => l_debug_info) ;

Line 1476: FROM po_line_locations pll

1472: p_debug_info => l_debug_info) ;
1473:
1474: SELECT DECODE (pll.qty_rcv_exception_code, 'NONE', 'Y', 'N')
1475: INTO l_acpt_qty
1476: FROM po_line_locations pll
1477: WHERE pll.line_location_id = p_ship_line_src_id;
1478: END IF;
1479: IF l_acpt_qty = 'N' THEN
1480: IF (l_shipln_duplicated = TRUE) THEN

Line 2631: po_line_locations_all pll

2627: l_po_org_id
2628: FROM inl_ship_headers_all ish,
2629: inl_ship_lines_all isl,
2630: po_headers_all ph,
2631: po_line_locations_all pll
2632: WHERE isl.ship_header_id = ish.ship_header_id
2633: AND ph.po_header_id = pll.po_header_id
2634: AND pll.line_location_id = isl.ship_line_source_id
2635: AND isl.ship_line_src_type_code = 'PO'

Line 2891: po_line_locations_all pll,

2887: MAX(sl.ship_line_num) max_ship_line_num
2888: FROM
2889: inl_ship_lines_all sl,
2890: po_headers_all ph,
2891: po_line_locations_all pll,
2892: po_vendors pv,
2893: po_vendor_sites_all pvs,
2894: hz_party_sites hps
2895: WHERE

Line 2924: po_line_locations_all pll,

2920: sl.ship_line_num
2921: FROM
2922: inl_ship_lines_all sl,
2923: po_headers_all ph,
2924: po_line_locations_all pll,
2925: po_vendors pv,
2926: po_vendor_sites_all pvs,
2927: hz_party_sites hps
2928: WHERE

Line 3659: FROM po_line_locations pll

3655: p_var_value => FND_PROFILE.VALUE('RCV_CLOSED_PO_DEFAULT_OPTION')) ;
3656:
3657: SELECT DECODE(FND_PROFILE.VALUE('RCV_CLOSED_PO_DEFAULT_OPTION'),'N',NVL(pll.closed_code,'OPEN'), 'OPEN')
3658: INTO l_closed_code
3659: FROM po_line_locations pll
3660: WHERE pll.line_location_id= l_ship_lines_rec.ship_line_source_id;
3661:
3662: INL_LOGGING_PVT.Log_Variable (
3663: p_module_name => g_module_name,