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
View Text - HTML Formatted
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