View: OKL_AM_CONTACT_POINTS_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_CONTACT_POINTS_UV

View Text

SELECT HZC.OWNER_TABLE_ID CONTACT_PARTY_ID
, HZC.CONTACT_POINT_ID CONTACT_CONTACT_POINT_ID
, HZC.CONTACT_POINT_TYPE CONTACT_CONTACT_POINT_TYPE
, HZC.EMAIL_ADDRESS || DECODE (SIGN (LENGTH (HZC.PHONE_AREA_CODE))
, 1
, '(' || HZC.PHONE_AREA_CODE || ') ') || HZC.PHONE_NUMBER || DECODE (SIGN (LENGTH (HZC.PHONE_EXTENSION))
, 1
, ' (EXT. '|| HZC.PHONE_EXTENSION || ')') CONTACT_DETAILS
, HZC.EMAIL_ADDRESS CONTACT_EMAIL_ADDRESS
, HZC.PHONE_AREA_CODE CONTACT_PHONE_AREA_CODE
, HZC.PHONE_NUMBER CONTACT_PHONE_NUMBER
, HZC.PHONE_EXTENSION CONTACT_PHONE_EXTENSION
, HZC.OWNER_TABLE_ID OWNER_TABLE_ID
FROM OKX_CONTACT_POINTS_V HZC
WHERE HZC.OWNER_TABLE_NAME = 'HZ_PARTIES'
AND HZC.STATUS = 'A'

Columns