This view is a select-only version of the WF_ITEMS table.
The following table describes the columns of the view.
WF_ITEMS_V Columns
| Name | Null? | Type |
|---|---|---|
| ITEM_TYPE | NOT NULL | VARCHAR2(8) |
| ITEM_KEY | NOT NULL | VARCHAR2(240) |
| USER_KEY | VARCHAR2(240) | |
| ROOT_ACTIVITY | NOT NULL | VARCHAR2(30) |
| ROOT_ACTIVITY_VERSION | NOT NULL | NUMBER |
| OWNER_ROLE | VARCHAR2(30) | |
| PARENT_ITEM_TYPE | VARCHAR2(8) | |
| PARENT_ITEM_KEY | VARCHAR2(240) | |
| PARENT_CONTEXT | VARCHAR2(2000) | |
| BEGIN_DATE | NOT NULL | DATE |
| END_DATE | DATE |
Note: The item key for a process instance can only contain single-byte characters. It cannot contain a multibyte value.