TCA Party Credit Profiles View - HZ_CREDIT_PROFILES_V

SELECT 'Operating_Unit' profile_type, cp.credit_profile_id,
       cp.organization_id, TO_NUMBER (NULL) item_category_id,
       cp.creation_date, cp.created_by, cp.last_update_date,
       cp.last_updated_by, cp.last_update_login, cp.program_application_id,
       cp.program_id, cp.program_update_date, cp.request_id, cp.enable_flag,
       cp.effective_date_from, cp.effective_date_to, cp.credit_checking,

The party contact points view - HZ_CONTACT_POINTS_DFV

SELECT ROWID, ATTRIBUTE_CATEGORY,
 NULL
 FROM HZ_CONTACT_POINTS

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'

The Party Attribute Translation View - HZ_ATTRIBUTE_TRANS_V

SELECT fnd_lookup_values_vl.attribute1, fnd_lookup_values_vl.attribute2,
       fnd_lookup_values_vl.attribute3, fnd_lookup_values_vl.attribute4,
       fnd_lookup_values_vl.lookup_type, fnd_lookup_values_vl.lookup_code,
       fnd_lookup_values_vl.enabled_flag,
       fnd_lookup_values_vl.start_date_active,