APPS.AHL_FMP_MR_EFFECTIVITY_PVT dependencies on MTL_SYSTEM_ITEMS_KFV

Line 873: FROM MTL_SYSTEM_ITEMS_KFV MTL,

869: --pdoki added for Bug 6719371
870: CURSOR check_alternate( c_relationship_id NUMBER, c_inventory_item_id NUMBER )
871: IS
872: SELECT 'X'
873: FROM MTL_SYSTEM_ITEMS_KFV MTL,
874: FND_LOOKUP_VALUES_VL IT,
875: AHL_POSITION_ALTERNATES_V PA
876: WHERE MTL.SERVICE_ITEM_FLAG = 'N'
877: AND IT.LOOKUP_CODE (+) = MTL.ITEM_TYPE