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

TABLE: APPLSYS.WF_ACTIVITY_TRANSITIONS

Object Details
Object Name: WF_ACTIVITY_TRANSITIONS
Object Type: TABLE
Owner: APPLSYS
FND Design Data: TableFND.WF_ACTIVITY_TRANSITIONS
Subobject Name:
Status: VALID


The WF_ACTIVITY_TRANSITIONS table defines the transitions from one
activity to another in a process. Each row includes the activities at
the beginning and end of the transition, as well as the result code
and physical location of the transition in the process window.


Storage Details
Tablespace: TablespaceAPPS_TS_SEED
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
WF_ACTIVITY_TRANSITIONS_PK NORMAL UNIQUE TablespaceAPPS_TS_SEED ColumnFROM_PROCESS_ACTIVITY
ColumnRESULT_CODE
ColumnTO_PROCESS_ACTIVITY
ColumnZD_EDITION_NAME
WF_ACTIVITY_TRANSITIONS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_SEED ColumnTO_PROCESS_ACTIVITY
Columns
Name Datatype Length Mandatory Comments
FROM_PROCESS_ACTIVITY NUMBER
Yes Origin activity of the transition
RESULT_CODE VARCHAR2 (30) Yes Y or N code asociated with the transition
TO_PROCESS_ACTIVITY NUMBER
Yes Destination activity of the transition
PROTECT_LEVEL NUMBER
Yes Level at which the data is protected
CUSTOM_LEVEL NUMBER
Yes Level of user who last updated the row
ARROW_GEOMETRY VARCHAR2 (2000)
Coordinates of the transition arrow
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 FROM_PROCESS_ACTIVITY
,      RESULT_CODE
,      TO_PROCESS_ACTIVITY
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      ARROW_GEOMETRY
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_ACTIVITY_TRANSITIONS;

Dependencies

[top of page]

APPLSYS.WF_ACTIVITY_TRANSITIONS does not reference any database object

APPLSYS.WF_ACTIVITY_TRANSITIONS is referenced by following:

SchemaAPPLSYS
ViewWF_ACTIVITY_TRANSITIONS#