6216: FROM HZ_CONTACT_POINTS CONTACT,
6217: HZ_PARTIES CONTACT_PARTY,
6218: HZ_CUST_ACCOUNT_ROLES ACCT_ROLES,
6219: HZ_CUST_ACCOUNTS CUST_ACCT,
6220: HZ_RELATIONSHIPS PARTY_REL,
6221: HZ_PARTIES REL_PARTY,
6222: AR_LOOKUPS ARL
6223: WHERE CONTACT.owner_table_name(+) = 'HZ_PARTIES'
6224: AND CONTACT.PRIMARY_FLAG (+) = 'Y'