VIEW: APPS.CSC_GS_CONTACTS_V

Source

View Text - Preformatted

SELECT em.owner_table_id party_id, em.contact_point_id contact_point_id, em.contact_point_id email_id, ph.phone_number phone_number, em.email_address email_address, ph.phone_country_code phone_country_code, ph.phone_area_code phone_area_code, ph.phone_extension phone_extension, ph.telephone_type telephone_type, ph.phone_line_type phone_line_type, ph.last_update_date last_update_date, em.last_update_date email_last_update_date FROM hz_contact_points ph, hz_contact_points em WHERE ph.owner_table_id (+) = em.owner_table_id and ph.owner_table_name (+) = 'HZ_PARTIES' and em.owner_table_name = 'HZ_PARTIES' and ph.contact_point_type (+) = 'PHONE' and em.contact_point_type = 'EMAIL'

View Text - HTML Formatted

SELECT EM.OWNER_TABLE_ID PARTY_ID
, EM.CONTACT_POINT_ID CONTACT_POINT_ID
, EM.CONTACT_POINT_ID EMAIL_ID
, PH.PHONE_NUMBER PHONE_NUMBER
, EM.EMAIL_ADDRESS EMAIL_ADDRESS
, PH.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, PH.PHONE_AREA_CODE PHONE_AREA_CODE
, PH.PHONE_EXTENSION PHONE_EXTENSION
, PH.TELEPHONE_TYPE TELEPHONE_TYPE
, PH.PHONE_LINE_TYPE PHONE_LINE_TYPE
, PH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, EM.LAST_UPDATE_DATE EMAIL_LAST_UPDATE_DATE
FROM HZ_CONTACT_POINTS PH
, HZ_CONTACT_POINTS EM
WHERE PH.OWNER_TABLE_ID (+) = EM.OWNER_TABLE_ID
AND PH.OWNER_TABLE_NAME (+) = 'HZ_PARTIES'
AND EM.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND PH.CONTACT_POINT_TYPE (+) = 'PHONE'
AND EM.CONTACT_POINT_TYPE = 'EMAIL'