View: CS_SR_HZ_CUST_CONT_V

Product:	CS - Service
Description:	This view lists all the customer contacts for party types PARTY_RELATIONSHIP and PERSON.
Implementation/DBA Data:	APPS.CS_SR_HZ_CUST_CONT_V

View Text

SELECT P.PARTY_ID
, P.PARTY_NUMBER
, P.PARTY_TYPE
, P.PARTY_NAME
, P.PERSON_FIRST_NAME
, P.PERSON_LAST_NAME
, A.ACCOUNT_NUMBER
, A.ACCOUNT_NAME
, L.MEANING PARTY_TYPE_MEANING
FROM HZ_PARTIES P
, HZ_CUST_ACCOUNTS A
, CS_LOOKUPS L
WHERE P.PARTY_TYPE = 'PERSON'
AND A.PARTY_ID(+) = P.PARTY_ID
AND L.LOOKUP_TYPE = 'CS_SR_CONTACT_TYPE'
AND L.LOOKUP_CODE = 'PERSON'
AND P.STATUS IN ('A'
, 'I') UNION ALL SELECT R.PARTY_ID
, R.PARTY_NUMBER
, R.PARTY_TYPE
, R.PARTY_NAME
, P.PERSON_FIRST_NAME
, P.PERSON_LAST_NAME
, A.ACCOUNT_NUMBER
, A.ACCOUNT_NAME
, L.MEANING PARTY_TYPE_MEANING
FROM HZ_PARTIES P
, HZ_PARTIES R
, HZ_RELATIONSHIPS REL
, HZ_CUST_ACCOUNTS A
, CS_LOOKUPS L
WHERE REL.PARTY_ID = R.PARTY_ID
AND REL.SUBJECT_ID = P.PARTY_ID
AND R.PARTY_TYPE = 'PARTY_RELATIONSHIP'
AND P.PARTY_TYPE = 'PERSON'
AND A.PARTY_ID(+) = P.PARTY_ID
AND L.LOOKUP_TYPE = 'CS_SR_CONTACT_TYPE'
AND L.LOOKUP_CODE = 'PARTY_RELATIONSHIP'
AND P.STATUS IN ('A'
, 'I')
AND R.STATUS IN ('A'
, 'I')

Columns