DBA Data[Home] [Help]

APPS.OTA_TDB_BUS2 dependencies on HZ_CUST_ACCOUNTS

Line 816: HZ_CUST_ACCOUNTS ROLE_ACCT

812: select 1
813:
814: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
815: HZ_RELATIONSHIPS REL,
816: HZ_CUST_ACCOUNTS ROLE_ACCT
817:
818: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
819: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
820: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'

Line 834: HZ_CUST_ACCOUNTS ROLE_ACCT

830: select 1
831:
832: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
833: HZ_RELATIONSHIPS REL,
834: HZ_CUST_ACCOUNTS ROLE_ACCT
835:
836: where ACCT_ROLE.PARTY_ID = REL.PARTY_ID
837: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
838: AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'