View: OKX_CUST_ROLE_RESP_V

Product:	OKX - Contracts Integration
Description:	Customer contacts
Implementation/DBA Data:	APPS.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