View: AMS_CONTACT_RESTRICTIONS_V

Product:	AMS - Marketing
Description:
Implementation/DBA Data:	APPS.AMS_CONTACT_RESTRICTIONS_V

View Text

SELECT HCPREF.CONTACT_PREFERENCE_ID
, HCPREF.CONTACT_LEVEL_TABLE
, HCPREF.CONTACT_LEVEL_TABLE_ID
, HCPREF.CONTACT_TYPE
, HCPREF.PREFERENCE_CODE
, HCPREF.PREFERENCE_TOPIC_TYPE
, HCPREF.PREFERENCE_TOPIC_TYPE_ID
, HCPREF.PREFERENCE_TOPIC_TYPE_CODE
, HCPREF.PREFERENCE_START_DATE
, HCPREF.PREFERENCE_END_DATE
, HCPREF.PREFERENCE_START_TIME_HR
, HCPREF.PREFERENCE_END_TIME_HR
, HCPREF.PREFERENCE_START_TIME_MI
, HCPREF.PREFERENCE_END_TIME_MI
, HCPREF.MAX_NO_OF_INTERACTIONS
, HCPREF.MAX_NO_OF_INTERACT_UOM_CODE
, HCPREF.REQUESTED_BY
, HCPREF.REASON_CODE
, HCPREF.CREATED_BY
, HCPREF.CREATION_DATE
, HCPREF.LAST_UPDATE_LOGIN
, HCPREF.LAST_UPDATE_DATE
, HCPREF.LAST_UPDATED_BY
, HCPREF.REQUEST_ID
, HCPREF.PROGRAM_APPLICATION_ID
, HCPREF.PROGRAM_ID
, HCPREF.PROGRAM_UPDATE_DATE
, HCPREF.OBJECT_VERSION_NUMBER
, HCPREF.STATUS
, HCPREF.CREATED_BY_MODULE
, HCPREF.APPLICATION_ID
FROM HZ_CONTACT_PREFERENCES HCPREF
WHERE HCPREF.PREFERENCE_CODE = 'DO_NOT'
AND HCPREF.CONTACT_LEVEL_TABLE = 'HZ_PARTIES'
AND HCPREF.PREFERENCE_END_DATE IS NULL

Columns