SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE , HZ_PARTIES PARTY , HZ_CUST_ACCOUNTS ACCT , HZ_RELATIONSHIPS REL , HZ_PARTIES REL_PARTY WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID AND ACCT_ROLE.ROLE_TYPE = 'CONTACT' AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES' AND REL.SUBJECT_ID = PARTY.PARTY_ID AND REL.PARTY_ID = REL_PARTY.PARTY_ID AND REL.OBJECT_ID = ACCT.PARTY_ID AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID