View: AMS_ORG_ACCT_ROLES_V

Product:	AMS - Marketing
Description:	Roles that parties perform in customer accounts
Implementation/DBA Data:	APPS.AMS_ORG_ACCT_ROLES_V

View Text

SELECT HCAR.CUST_ACCOUNT_ROLE_ID
, HCAR.PARTY_ID
, HCAR.CUST_ACCOUNT_ID
, HCAR.BEGIN_DATE
, HCAR.END_DATE
, HCAR.CUST_ACCT_SITE_ID
, HCAR.ROLE_TYPE
, HCAR.PRIMARY_FLAG
, HCAR.CURRENT_ROLE_STATE
, HCAR.CURRENT_ROLE_STATE_EFFECTIVE
, HCAR.SOURCE_CODE
FROM HZ_CUST_ACCOUNT_ROLES HCAR
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP
WHERE HCAR.CUST_ACCOUNT_ID = HCA.CUST_ACCOUNT_ID
AND HCA.STATUS = 'A'
AND HCA.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HP.PARTY_TYPE = 'ORGANIZATION'

Columns