VIEW: APPS.OKS_CONTACT_POINTS_V

Source

View Text - Preformatted

SELECT CONTACT_POINT_TYPE ,PHONE_LINE_TYPE ,OWNER_TABLE_ID ,EMAIL_ADDRESS ,DECODE(contact_point_type,'EMAIL',NULL,PHONE_AREA_CODE) PHONE_AREA_CODE ,DECODE(contact_point_type,'EMAIL',NULL,PHONE_COUNTRY_CODE) PHONE_COUNTRY_CODE ,DECODE(contact_point_type,'EMAIL',NULL,PHONE_NUMBER) PHONE_NUMBER ,DECODE(contact_point_type,'EMAIL',NULL,PHONE_EXTENSION) PHONE_EXTENSION FROM OKX_CONTACT_POINTS_V WHERE OWNER_TABLE_NAME = 'HZ_PARTIES' AND CONTACT_POINT_TYPE IN ('PHONE','EMAIL','FAX')

View Text - HTML Formatted

SELECT CONTACT_POINT_TYPE
, PHONE_LINE_TYPE
, OWNER_TABLE_ID
, EMAIL_ADDRESS
, DECODE(CONTACT_POINT_TYPE
, 'EMAIL'
, NULL
, PHONE_AREA_CODE) PHONE_AREA_CODE
, DECODE(CONTACT_POINT_TYPE
, 'EMAIL'
, NULL
, PHONE_COUNTRY_CODE) PHONE_COUNTRY_CODE
, DECODE(CONTACT_POINT_TYPE
, 'EMAIL'
, NULL
, PHONE_NUMBER) PHONE_NUMBER
, DECODE(CONTACT_POINT_TYPE
, 'EMAIL'
, NULL
, PHONE_EXTENSION) PHONE_EXTENSION
FROM OKX_CONTACT_POINTS_V
WHERE OWNER_TABLE_NAME = 'HZ_PARTIES'
AND CONTACT_POINT_TYPE IN ('PHONE'
, 'EMAIL'
, 'FAX')