Oracle TCA Party site uses View - HZ_SITE_USES_V

SELECT DISTINCT su.ROWID, su.site_use_id, su.last_update_date,
                su.object_version_number, su.last_updated_by,
                su.creation_date, su.created_by, su.site_use_code,
                su.cust_acct_site_id address_id, su.primary_flag, su.status,
                su.LOCATION, su.last_update_login, su.contact_id,
                DECODE (acct_role.cust_account_role_id,