[Home] [Help]
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
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 |