VIEW: APPS.JTF_CONTACT_RESTRICTIONS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'