[Home] [Help]
View: OKR_LAUNCHPAD_INBOX_V
| Product: | OKR - Contracts for Rights (Obsolete) |
|---|
| Description: | View on wf_notifications , wf_notification_attributes, wf_messages_vl ,wf_lookups_tl, fnd_user ,okc_k_headers_b |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT WF.NOTIFICATION_ID NOTIFICATION_ID
, WF.GROUP_ID GROUP_ID
, F.USER_ID USER_ID
, WF.MESSAGE_TYPE MESSAGE_TYPE
, WF.MESSAGE_NAME MESSAGE_NAME
, WF.RECIPIENT_ROLE RECIPIENT_ROLE
, L.MEANING STATUS
, WF.PRIORITY PRIORITY
, WF.BEGIN_DATE BEGIN_DATE
, WF.END_DATE END_DATE
, WF.DUE_DATE DUE_DATE
, WF.USER_COMMENT USER_COMMENT
, WF_NOTIFICATION.GETSUBJECT(WF.NOTIFICATION_ID) SUBJECT
, 'MESSAGE' MESSAGE
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, CHRB.ID CONTRACT_ID
, 1 DUMMY_SORT
FROM WF_NOTIFICATIONS WF
, WF_NOTIFICATION_ATTRIBUTES WNA
, WF_MESSAGES_VL WM
, WF_LOOKUPS_TL L
, FND_USER F
, OKC_K_HEADERS_B CHRB
WHERE WNA.NOTIFICATION_ID = WF.NOTIFICATION_ID
AND WNA.NAME = 'CONTRACT_ID'
AND WF.MESSAGE_NAME = WM.NAME
AND WF.MESSAGE_TYPE = WM.TYPE
AND L.LANGUAGE = USERENV('LANG')
AND L.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
AND WF.STATUS = L.LOOKUP_CODE
AND WF.RECIPIENT_ROLE = F.USER_NAME
AND CHRB.ID =WNA.NUMBER_VALUE
AND CHRB.SCS_CODE ='TDE_RIGHT'
Columns
| Name |
| NOTIFICATION_ID |
| GROUP_ID |
| USER_ID |
| MESSAGE_TYPE |
| MESSAGE_NAME |
| RECIPIENT_ROLE |
| STATUS |
| PRIORITY |
| BEGIN_DATE |
| END_DATE |
| DUE_DATE |
| USER_COMMENT |
| SUBJECT |
| MESSAGE |
| CONTRACT_NUMBER |
| CONTRACT_ID |
| DUMMY_SORT |