VIEW: APPS.OKX_CUST_ROLE_RESP_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)