[Home] [Help]
View: 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
Name |
ROW_ID |
PARTY_ID |
CONTACT_PARTY_ID |
CONTACT_PARTY_NUMBER |
FIRST_NAME |
LAST_NAME |
PHONE_AREA_CODE |
PHONE_NUMBER |
EMAIL_ADDRESS |