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_ACTIVITIES

Object Details

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

WF_ACTIVITIES table stores the definition of an activity.
Activities can be processes, notifications, functions or folders.
A process activity is a modelled workflow process, which can be
included as an activity in other processes to represent a sub-process.
A notification activity sends a message to a performer.
A functions activity performs an automated function that is written
as a PL/SQL stored procedure. A folder activity is not part of a
process, it provides a means of grouping activities.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WF_ACTIVITIES_PK	NORMAL	UNIQUE	APPS_TS_SEED	ITEM_TYPE NAME VERSION ZD_EDITION_NAME
WF_ACTIVITIES_N1	NORMAL	NONUNIQUE	APPS_TS_SEED	ERROR_ITEM_TYPE ERROR_PROCESS

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_TYPE	VARCHAR2	(8)	Yes	Internal name for the Item Type that owns the message
NAME	VARCHAR2	(30)	Yes	Internal name for the activity
VERSION	NUMBER		Yes	Version of the activity
TYPE	VARCHAR2	(8)	Yes	Type of activity (FOLDER, FUNCTION, NOTICE or PROCESS)
RERUN	VARCHAR2	(8)	Yes	Determines if activity is rerun during looping
EXPAND_ROLE	VARCHAR2	(1)	Yes	Determines how many roles are required to respond to a notification activity.
PROTECT_LEVEL	NUMBER		Yes	level at which the data is protected
CUSTOM_LEVEL	NUMBER		Yes	Level of user who last updated the row
BEGIN_DATE	DATE		Yes	Start date
END_DATE	DATE			Date finished
FUNCTION	VARCHAR2	(240)		PL/SQL function run for PL/SQL activities
RESULT_TYPE	VARCHAR2	(30)		Result code of the activity
COST	NUMBER			Assigned cost of the activity
READ_ROLE	VARCHAR2	(320)		Not currently used
WRITE_ROLE	VARCHAR2	(320)		Not currently used
EXECUTE_ROLE	VARCHAR2	(320)		Not currently used
ICON_NAME	VARCHAR2	(30)		Name of activity icon used in process window
MESSAGE	VARCHAR2	(30)		Name of the message for a notification activity
ERROR_PROCESS	VARCHAR2	(30)		Workflow process to run in case of an error
ERROR_ITEM_TYPE	VARCHAR2	(8)	Yes	Name of item type to execute in case of error
RUNNABLE_FLAG	VARCHAR2	(1)	Yes	Flag (Y or N) to indicate if activity is runnable
FUNCTION_TYPE	VARCHAR2	(30)		Indicates whether function type is pl/sql or internal
EVENT_NAME	VARCHAR2	(240)		Event name to be raised, sent or received.
DIRECTION	VARCHAR2	(30)		What direction the above event is used (RAISE, SEND, RECEIVE).
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 ITEM_TYPE
,      NAME
,      VERSION
,      TYPE
,      RERUN
,      EXPAND_ROLE
,      PROTECT_LEVEL
,      CUSTOM_LEVEL
,      BEGIN_DATE
,      END_DATE
,      FUNCTION
,      RESULT_TYPE
,      COST
,      READ_ROLE
,      WRITE_ROLE
,      EXECUTE_ROLE
,      ICON_NAME
,      MESSAGE
,      ERROR_PROCESS
,      ERROR_ITEM_TYPE
,      RUNNABLE_FLAG
,      FUNCTION_TYPE
,      EVENT_NAME
,      DIRECTION
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM APPLSYS.WF_ACTIVITIES;

Dependencies

[top of page]

APPLSYS.WF_ACTIVITIES does not reference any database object

APPLSYS.WF_ACTIVITIES is referenced by following:

APPLSYS: WF_ACTIVITIES#