APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 4763: FROM MTL_ONHAND_QUANTITIES

4759: IS
4760: onhand NUMBER;
4761: CURSOR Q1(p_org_id NUMBER, p_itme_Id NUMBER) IS
4762: SELECT SUM(TRANSACTION_QUANTITY)
4763: FROM MTL_ONHAND_QUANTITIES
4764: WHERE ORGANIZATION_ID = p_org_id
4765: AND INVENTORY_ITEM_ID = p_item_id;
4766: BEGIN
4767: OPEN Q1(P_ORG_ID,P_ITEM_ID);