DBA Data[Home] [Help]

VIEW: APPS.CSC_HZ_PHONES_V

Source

View Text - Preformatted

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