Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | XNC_CUST_ACCOUNTS_ROLES_V retrieves roles related to a customer account. |
Implementation/DBA Data: | Not implemented in this database |
SELECT ROLES.ROWID
, ROLES.PARTY_ID PARTY_ID
, CUST_ACCOUNT_ID
, CUST_ACCT_SITE_ID
, CUST_ACCOUNT_ROLE_ID
, ROLE_TYPE
, CURRENT_ROLE_STATE
, CURRENT_ROLE_STATE_EFFECTIVE
, BEGIN_DATE
, END_DATE
, PRIMARY_FLAG
, PARTY.PERSON_FIRST_NAME FIRST_NAME
, PARTY.PERSON_LAST_NAME LAST_NAME
, PARTY.PERSON_MIDDLE_NAME MIDDLE_NAME
, ORGANIZATION_NAME
, ROLES.LAST_UPDATE_DATE
FROM JTF_CUST_ACCOUNTS_ROLES_V ROLES
, JTF_HZ_PARTIES_V PARTY
, JTF_HZ_ORGANIZATION_PROFILES_V ORG_PROFILE
WHERE ROLES.PARTY_ID = PARTY.PARTY_ID
AND ROLES.PARTY_ID = ORG_PROFILE.PARTY_ID (+)