[Home] [Help]
View: OKX_CUST_ROLE_RESP_V
View Text
SELECT CAR.CUST_ACCOUNT_ROLE_ID ID1
, '#' ID2
, R.OBJECT_ID PARTY_ID
, '#' PARTY_ID2
, P.PARTY_NAME DESCRIPTION
, P.PARTY_NAME NAME
, P.EMAIL_ADDRESS EMAIL_ADDRESS
, CAR.CUST_ACCOUNT_ID CUST_ACCT_ID
, CAR.ROLE_TYPE ROLE_TYPE
, CAR.CUST_ACCT_SITE_ID CUST_ACCT_SITE_ID
, RR.RESPONSIBILITY_TYPE RESPONSIBILITY_TYPE
, RR.PRIMARY_FLAG PRIMARY_FLAG
, R.STATUS STATUS
FROM HZ_CUST_ACCOUNT_ROLES CAR
, HZ_PARTIES P
, HZ_ROLE_RESPONSIBILITY RR
, HZ_RELATIONSHIPS R
WHERE CAR.ROLE_TYPE = 'CONTACT'
AND P.PARTY_ID = R.SUBJECT_ID
AND R.PARTY_ID = CAR.PARTY_ID
AND R.CONTENT_SOURCE_TYPE = 'USER_ENTERED'
AND CAR.CUST_ACCOUNT_ROLE_ID = RR.CUST_ACCOUNT_ROLE_ID
AND EXISTS (SELECT 'X'
FROM HZ_CUST_ACCT_SITES CAS
WHERE CAS.CUST_ACCOUNT_ID = CAR.CUST_ACCOUNT_ID)
Columns
Name |
ID1 |
ID2 |
PARTY_ID |
PARTY_ID2 |
DESCRIPTION |
NAME |
EMAIL_ADDRESS |
CUST_ACCT_ID |
ROLE_TYPE |
CUST_ACCT_SITE_ID |
RESPONSIBILITY_TYPE |
PRIMARY_FLAG |
STATUS |