353: ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
354: FROM
355: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
356: HZ_PARTIES PARTY,
357: HZ_RELATIONSHIPS REL,
358: HZ_ORG_CONTACTS ORG_CONT,
359: HZ_CUST_ACCOUNTS ROLE_ACCT
360: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
361: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'