APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_LTP_MTL_REQ_PVT

Line 1621: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty

1617: 2. We need to use this query in the front end to decide on the visibility of the indicator
1618: 3. We need to retain the ospl.status_code clause as, if the order does not have shipments and PO is deleted, we consider it released */
1619: /*
1620: Select
1621: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
1622: (ospl.inventory_item_id,ospl.inventory_item_uom,ospl.inventory_item_quantity),0)
1623: ),0) into l_quant_withoutship
1624: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp where
1625: ospl.osp_order_id = osp.osp_order_id and

Line 1651: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty

1647: 3. Need to remove the ospl.status code clause as the items are not considered released till the shipments are deleted
1648: and PO deletion no more enables the items to be released for Osp.
1649: */
1650: Select
1651: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
1652: (ospl.inventory_item_id,ospl.inventory_item_uom,ospl.inventory_item_quantity),0)
1653: ),0) into l_quant_ship_notbooked
1654:
1655: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp,

Line 1691: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty

1687: --Gives the quantity of the items that have ship lines, and whose shipments are in those phases, where
1688: --the quantity is not reduced from the inventory yet, but nonetheless reserved.
1689:
1690: Select
1691: nvl(sum(nvl(AHL_LTP_MTL_REQ_PVT.Get_Primary_UOM_Qty
1692: (inventory_item_id, requested_quantity_uom, requested_quantity),0)
1693: ),0) into l_quant_notshippedout
1694:
1695: from wsh_delivery_details where