APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on PO_LINE_LOCATIONS_ALL

Line 1140: FROM po_line_locations_all locate

1136: SELECT locate.quantity_received
1137: , locate.unit_meas_lookup_code
1138: INTO l_received_quantity
1139: , l_po_uom
1140: FROM po_line_locations_all locate
1141: WHERE locate.line_location_id = p_po_shipment_id;
1142:
1143: EXCEPTION
1144: WHEN no_data_found THEN

Line 1634: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;

1630: )
1631: IS
1632:
1633: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1634: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;

Line 1665: po_line_locations_all l,

1661: oola.shipped_quantity,
1662: uom.unit_of_measure,
1663: oola.inventory_item_id
1664: FROM po_distributions_all d,
1665: po_line_locations_all l,
1666: MTL_UNITS_OF_MEASURE uom,
1667: jmf_shikyu_replenishments jsr,
1668: oe_order_lines_all oola
1669: WHERE d.line_location_id = p_location_id

Line 1790: PO_LINE_LOCATIONS_ALL location

1786: location.RECEIVING_ROUTING_ID -- 1 is standard and 2 is inspection, 3 is direct
1787: INTO
1788: l_routing_header_id
1789: FROM
1790: PO_LINE_LOCATIONS_ALL location
1791: WHERE location.line_location_id = p_po_shipment_id;
1792: EXCEPTION
1793: WHEN no_data_found THEN
1794: JMF_SHIKYU_UTIL.debug_output