View: OE_AK_DEL_TO_CONTACT_V

Product:	ONT - Order Management
Description:
Implementation/DBA Data:	APPS.OE_AK_DEL_TO_CONTACT_V

View Text

SELECT ACCT_ROLE.CUST_ACCOUNT_ROLE_ID
FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE
, HZ_PARTIES PARTY
, HZ_RELATIONSHIPS REL
, HZ_PARTIES REL_PARTY
, HZ_CUST_ACCOUNTS ACCT
WHERE ACCT_ROLE.PARTY_ID = REL.PARTY_ID
AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'
AND REL.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND REL.SUBJECT_ID = PARTY.PARTY_ID
AND REL.PARTY_ID = REL_PARTY.PARTY_ID
AND REL.OBJECT_ID = ACCT.PARTY_ID
AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
AND ACCT.CUST_ACCOUNT_ID = ACCT_ROLE.CUST_ACCOUNT_ID

Columns