APPS.AHL_PRD_MTLTXN_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 1503: FROM MTL_SECONDARY_INVENTORIES

1499: ELSE
1500:
1501: SELECT RESERVABLE_TYPE
1502: INTO l_reservable
1503: FROM MTL_SECONDARY_INVENTORIES
1504: WHERE ORGANIZATION_ID = p_x_ahl_mtltxn_tbl(i).Organization_Id
1505: AND SECONDARY_INVENTORY_NAME = p_x_ahl_mtltxn_tbl(i).Subinventory_Name;
1506:
1507: IF (l_reservable <> 1) THEN

Line 2045: FROM MTL_SECONDARY_INVENTORIES

2041:
2042: --Sub inventory Query
2043: CURSOR AHL_SUBINV_CUR (p_org_id NUMBER, p_subinv VARCHAR2) IS
2044: SELECT 1
2045: FROM MTL_SECONDARY_INVENTORIES
2046: WHERE ORGANIZATION_ID = p_org_id
2047: AND SECONDARY_INVENTORY_NAME = p_subinv;
2048:
2049: -- Locator query