APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on FND_LOOKUP_VALUES_VL

Line 947: FND_LOOKUP_VALUES_VL IT,

943: CURSOR check_alternate( c_relationship_id NUMBER, c_inventory_item_id NUMBER )
944: IS
945: SELECT 'X'
946: FROM MTL_SYSTEM_ITEMS_KFV MTL,
947: FND_LOOKUP_VALUES_VL IT,
948: AHL_POSITION_ALTERNATES_V PA
949: WHERE MTL.SERVICE_ITEM_FLAG = 'N'
950: AND IT.LOOKUP_CODE (+) = MTL.ITEM_TYPE
951: AND IT.LOOKUP_TYPE (+) = 'ITEM_TYPE'