View: JTF_CONTACT_RESTRICTIONS_V

Product:	JTF - CRM Foundation
Description:	The duration and reason for which a contact type is restricted
Implementation/DBA Data:	APPS.JTF_CONTACT_RESTRICTIONS_V

View Text

SELECT A.CONTACT_PREFERENCE_ID CONTACT_RESTRICTION_ID
, A.CONTACT_TYPE CONTACT_TYPE
, A.PREFERENCE_START_DATE RESTRICT_START_DATE
, A.PREFERENCE_END_DATE RESTRICT_END_DATE
, A.REASON_CODE RESTRICT_REASON
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.REQUEST_ID REQUEST_ID
, A.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, A.PROGRAM_ID PROGRAM_ID
, A.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, TO_DATE(NULL) WH_UPDATE_DATE
, A.CONTACT_LEVEL_TABLE SUBJECT_TABLE
, A.CONTACT_LEVEL_TABLE_ID SUBJECT_ID
FROM HZ_CONTACT_PREFERENCES A
WHERE A.PREFERENCE_CODE = 'DO_NOT'
AND A.CONTACT_LEVEL_TABLE <> 'HZ_CONTACT_POINTS'

Columns