FND Design Data [Home] [Help]

View: AMS_ORG_ACCT_ROLES_V

Product: AMS - Marketing
Description: Roles that parties perform in customer accounts
Implementation/DBA Data: ViewAPPS.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

Name
CUST_ACCOUNT_ROLE_ID
PARTY_ID
CUST_ACCOUNT_ID
BEGIN_DATE
END_DATE
CUST_ACCT_SITE_ID
ROLE_TYPE
PRIMARY_FLAG
CURRENT_ROLE_STATE
CURRENT_ROLE_STATE_EFFECTIVE
SOURCE_CODE