[Home] [Help] [Dependency Information]
Object Name: | FLM_EXE_PREF_ENTITIES |
---|---|
Object Type: | TABLE |
Owner: | FLM |
FND Design Data: | FLM.FLM_EXE_PREF_ENTITIES |
Subobject Name: | |
Status: | VALID |
FLM_EXE_PREFERENCES stores the details of preferences for different entities for execution workstation.
The set of preferences for a workstation contain single value preferences and multiple value preferences. This table stores multiple value preferences that drive different aspects of workstation , like which regions of information to be shown on each page and the order of these regions, list of sources from which the instruction list would be generated and their order.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
FLM_EXE_PREF_ENTITIES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PREFERENCE_ENTITY_ID |
FLM_EXE_PREF_ENTITIES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | PREFERENCE_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PREFERENCE_ENTITY_ID | NUMBER | Yes | Unique identifier for flow execution preference entity | |
PREFERENCE_ID | NUMBER | Yes | The parent of the preference entities | |
ENTITY_TYPE | NUMBER | Yes | The entity name/type | |
ENTITY_VALUE | VARCHAR2 | (240) | The value of the entity | |
ENTITY_SEQUENCE | NUMBER | Internal sequence within the same entity type entries | ||
CREATED_BY | NUMBER | Yes | Standard Who column | |
CREATION_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard Who column | |
OBJECT_VERSION_NUMBER | NUMBER | Yes | Object version number |
Cut, paste (and edit) the following text to query this object:
SELECT PREFERENCE_ENTITY_ID
, PREFERENCE_ID
, ENTITY_TYPE
, ENTITY_VALUE
, ENTITY_SEQUENCE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, OBJECT_VERSION_NUMBER
FROM FLM.FLM_EXE_PREF_ENTITIES;
FLM.FLM_EXE_PREF_ENTITIES does not reference any database object
FLM.FLM_EXE_PREF_ENTITIES is referenced by following:
|
|
|