View: CSC_HZ_PHONES_V

Product:	CSC - Customer Care
Description:	View to concatenate Area code and Phone number and display as a single column
Implementation/DBA Data:	APPS.CSC_HZ_PHONES_V

View Text

SELECT DISTINCT AREA_CODE || PHONE_NUMBER PHONE
, PHONE_LINE_TYPE
, CONTACT_POINT_TYPE
, COUNTRY_CODE
, AREA_CODE
, EXTENSION
FROM CSC_HZ_CONTACT_POINTS_V
WHERE PHONE_NUMBER IS NOT NULL

Columns