APPS.AHL_OSP_RCV_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 3174: SELECT 'X' FROM MTL_SECONDARY_INVENTORIES

3170: AND ((MIL.START_DATE_ACTIVE IS NULL) OR (MIL.START_DATE_ACTIVE <= SYSDATE))
3171: AND ((MIL.END_DATE_ACTIVE IS NULL) OR (MIL.END_DATE_ACTIVE > SYSDATE));
3172:
3173: CURSOR is_dyn_locator_sub_inv (c_org_id NUMBER, c_sub_inv VARCHAR2) IS
3174: SELECT 'X' FROM MTL_SECONDARY_INVENTORIES
3175: WHERE ORGANIZATION_ID = c_org_id
3176: AND SECONDARY_INVENTORY_NAME like c_sub_inv
3177: AND LOCATOR_TYPE = 3;
3178: