APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on PO_LINE_LOCATIONS_ALL

Line 1120: FROM po_line_locations_all locate

1116: SELECT locate.quantity_received
1117: , locate.unit_meas_lookup_code
1118: INTO l_received_quantity
1119: , l_po_uom
1120: FROM po_line_locations_all locate
1121: WHERE locate.line_location_id = p_po_shipment_id;
1122:
1123: EXCEPTION
1124: WHEN no_data_found THEN

Line 1614: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;

1610: )
1611: IS
1612:
1613: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1614: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;

Line 1645: po_line_locations_all l,

1641: oola.shipped_quantity,
1642: uom.unit_of_measure,
1643: oola.inventory_item_id
1644: FROM po_distributions_all d,
1645: po_line_locations_all l,
1646: MTL_UNITS_OF_MEASURE uom,
1647: jmf_shikyu_replenishments jsr,
1648: oe_order_lines_all oola
1649: WHERE d.line_location_id = p_location_id

Line 1770: PO_LINE_LOCATIONS_ALL location

1766: location.RECEIVING_ROUTING_ID -- 1 is standard and 2 is inspection, 3 is direct
1767: INTO
1768: l_routing_header_id
1769: FROM
1770: PO_LINE_LOCATIONS_ALL location
1771: WHERE location.line_location_id = p_po_shipment_id;
1772: EXCEPTION
1773: WHEN no_data_found THEN
1774: JMF_SHIKYU_UTIL.debug_output