[Home] [Help] [Dependency Information]
Object Name: | WF_ACTIVITY_ATTR_VALUES |
---|---|
Object Type: | TABLE |
Owner: | APPLSYS |
FND Design Data: | FND.WF_ACTIVITY_ATTR_VALUES |
Subobject Name: | |
Status: | VALID |
The WF_ACTIVITY_ATTR_VALUES table contains the data for the activity
attributes. Each row includes the process activity id and the
asociated value for the attribute.
Tablespace: | APPS_TS_SEED |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
WF_ACTIVITY_ATTR_VALUES_PK | NORMAL | UNIQUE | APPS_TS_SEED |
PROCESS_ACTIVITY_ID
NAME ZD_EDITION_NAME |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROCESS_ACTIVITY_ID | NUMBER | Yes | Reference to the instance identification | |
NAME | VARCHAR2 | (30) | Yes | Internal name |
VALUE_TYPE | VARCHAR2 | (8) | Yes | Defines if the default is a constant or a reference to a item attribute |
PROTECT_LEVEL | NUMBER | Yes | Level at which the data is protected | |
CUSTOM_LEVEL | NUMBER | Yes | Level of user who last updated the row | |
TEXT_VALUE | VARCHAR2 | (4000) | Holds a value if the type is text | |
NUMBER_VALUE | NUMBER | Holds a value if the type is number | ||
DATE_VALUE | DATE | Holds a value if the type is date | ||
SECURITY_GROUP_ID | VARCHAR2 | (32) | identifier reserved for hosting environment | |
ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
Cut, paste (and edit) the following text to query this object:
SELECT PROCESS_ACTIVITY_ID
, NAME
, VALUE_TYPE
, PROTECT_LEVEL
, CUSTOM_LEVEL
, TEXT_VALUE
, NUMBER_VALUE
, DATE_VALUE
, SECURITY_GROUP_ID
, ZD_EDITION_NAME
FROM APPLSYS.WF_ACTIVITY_ATTR_VALUES;
APPLSYS.WF_ACTIVITY_ATTR_VALUES does not reference any database object
APPLSYS.WF_ACTIVITY_ATTR_VALUES is referenced by following:
|
|
|