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: APPS.WF_WORKLIST_V

Source

View Text - Preformatted


SELECT /* $Header: afwf.odf 120.31.12020000.3 2013/03/25 20:35:25 vshanmug ship $ */ WN.ROWID, WN.NOTIFICATION_ID, WN.PRIORITY, WIT.DISPLAY_NAME, WN.RECIPIENT_ROLE, WN.SUBJECT, WN.BEGIN_DATE, WN.DUE_DATE, WN.END_DATE, WL.MEANING, WN.STATUS, WN.ORIGINAL_RECIPIENT, WN.MESSAGE_TYPE, WN.MESSAGE_NAME, WN.FROM_USER, WN.TO_USER, WN.LANGUAGE, WN.MORE_INFO_ROLE from WF_NOTIFICATIONS WN, WF_ITEM_TYPES_TL WIT, WF_LOOKUPS_TL WL WHERE WN.MESSAGE_TYPE = WIT.NAME and WIT.LANGUAGE = userenv('LANG') and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS' and WN.STATUS = WL.LOOKUP_CODE and WL.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT /* $HEADER: AFWF.ODF 120.31.12020000.3 2013/03/25 20:35:25 VSHANMUG SHIP $ */ WN.ROWID
, WN.NOTIFICATION_ID
, WN.PRIORITY
, WIT.DISPLAY_NAME
, WN.RECIPIENT_ROLE
, WN.SUBJECT
, WN.BEGIN_DATE
, WN.DUE_DATE
, WN.END_DATE
, WL.MEANING
, WN.STATUS
, WN.ORIGINAL_RECIPIENT
, WN.MESSAGE_TYPE
, WN.MESSAGE_NAME
, WN.FROM_USER
, WN.TO_USER
, WN.LANGUAGE
, WN.MORE_INFO_ROLE
FROM WF_NOTIFICATIONS WN
, WF_ITEM_TYPES_TL WIT
, WF_LOOKUPS_TL WL
WHERE WN.MESSAGE_TYPE = WIT.NAME
AND WIT.LANGUAGE = USERENV('LANG')
AND WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
AND WN.STATUS = WL.LOOKUP_CODE
AND WL.LANGUAGE = USERENV('LANG')