APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_OSP_ORDERS_B

Line 1645: AHL_OSP_ORDERS_B OSP

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)
1649: AND OSPL.INVENTORY_ORG_ID= l_fs_arr_org_id_tbl(i)