HZ_CONTACT_PREF_DN_V

Details

• Schema: FUSION

• Object owner: HZ

• Object type: VIEW

Columns

Name
CONTACT_LEVEL_TABLE CONTACT_LEVEL_TABLE_ID CONTACT_PREF_FLAG

Query

SQL_Statement
SELECT DISTINCT CONTACT_LEVEL_TABLE, CONTACT_LEVEL_TABLE_ID, 'Y' CONTACT_PREF_FLAG FROM HZ_CONTACT_PREFERENCES WHERE trunc(sysdate) between trunc(preference_start_date) and trunc(preference_end_date) AND preference_code = 'DO_NOT'