APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 4047: FROM MTL_ONHAND_QUANTITIES

4043: IS
4044: onhand NUMBER;
4045: CURSOR Q1(p_org_id NUMBER, p_itme_Id NUMBER) IS
4046: SELECT SUM(TRANSACTION_QUANTITY)
4047: FROM MTL_ONHAND_QUANTITIES
4048: WHERE ORGANIZATION_ID = p_org_id
4049: AND INVENTORY_ITEM_ID = p_item_id;
4050: BEGIN
4051: OPEN Q1(P_ORG_ID,P_ITEM_ID);