APPS.JMF_PROCESS_SHIKYU_RCV_TRX_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1293: from PO_LINE_LOCATIONS_ALL

1289:
1290: -- get received quantity against Replenish Purchase Shipment
1291: select QUANTITY_RECEIVED
1292: into l_pre_qty_received
1293: from PO_LINE_LOCATIONS_ALL
1294: where LINE_LOCATION_ID = l_replen_po_shipment_id;
1295:
1296: -- get UnitOfMeasure from UomCode for Shikyu component
1297: select UNIT_OF_MEASURE

Line 1346: FROM PO_LINE_LOCATIONS_ALL PLL

1342: AND NOT EXISTS
1343: (
1344: SELECT
1345: 'PURCHASE ORDER SHIPMENT CANCELLED OR FC'
1346: FROM PO_LINE_LOCATIONS_ALL PLL
1347: WHERE PLL.LINE_LOCATION_ID = RT.PO_LINE_LOCATION_ID
1348: AND
1349: (
1350: NVL(PLL.CANCEL_FLAG,'N') = 'Y'

Line 1438: from PO_LINE_LOCATIONS_ALL

1434:
1435: -- Again search for received quantity against Replenish Po Shipment
1436: select QUANTITY_RECEIVED
1437: into l_post_qty_received
1438: from PO_LINE_LOCATIONS_ALL
1439: where LINE_LOCATION_ID = l_replen_po_shipment_id;
1440:
1441: -- Check if return happened successfully
1442: IF l_returned_qty_parent_txn_uom <> (l_pre_qty_received - l_post_qty_received) THEN