DBA Data[Home] [Help]

APPS.OTA_OM_UPD_API dependencies on HZ_CUST_ACCOUNTS

Line 1118: HZ_CUST_ACCOUNTS role_acct

1114: Select rel_party.email_address
1115: From HZ_CUST_ACCOUNT_ROLES acct_role,
1116: HZ_PARTIES rel_party,
1117: HZ_RELATIONSHIPS rel,
1118: HZ_CUST_ACCOUNTS role_acct
1119: where acct_role.party_id = rel.party_id
1120: and acct_role.role_type = 'CONTACT'
1121: and rel.party_id = rel_party.party_id
1122: and rel.subject_table_name = 'HZ_PARTIES'