eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: OKX_CONTACT_POINTS_V

Product:	OKX - Contracts Integration
Description:
Implementation/DBA Data:	APPS.OKX_CONTACT_POINTS_V

View Text

SELECT HCP.CONTACT_POINT_ID CONTACT_POINT_ID
, HCP.CONTACT_POINT_TYPE CONTACT_POINT_TYPE
, HCP.STATUS STATUS
, HCP.OWNER_TABLE_NAME OWNER_TABLE_NAME
, HCP.OWNER_TABLE_ID OWNER_TABLE_ID
, HCP.EMAIL_FORMAT EMAIL_FORMAT
, HCP.EMAIL_ADDRESS EMAIL_ADDRESS
, HCP.TELEPHONE_TYPE TELEPHONE_TYPE
, HCP.PHONE_AREA_CODE PHONE_AREA_CODE
, HCP.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, HCP.PHONE_NUMBER PHONE_NUMBER
, HCP.PHONE_EXTENSION PHONE_EXTENSION
, HCP.CONTENT_SOURCE_TYPE CONTENT_SOURCE_TYPE
, HCP.PRIMARY_FLAG PRIMARY_FLAG
, HCP.PHONE_LINE_TYPE PHONE_LINE_TYPE
FROM HZ_CONTACT_POINTS HCP
WHERE HCP.CONTENT_SOURCE_TYPE = 'USER_ENTERED'

Columns

Name
CONTACT_POINT_ID
CONTACT_POINT_TYPE
STATUS
OWNER_TABLE_NAME
OWNER_TABLE_ID
EMAIL_FORMAT
EMAIL_ADDRESS
TELEPHONE_TYPE
PHONE_AREA_CODE
PHONE_COUNTRY_CODE
PHONE_NUMBER
PHONE_EXTENSION
CONTENT_SOURCE_TYPE
PRIMARY_FLAG
PHONE_LINE_TYPE