DBA Data[Home] [Help]

APPS.OTA_UTILITY dependencies on HZ_ORG_CONTACTS

Line 2332: HZ_ORG_CONTACTS org_cont,

2328: select ACCT_ROLE.cust_account_id CUSTOMER_ID
2329: from HZ_CUST_ACCOUNT_ROLES acct_role,
2330: HZ_PARTIES party,
2331: HZ_RELATIONSHIPS rel,
2332: HZ_ORG_CONTACTS org_cont,
2333: HZ_PARTIES rel_party,
2334: HZ_CUST_ACCOUNTS role_acct
2335: where acct_role.party_id = rel.party_id
2336: and acct_role.role_type = 'CONTACT'

Line 2688: HZ_ORG_CONTACTS org_cont,

2684: select party.party_id
2685: from HZ_CUST_ACCOUNT_ROLES acct_role,
2686: HZ_PARTIES party,
2687: HZ_RELATIONSHIPS rel,
2688: HZ_ORG_CONTACTS org_cont,
2689: HZ_PARTIES rel_party,
2690: HZ_CUST_ACCOUNTS role_acct
2691: where acct_role.party_id = rel.party_id
2692: and acct_role.role_type = 'CONTACT'