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: PA.PA_WF_NTF_PERFORMERS#

Source

View Text - Preformatted


select WF_TYPE_CODE WF_TYPE_CODE, ITEM_TYPE ITEM_TYPE, ITEM_KEY ITEM_KEY, OBJECT_ID1 OBJECT_ID1, OBJECT_ID2 OBJECT_ID2, USER_NAME USER_NAME, USER_TYPE USER_TYPE, ROUTING_ORDER ROUTING_ORDER, CURRENT_APPROVER_FLAG CURRENT_APPROVER_FLAG, APPROVER_COMMENTS APPROVER_COMMENTS, GROUP_ID GROUP_ID, APPROVER_GROUP_ID APPROVER_GROUP_ID, APPROVAL_STATUS APPROVAL_STATUS, SEQUENCE_NUMBER SEQUENCE_NUMBER, ACTION_CODE ACTION_CODE, ACTION_DATE ACTION_DATE, DISPLAY_FLAG DISPLAY_FLAG from "PA"."PA_WF_NTF_PERFORMERS"

View Text - HTML Formatted

SELECT WF_TYPE_CODE WF_TYPE_CODE
, ITEM_TYPE ITEM_TYPE
, ITEM_KEY ITEM_KEY
, OBJECT_ID1 OBJECT_ID1
, OBJECT_ID2 OBJECT_ID2
, USER_NAME USER_NAME
, USER_TYPE USER_TYPE
, ROUTING_ORDER ROUTING_ORDER
, CURRENT_APPROVER_FLAG CURRENT_APPROVER_FLAG
, APPROVER_COMMENTS APPROVER_COMMENTS
, GROUP_ID GROUP_ID
, APPROVER_GROUP_ID APPROVER_GROUP_ID
, APPROVAL_STATUS APPROVAL_STATUS
, SEQUENCE_NUMBER SEQUENCE_NUMBER
, ACTION_CODE ACTION_CODE
, ACTION_DATE ACTION_DATE
, DISPLAY_FLAG DISPLAY_FLAG
FROM "PA"."PA_WF_NTF_PERFORMERS"