[Home] [Help] [Dependency Information]
Object Name: | WPS_PREFERENCES |
---|---|
Object Type: | TABLE |
Owner: | WPS |
FND Design Data: | WPS.WPS_PREFERENCES |
Subobject Name: | |
Status: | VALID |
The WPS_PREFERENCES table holds user level settings that are used in the various applications
for Manufacturing Scheduling. The values in the table pertain to specific settings that may be
used by the individual applications. For example, in the Resource Scheduling Workbench
the values may include the resources that are selected, row height, and job filters.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WPS_PREFERENCES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
APPLICATION_ID
USER_ID PREFERENCE_TYPE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_ID | NUMBER | Yes | Unique key for this row in the table | |
APPLICATION_ID | NUMBER | Yes | The application that the preference is associated with | |
ORGANIZATION_ID | NUMBER | Yes | Organization identifier | |
USER_ID | NUMBER | Yes | User identifier | |
PREFERENCE_TYPE | NUMBER | (10) | Yes | Type of preference. Application specific. |
VALUE | VARCHAR2 | (2000) | Value of the preference | |
VALUE_INDEX | NUMBER | Index of the saved preference. Used when a preference type spans multiple rows. | ||
LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column | |
CREATION_DATE | DATE | Yes | Standard who column | |
CREATED_BY | NUMBER | Yes | Standard who column |
Cut, paste (and edit) the following text to query this object:
SELECT PREFERENCE_ID
, APPLICATION_ID
, ORGANIZATION_ID
, USER_ID
, PREFERENCE_TYPE
, VALUE
, VALUE_INDEX
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
FROM WPS.WPS_PREFERENCES;
WPS.WPS_PREFERENCES does not reference any database object
WPS.WPS_PREFERENCES is referenced by following:
|
|
|