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_ITEMS

Object Details

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

WF_ITEMS is the runtime table for workflow processes. Each row
defines one work item within the system.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
WF_ITEMS_PK	NORMAL	UNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ITEM_KEY
WF_ITEMS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PARENT_ITEM_TYPE PARENT_ITEM_KEY
WF_ITEMS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BEGIN_DATE
WF_ITEMS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE END_DATE
WF_ITEMS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ITEM_TYPE ROOT_ACTIVITY OWNER_ROLE
WF_ITEMS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_KEY
WF_ITEMS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_ROLE

Columns

Name	Datatype	Length	Mandatory	Comments
ITEM_TYPE	VARCHAR2	(8)	Yes	Internal name for the Item Type
ITEM_KEY	VARCHAR2	(240)	Yes	Holds the primary key generated for the item type
ROOT_ACTIVITY	VARCHAR2	(30)	Yes	Top level proces it is running
ROOT_ACTIVITY_VERSION	NUMBER		Yes	Version of the top level process
OWNER_ROLE	VARCHAR2	(320)		Role of user who launched process
PARENT_ITEM_TYPE	VARCHAR2	(8)		Identifies components of the parent process
PARENT_ITEM_KEY	VARCHAR2	(240)		Identifies components of the parent process
PARENT_CONTEXT	VARCHAR2	(2000)		Identifies components of the parent process
BEGIN_DATE	DATE		Yes	Start date
END_DATE	DATE			Date finished
USER_KEY	VARCHAR2	(240)		User friendly key
HA_MIGRATION_FLAG	VARCHAR2	(1)		Supports Workflow migration for the High Availability project.
SECURITY_GROUP_ID	VARCHAR2	(32)		identifier reserved for hosting environment
INST_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT ITEM_TYPE
,      ITEM_KEY
,      ROOT_ACTIVITY
,      ROOT_ACTIVITY_VERSION
,      OWNER_ROLE
,      PARENT_ITEM_TYPE
,      PARENT_ITEM_KEY
,      PARENT_CONTEXT
,      BEGIN_DATE
,      END_DATE
,      USER_KEY
,      HA_MIGRATION_FLAG
,      SECURITY_GROUP_ID
,      INST_ID
FROM APPLSYS.WF_ITEMS;

Dependencies

[top of page]

APPLSYS.WF_ITEMS does not reference any database object

APPLSYS.WF_ITEMS is referenced by following:

APPLSYS: WF_ITEMS#