APPS.AHL_RA_ANALYSER_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 1790: FROM MTL_ONHAND_QUANTITIES QUANT,

1786: END IF;
1787:
1788: SELECT nvl(SUM(nvl(TRANSACTION_QUANTITY,0)),0)
1789: INTO l_forecast_non_qty_tbl(l_fct_index)
1790: FROM MTL_ONHAND_QUANTITIES QUANT,
1791: MTL_SECONDARY_INVENTORIES SI
1792: WHERE QUANT.INVENTORY_ITEM_ID = l_dtls_inv_item_id_tbl(j)
1793: AND QUANT.ORGANIZATION_ID = l_fs_arr_org_id_tbl(i)
1794: AND QUANT.SUBINVENTORY_CODE = SI.SECONDARY_INVENTORY_NAME