View: OKS_CONTACT_POINTS_V

Product:	OKS - Service Contracts
Description:	This View is used to Show all the Contact points for the Contact Entered in the Service Authoring Form.
Implementation/DBA Data:	APPS.OKS_CONTACT_POINTS_V

View Text

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')

Columns