Product: | OKX - Contracts Integration |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKX_CONTACT_POINTS_V |
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'