DBA Data[Home] [Help]

APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_RELATIONSHIPS

Line 3895: HZ_RELATIONSHIPS REL,

3891: into l_party_id , l_rel_party_id
3892: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
3893: HZ_PARTIES PARTY,
3894: HZ_CUST_ACCOUNTS ACCT,
3895: HZ_RELATIONSHIPS REL,
3896: HZ_ORG_CONTACTS ORG_CONT,
3897: HZ_PARTIES REL_PARTY
3898: WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
3899: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'