DBA Data[Home] [Help]

APPS.OTA_TDB_BUS dependencies on HZ_CUST_ACCOUNTS

Line 464: HZ_CUST_ACCOUNTS ROLE_ACCT

460: select 1
461:
462: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
463: HZ_RELATIONSHIPS REL,
464: HZ_CUST_ACCOUNTS ROLE_ACCT
465:
466: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
467: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
468: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 1818: HZ_CUST_ACCOUNTS role_acct

1814: HZ_PARTIES party,
1815: HZ_RELATIONSHIPS rel,
1816: HZ_ORG_CONTACTS org_cont,
1817: HZ_PARTIES rel_party,
1818: HZ_CUST_ACCOUNTS role_acct
1819: WHERE acct_role.party_id = rel.party_id
1820: AND acct_role.role_type = 'CONTACT'
1821: AND org_cont.party_relationship_id = rel.relationship_id
1822: AND rel.subject_id = party.party_id