View: CS_SR_HZ_CONT_PTS_P_PHONES_V

Product:	CS - Service
Description:	This view lists all the active primary phones from HZ_CONTACT_POINTS.
Implementation/DBA Data:	APPS.CS_SR_HZ_CONT_PTS_P_PHONES_V

View Text

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'

Columns