VIEW: APPS.OKL_AM_CONTACT_POINTS_UV

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'