VIEW: APPS.CSD_CONTACT_DETAILS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'