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]

TABLE: AR.HZ_PARTY_PREFERENCES

Object Details

Object Name:	HZ_PARTY_PREFERENCES
Object Type:	TABLE
Owner:	AR
FND Design Data:	AR.HZ_PARTY_PREFERENCES
Subobject Name:
Status:	VALID

The HZ_PARTY_PREFERENCES table stores information about the preference values provided by a party. Each row defines the preference and the party's specific values for that preference. The preference is the combination of a CATEGORY and a PREFERENCE_CODE. The data type of the preference value can be a string, a number, or a date. The data type determines which VALUE column stores the party's preference value. Oracle Applications use this information to provide personalized information about a party. For example, a record could store the information that the Vision Corporation (PARTY_ID) prefers that their transaction (CATEGORY) currency (PREFERENCE_CODE) is US dollars (VARCHAR2).
.
The primary key for this table is PARTY_PREFERENCE_ID.
.
The HZ_PARTY_PREFERENCES table stores information about how a party prefers to interact with the system. Please do not attempt to use this table to store extensible attributes of a party.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
HZ_PARTY_PREFERENCES_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_PREFERENCE_ID
HZ_PARTY_PREFERENCES_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	PARTY_ID CATEGORY PREFERENCE_CODE VALUE_VARCHAR2 VALUE_NUMBER VALUE_DATE

Columns

Name	Datatype	Length	Mandatory	Comments
PARTY_PREFERENCE_ID	NUMBER	(15)	Yes	Unique indentifier for the party's preference
PARTY_ID	NUMBER	(15)	Yes	Party identifier
MODULE	VARCHAR2	(50)		The program that creates the preference. For example, TCA MOBILE CUSTOMER DIRECTORY
CATEGORY	VARCHAR2	(30)	Yes	A preference's category can be used to logically group one or more preference codes in a particular user interface. The combination of CATEGORY and PREFERENCE_CODE identifies a preference.
PREFERENCE_CODE	VARCHAR2	(30)	Yes	A preference code determines if a preference is a single value or a multiple value preference. The preference code is validated by the HZ_PREFERENCE lookup. The combination of CATEGORY and PREFERENCE_CODE identifies a preference.
VALUE_VARCHAR2	VARCHAR2	(240)		The preference value if the data type is VARCHAR2
VALUE_NUMBER	NUMBER			The preference value if the data type is NUMBER
VALUE_DATE	DATE			The preference value if the data type is DATE
VALUE_NAME	VARCHAR2	(50)		A user-defined alias for a preference value
ADDITIONAL_VALUE1	VARCHAR2	(150)		Additional preference value
ADDITIONAL_VALUE2	VARCHAR2	(150)		Additional preference value
ADDITIONAL_VALUE3	VARCHAR2	(150)		Additional preference value
ADDITIONAL_VALUE4	VARCHAR2	(150)		Additional preference value
ADDITIONAL_VALUE5	VARCHAR2	(150)		Additional preference value
OBJECT_VERSION_NUMBER	NUMBER			This column is used for locking purposes
CREATED_BY	NUMBER	(15)	Yes	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE		Yes	Standard who column - date when this row was created.
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).

Query Text

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


SELECT PARTY_PREFERENCE_ID
,      PARTY_ID
,      MODULE
,      CATEGORY
,      PREFERENCE_CODE
,      VALUE_VARCHAR2
,      VALUE_NUMBER
,      VALUE_DATE
,      VALUE_NAME
,      ADDITIONAL_VALUE1
,      ADDITIONAL_VALUE2
,      ADDITIONAL_VALUE3
,      ADDITIONAL_VALUE4
,      ADDITIONAL_VALUE5
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM AR.HZ_PARTY_PREFERENCES;

Dependencies

[top of page]

AR.HZ_PARTY_PREFERENCES does not reference any database object

AR.HZ_PARTY_PREFERENCES is referenced by following:

APPS: HZ_PARTY_PREFERENCES