4078: FROM
4079: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4080: HZ_PARTIES PARTY,
4081: HZ_RELATIONSHIPS REL,
4082: HZ_ORG_CONTACTS ORG_CONT
4083: WHERE
4084: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4085: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4086: AND ORG_CONT.PARTY_RELATIONSHIP_ID = REL.RELATIONSHIP_ID
4110: FROM
4111: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4112: HZ_PARTIES PARTY,
4113: HZ_RELATIONSHIPS REL,
4114: HZ_ORG_CONTACTS ORG_CONT,
4115: HZ_PARTIES REL_PARTY
4116: WHERE
4117: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4118: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
4145: FROM
4146: HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
4147: HZ_PARTIES PARTY,
4148: HZ_RELATIONSHIPS REL,
4149: HZ_ORG_CONTACTS ORG_CONT,
4150: HZ_PARTIES REL_PARTY
4151: WHERE
4152: ACCT_ROLE.PARTY_ID = REL.PARTY_ID
4153: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'