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)
