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.

VIEW: APPLSYS.WF_ITEM_ACTIVITY_STATUSES#

Source

View Text - Preformatted


select ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, PROCESS_ACTIVITY PROCESS_ACTIVITY, ACTIVITY_STATUS ACTIVITY_STATUS, ACTIVITY_RESULT_CODE ACTIVITY_RESULT_CODE, ASSIGNED_USER ASSIGNED_USER, NOTIFICATION_ID NOTIFICATION_ID, BEGIN_DATE BEGIN_DATE, END_DATE END_DATE, EXECUTION_TIME EXECUTION_TIME, ERROR_NAME ERROR_NAME, ERROR_MESSAGE ERROR_MESSAGE, ERROR_STACK ERROR_STACK, OUTBOUND_QUEUE_ID OUTBOUND_QUEUE_ID, DUE_DATE DUE_DATE, SECURITY_GROUP_ID SECURITY_GROUP_ID, ACTION ACTION, PERFORMED_BY PERFORMED_BY, INST_ID INST_ID from "APPLSYS"."WF_ITEM_ACTIVITY_STATUSES"

View Text - HTML Formatted

SELECT ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, PROCESS_ACTIVITY PROCESS_ACTIVITY
, ACTIVITY_STATUS ACTIVITY_STATUS
, ACTIVITY_RESULT_CODE ACTIVITY_RESULT_CODE
, ASSIGNED_USER ASSIGNED_USER
, NOTIFICATION_ID NOTIFICATION_ID
, BEGIN_DATE BEGIN_DATE
, END_DATE END_DATE
, EXECUTION_TIME EXECUTION_TIME
, ERROR_NAME ERROR_NAME
, ERROR_MESSAGE ERROR_MESSAGE
, ERROR_STACK ERROR_STACK
, OUTBOUND_QUEUE_ID OUTBOUND_QUEUE_ID
, DUE_DATE DUE_DATE
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, ACTION ACTION
, PERFORMED_BY PERFORMED_BY
, INST_ID INST_ID
FROM "APPLSYS"."WF_ITEM_ACTIVITY_STATUSES"