APPS.AHL_PRD_MRSHL_PVT dependencies on MTL_ONHAND_QUANTITIES

Line 25: FROM MTL_ONHAND_QUANTITIES

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

Line 54: FROM MTL_ONHAND_QUANTITIES

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