The Party Class Categories view - HZ_CLASS_CATEGORIES_V

SELECT   lookup.meaning, CLASS.class_category
    FROM hz_class_categories CLASS,
         hz_class_category_uses USE,
         fnd_lookup_types_vl lookup
   WHERE CLASS.class_category = USE.class_category
     AND CLASS.class_category = lookup.lookup_type
     AND USE.owner_table = 'HZ_PARTIES'

ORDER BY lookup.meaning