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

TABLE: APPLSYS.WF_ACTIVITY_ATTR_VALUES

Object Details
Object Name: WF_ACTIVITY_ATTR_VALUES
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.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.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ACTIVITY_ATTR_VALUES_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnPROCESS_ACTIVITY_ID
ColumnNAME
ColumnZD_EDITION_NAME
Columns
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
Query Text

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;

Dependencies

[top of page]

APPLSYS.WF_ACTIVITY_ATTR_VALUES does not reference any database object

APPLSYS.WF_ACTIVITY_ATTR_VALUES is referenced by following:

SchemaAPPLSYS
ViewWF_ACTIVITY_ATTR_VALUES#