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.

[Home] [Help]

View: WF_WORKLIST_V

Product:	FND - Application Object Library
Description:	Public view for worklist
Implementation/DBA Data:	APPS.WF_WORKLIST_V

View Text

SELECT /* $HEADER: VIEW_FND_R12.LDT 120.6 2012/06/21 17:12:42 JVALENTI 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')

Columns

Name
ROW_ID
NID
PRIORITY
MESSAGE_TYPE
RECIPIENT_ROLE
SUBJECT
BEGIN_DATE
DUE_DATE
END_DATE
DISPLAY_STATUS
STATUS
ORIGINAL_RECIPIENT
ITEM_TYPE
MESSAGE_NAME
FROM_USER
TO_USER
LANGUAGE
MORE_INFO_ROLE