WF_ITEM_ACTIVITY_STATUSES_V (Oracle Workflow Help)

Oracle Workflow Guide
Release 2.6.2
Part Number A95265-02


	Previous	Next		Contents	Index	Glossary

WF_ITEM_ACTIVITY_STATUSES_V

This view contains denormalized information about a workflow process and its activities' statuses. Use this view to create custom queries and reports on the status of a particular item or process. The column descriptions of the view are as follows:

 Name                            Null?    Type

 ------------------------------- -------- ----

 ROW_ID                                   ROWID

 SOURCE                                   CHAR(1)

 ITEM_TYPE                                VARCHAR2(8)

 ITEM_TYPE_DISPLAY_NAME                   VARCHAR2(80)

 ITEM_TYPE_DESCRIPTION                    VARCHAR2(240)

 ITEM_KEY                                 VARCHAR2(240)

 USER_KEY                                 VARCHAR2(240)

 ITEM_BEGIN_DATE                          DATE

 ITEM_END_DATE                            DATE

 ACTIVITY_ID                              NUMBER

 ACTIVITY_LABEL                           VARCHAR2(30)

 ACTIVITY_NAME                            VARCHAR2(30)

 ACTIVITY_DISPLAY_NAME                    VARCHAR2(80)

 ACTIVITY_DESCRIPTION                     VARCHAR2(240)

 ACTIVITY_TYPE_CODE                       VARCHAR2(8)

 ACTIVITY_TYPE_DISPLAY_NAME               VARCHAR2(80)

 EXECUTION_TIME                           NUMBER

 ACTIVITY_BEGIN_DATE                      DATE

 ACTIVITY_END_DATE                        DATE

 ACTIVITY_STATUS_CODE                     VARCHAR2(8)

 ACTIVITY_STATUS_DISPLAY_NAME             VARCHAR2(80)

 ACTIVITY_RESULT_CODE                     VARCHAR2(30)

 ACTIVITY_RESULT_DISPLAY_NAME             VARCHAR2(4000)

 ASSIGNED_USER                            VARCHAR2(30)

 ASSIGNED_USER_DISPLAY_NAME               VARCHAR2(4000)

 NOTIFICATION_ID                          NUMBER

 OUTBOUND_QUEUE_ID                        RAW(16)

 ERROR_NAME                               VARCHAR2(30)

 ERROR_MESSAGE                            VARCHAR2(2000)

 ERROR_STACK                              VARCHAR2(4000)

Contents

Index

Glossary