APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 946: FROM MTL_SYSTEM_ITEMS_KFV MTL,

942: --pdoki added for Bug 6719371
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