eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_OSP_QUERIES_PVT dependencies on AHL_OSP_ORDERS_B

Line 1624: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp where

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
1626: osp.status_code <> 'CLOSED' and
1627: --Added by mpothuku on 23-Aug-06 to exclude the quantity involved in PO_CANCELLED or PO_DELETED Lines for Bug 5252627
1628: ospl.status_code is null and

Line 1655: from ahl_osp_order_lines ospl, ahl_osp_orders_b osp,

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,
1656: /* Fix for the AE Bug 5673279 (Release/Holding of inventory items) */
1657: oe_order_lines_all oel
1658: where
1659: ospl.osp_order_id = osp.osp_order_id and