APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1299: from PO_LINE_LOCATIONS_ALL

1295:
1296: -- get received quantity against Replenish Purchase Shipment
1297: select QUANTITY_RECEIVED
1298: into l_pre_qty_received
1299: from PO_LINE_LOCATIONS_ALL
1300: where LINE_LOCATION_ID = l_replen_po_shipment_id;
1301:
1302: -- get UnitOfMeasure from UomCode for Shikyu component
1303: select UNIT_OF_MEASURE

Line 1352: FROM PO_LINE_LOCATIONS_ALL PLL

1348: AND NOT EXISTS
1349: (
1350: SELECT
1351: 'PURCHASE ORDER SHIPMENT CANCELLED OR FC'
1352: FROM PO_LINE_LOCATIONS_ALL PLL
1353: WHERE PLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
1354: AND
1355: (
1356: NVL(PLL.CANCEL_FLAG,'N') = 'Y'

Line 1459: from PO_LINE_LOCATIONS_ALL

1455:
1456: -- Again search for received quantity against Replenish Po Shipment
1457: select QUANTITY_RECEIVED
1458: into l_post_qty_received
1459: from PO_LINE_LOCATIONS_ALL
1460: where LINE_LOCATION_ID = l_replen_po_shipment_id;
1461:
1462: -- Check if return happened successfully
1463: IF l_returned_qty_parent_txn_uom <> (l_pre_qty_received - l_post_qty_received) THEN