Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT CONTACT_PREFERENCE_ID CONTACT_RESTRICTION_ID
, CONTACT_LEVEL_TABLE SUBJECT_TABLE
, CONTACT_LEVEL_TABLE_ID SUBJECT_ID
, CONTACT_TYPE CONTACT_TYPE
, PREFERENCE_START_DATE RESTRICT_START_DATE
, PREFERENCE_END_DATE RESTRICT_END_DATE
, REASON_CODE RESTRICT_REASON
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, STATUS STATUS
, TO_DATE(NULL) WH_UPDATE_DATE
FROM HZ_CONTACT_PREFERENCES
WHERE PREFERENCE_CODE = 'DO_NOT'
AND CONTACT_LEVEL_TABLE <> 'HZ_CONTACT_POINTS'