eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.CSC_HZ_CONTACT_PREFERENCES_V

Object Details

Object Name:	CSC_HZ_CONTACT_PREFERENCES_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This is a view of hz_contact_preferences.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
CONTACT_PREFERENCE_ID	NUMBER	(15)	Yes	Unique Identifier of Contact Preference Record.
CONTACT_LEVEL_TABLE	VARCHAR2	(30)	Yes	Table storing the contact level of the contact preference. Uses the SUBJECT_TABLE lookup. Values can be HZ_PARTIES,HZ_PARTY_SITES or HZ_CONTACT_POINTS.
CONTACT_LEVEL_TABLE_ID	NUMBER	(15)	Yes	FK to CONTACT_LEVEL_TABLE. Identifies the contact level at which the contact preference is to be assigned.
CONTACT_TYPE	VARCHAR2	(30)	Yes	Type of contact that should or should not be made with the party. Uses the CONTACT_TYPE lookup.
PREFERENCE_CODE	VARCHAR2	(30)	Yes	Permission to use or not to use a contact media. Uses the PREFERENCE_CODE lookup. Values can be Do or Do Not.
PREFERENCE_CODE_MEANING	VARCHAR2	(80)	Yes	Meaning from Lookups for preference_code
PREFERENCE_TOPIC_TYPE	VARCHAR2	(30)		The subject of the content to be sent or not sent to the party for which the preference is created. Uses the PREFERENCE_TOPIC_TYPE lookup.
PREFERENCE_TOPIC_TYPE_ID	NUMBER	(15)		Reduced LOV depending on the Preference Topic table selected. The PREFERENCE_TOPIC_TYPE_ID and PREFERENCE_TOPIC_TYPE_CODE are mutually exclusive.
PREFERENCE_TOPIC_TYPE_CODE	VARCHAR2	(30)		Reduced LOV depending on the Preference Topic table selected. The PREFERENCE_TOPIC_TYPE_ID and PREFERENCE_TOPIC_TYPE_CODE are mutually exclusive.
PREF_TOPIC_TYPE_CODE_MEANING	VARCHAR2	(80)		Meaning from lookups for prefernce_topic_type_code
PREFERENCE_START_DATE	DATE		Yes	Start date of the period during which a party should or should not be contacted.
PREFERENCE_END_DATE	DATE			End date of the period during which a party should or should not be contacted.
PREFERENCE_START_TIME_HR	NUMBER			Start time hour, in 0-23 hour format, of the time range for the contact preference.
PREFERENCE_END_TIME_HR	NUMBER			End time hour, in 0-23 hour format, of the time range for the contact preference.
PREFERENCE_START_TIME_MI	NUMBER			Start time minute, in a 0-59 minute format, of the time range for the contact preference.
PREFERENCE_END_TIME_MI	NUMBER			End time minute, in a 0-59 minute format, of the time range for the contact preference.
REASON_CODE	VARCHAR2	(30)		Reason that this type of contact should or should not be made. Uses REASON_CODE lookup.
REASON_CODE_MEANING	VARCHAR2	(80)		Meaning for REASON_CODE
CREATED_BY	NUMBER	(15)	Yes	Standard Who Column
CREATION_DATE	DATE		Yes	Standard Who Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard Who Column
LAST_UPDATE_DATE	DATE		Yes	Standard Who Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard Who Column
OBJECT_VERSION_NUMBER	NUMBER	(15)		Version number for concurrency control purpose
STATUS	VARCHAR2	(1)	Yes	Record Status Flag
CREATED_BY_MODULE	VARCHAR2	(150)		TCA Who Column
APPLICATION_ID	NUMBER			TCA Who Column

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CONTACT_PREFERENCE_ID
,      CONTACT_LEVEL_TABLE
,      CONTACT_LEVEL_TABLE_ID
,      CONTACT_TYPE
,      PREFERENCE_CODE
,      PREFERENCE_CODE_MEANING
,      PREFERENCE_TOPIC_TYPE
,      PREFERENCE_TOPIC_TYPE_ID
,      PREFERENCE_TOPIC_TYPE_CODE
,      PREF_TOPIC_TYPE_CODE_MEANING
,      PREFERENCE_START_DATE
,      PREFERENCE_END_DATE
,      PREFERENCE_START_TIME_HR
,      PREFERENCE_END_TIME_HR
,      PREFERENCE_START_TIME_MI
,      PREFERENCE_END_TIME_MI
,      REASON_CODE
,      REASON_CODE_MEANING
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      OBJECT_VERSION_NUMBER
,      STATUS
,      CREATED_BY_MODULE
,      APPLICATION_ID
FROM APPS.CSC_HZ_CONTACT_PREFERENCES_V;

Dependencies

[top of page]

APPS.CSC_HZ_CONTACT_PREFERENCES_V references the following:

APPS: AR_LOOKUPS; FND_LOOKUP_VALUES; HZ_CONTACT_PREFERENCES

APPS.CSC_HZ_CONTACT_PREFERENCES_V is not referenced by any database object