[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 |