View: CSD_CONTACT_DETAILS_V

Product:	CSD - Depot Repair
Description:
Implementation/DBA Data:	APPS.CSD_CONTACT_DETAILS_V

View Text

SELECT HP1.ROWID
, HP1.PARTY_ID
, HP.PARTY_ID CONTACT_PARTY_ID
, HP.PARTY_NUMBER CONTACT_PARTY_NUMBER
, HP.PERSON_FIRST_NAME
, HP.PERSON_LAST_NAME
, HC1.PHONE_AREA_CODE
, HC1.PHONE_NUMBER
, HC2.EMAIL_ADDRESS
FROM HZ_PARTIES HP
, HZ_PARTIES HP1
, HZ_RELATIONSHIPS HPR
, HZ_CONTACT_POINTS HC1
, HZ_CONTACT_POINTS HC2
, HZ_CONTACT_POINTS HC3
WHERE HP.PARTY_TYPE = 'PERSON'
AND HP1.PARTY_ID = HPR.OBJECT_ID
AND HPR.SUBJECT_ID = HP.PARTY_ID
AND HPR.RELATIONSHIP_CODE = 'CONTACT_OF'
AND HC1.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HC1.OWNER_TABLE_ID(+) = HP.PARTY_ID
AND HC1.CONTACT_POINT_TYPE(+) = 'PHONE'
AND HC2.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HC2.OWNER_TABLE_ID(+) = HP.PARTY_ID
AND HC2.CONTACT_POINT_TYPE(+) = 'WEB'
AND HC3.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HC3.OWNER_TABLE_ID = HP.PARTY_ID
AND HC3.CONTACT_POINT_TYPE(+) = 'EMAIL'AND HPR.SUBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HPR.OBJECT_TABLE_NAME = 'HZ_PARTIES'
AND HPR.DIRECTIONAL_FLAG = 'F'

Columns