VIEW: APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V

Source

View Text - Preformatted

SELECT decode( cp.phone_country_code, null, null, cp.phone_country_code||'-') ||decode( cp.phone_area_code, null, null,cp.phone_area_code ||'-')||cp.phone_number phone, cp.phone_country_code, cp.phone_area_code, cp.phone_number, cp.phone_extension, ar.meaning cont_point_type_meaning, ar1.meaning phone_line_type_meaning, cp.owner_table_id, cp.contact_point_id, cp.timezone_id, cp.contact_point_type, cp.primary_flag, cp.status, cp.transposed_phone_number from hz_contact_points cp, ar_lookups ar, ar_lookups ar1 WHERE cp.contact_point_type = 'PHONE' and cp.contact_point_type = ar.lookup_code and ar.lookup_type = 'COMMUNICATION_TYPE' and cp.phone_line_type = ar1.lookup_code and ar1.lookup_type = 'PHONE_LINE_TYPE' and cp.owner_table_name = 'HZ_PARTIES'

View Text - HTML Formatted

SELECT DECODE( CP.PHONE_COUNTRY_CODE
, NULL
, NULL
, CP.PHONE_COUNTRY_CODE||'-') ||DECODE( CP.PHONE_AREA_CODE
, NULL
, NULL
, CP.PHONE_AREA_CODE ||'-')||CP.PHONE_NUMBER PHONE
, CP.PHONE_COUNTRY_CODE
, CP.PHONE_AREA_CODE
, CP.PHONE_NUMBER
, CP.PHONE_EXTENSION
, AR.MEANING CONT_POINT_TYPE_MEANING
, AR1.MEANING PHONE_LINE_TYPE_MEANING
, CP.OWNER_TABLE_ID
, CP.CONTACT_POINT_ID
, CP.TIMEZONE_ID
, CP.CONTACT_POINT_TYPE
, CP.PRIMARY_FLAG
, CP.STATUS
, CP.TRANSPOSED_PHONE_NUMBER
FROM HZ_CONTACT_POINTS CP
, AR_LOOKUPS AR
, AR_LOOKUPS AR1
WHERE CP.CONTACT_POINT_TYPE = 'PHONE'
AND CP.CONTACT_POINT_TYPE = AR.LOOKUP_CODE
AND AR.LOOKUP_TYPE = 'COMMUNICATION_TYPE'
AND CP.PHONE_LINE_TYPE = AR1.LOOKUP_CODE
AND AR1.LOOKUP_TYPE = 'PHONE_LINE_TYPE'
AND CP.OWNER_TABLE_NAME = 'HZ_PARTIES'