eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: APPLSYS.WF_PROCESS_ACTIVITIES

Object Details

Object Name:	WF_PROCESS_ACTIVITIES
Object Type:	TABLE
Owner:	APPLSYS
FND Design Data:	FND.WF_PROCESS_ACTIVITIES
Subobject Name:
Status:	VALID

WF_PROCESS_ACTIVITIES stores the data for an activity within a
specific process.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WF_PROCESS_ACTIVITIES_PK	NORMAL	UNIQUE	APPS_TS_SEED	INSTANCE_ID ZD_EDITION_NAME
WF_PROCESS_ACTIVITIES_U2	NORMAL	UNIQUE	APPS_TS_SEED	INSTANCE_LABEL PROCESS_ITEM_TYPE PROCESS_NAME PROCESS_VERSION ZD_EDITION_NAME
WF_PROCESS_ACTIVITIES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ACTIVITY_ITEM_TYPE ACTIVITY_NAME
WF_PROCESS_ACTIVITIES_N2	NORMAL	NONUNIQUE	APPS_TS_SEED	PROCESS_ITEM_TYPE PROCESS_NAME PROCESS_VERSION

Columns

Name	Datatype	Length	Mandatory	Comments
PROCESS_ITEM_TYPE	VARCHAR2	(8)	Yes	Item type of the process
PROCESS_NAME	VARCHAR2	(30)	Yes	Name of the process
PROCESS_VERSION	NUMBER		Yes	Version of the process
ACTIVITY_ITEM_TYPE	VARCHAR2	(8)	Yes	Item type of the activity
ACTIVITY_NAME	VARCHAR2	(30)	Yes	Internal name of the activity
INSTANCE_ID	NUMBER		Yes	Instance ID of an activity used more than once in a process
INSTANCE_LABEL	VARCHAR2	(30)	Yes	Unique name for an activity in a process
PERFORM_ROLE_TYPE	VARCHAR2	(8)	Yes	A constant or an attribute
PROTECT_LEVEL	NUMBER		Yes	Level at which the data is protected
CUSTOM_LEVEL	NUMBER		Yes	Level of user who last updated the row
START_END	VARCHAR2	(8)		Indicates if an activity is a Start or End activity
DEFAULT_RESULT	VARCHAR2	(30)		Default result if no result is returned
ICON_GEOMETRY	VARCHAR2	(2000)		Geometry placement of an activity icon in a Workflow diagram
PERFORM_ROLE	VARCHAR2	(320)		The role a notification is sent to
USER_COMMENT	VARCHAR2	(240)		User comments
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_ITEM_TYPE
,      PROCESS_NAME
,      PROCESS_VERSION
,      ACTIVITY_ITEM_TYPE
,      ACTIVITY_NAME
,      INSTANCE_ID
,      INSTANCE_LABEL
,      PERFORM_ROLE_TYPE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      START_END
,      DEFAULT_RESULT
,      ICON_GEOMETRY
,      PERFORM_ROLE
,      USER_COMMENT
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_PROCESS_ACTIVITIES;

Dependencies

[top of page]

APPLSYS.WF_PROCESS_ACTIVITIES does not reference any database object

APPLSYS.WF_PROCESS_ACTIVITIES is referenced by following:

APPLSYS: WF_PROCESS_ACTIVITIES#