View: CSC_GS_CONTACTS_V

Product:	CSC - Customer Care
Description:	View of HZ_CONTACTS_POINTS. This view is used to get only the contact details of customers
Implementation/DBA Data:	APPS.CSC_GS_CONTACTS_V

View Text

SELECT PH.OWNER_TABLE_ID PARTY_ID
, PH.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'

Columns