APPS.AHL_PRD_MRSHL_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 26: FROM MTL_ONHAND_QUANTITIES

22:
23: onhand NUMBER;
24: CURSOR Q1(p_org_id NUMBER, P_ITEM_ID NUMBER,p_SUBINVENTORY VARCHAR2,p_locator_id NUMBER ) IS
25: SELECT SUM(TRANSACTION_QUANTITY)
26: FROM MTL_ONHAND_QUANTITIES
27: WHERE ORGANIZATION_ID = p_org_id
28: AND INVENTORY_ITEM_ID = P_ITEM_ID
29: AND LOCATOR_ID = p_locator_id
30: AND SUBINVENTORY_CODE = p_SUBINVENTORY;

Line 55: FROM MTL_ONHAND_QUANTITIES

51:
52: onhand NUMBER;
53: CURSOR Q1(p_org_id NUMBER, p_item_Id NUMBER,p_locator_id NUMBER) IS
54: SELECT SUM(TRANSACTION_QUANTITY)
55: FROM MTL_ONHAND_QUANTITIES
56: WHERE ORGANIZATION_ID = p_org_id
57: AND INVENTORY_ITEM_ID = p_item_id
58: AND LOCATOR_ID <> p_locator_id;
59: --AND SUBINVENTORY_CODE <> p_SUBINVENTORY;