APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_OSP_ORDER_LINES_V

Line 1644: FROM AHL_OSP_ORDER_LINES_V OSPL,

1640: l_forecast_onhand_qty_tbl(l_fct_index) := nvl(x_atp_rec.Requested_Date_Quantity(1),0);
1641:
1642: SELECT COUNT(*)
1643: INTO l_forecast_osp_qty_tbl(l_fct_index)
1644: FROM AHL_OSP_ORDER_LINES_V OSPL,
1645: AHL_OSP_ORDERS_B OSP
1646: WHERE OSPL.OSP_ORDER_ID = OSP.OSP_ORDER_ID
1647: AND OSP.STATUS_CODE <> 'CLOSED'
1648: AND INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)