VIEW: APPS.OKX_LAUNCHPAD_INBOX_V

Source

View Text - Preformatted

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.status status_code, 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, wf_notification.getshortbody(wf.notification_id) message, OKC_QUERY.GetKnumber(wf.notification_id,'CONTRACT_ID') contract_number, OKC_QUERY.GetKmodifier(wf.notification_id,'CONTRACT_ID') contract_number_modifier, OKC_QUERY.GetKID(wf.notification_id,'CONTRACT_ID') contract_id , 1 dummy_sort FROM FND_USER F,WF_LOOKUPS_TL L,WF_NOTIFICATIONS WF WHERE 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 (wf.message_type in ( select wf_name from okc_process_defs_b where pdf_type='WPS' and usage in ('APPROVE','CHG_REQ_APPROVE')) OR wf.message_type in ( 'OKCALERT', 'OKSKPRCS'))

View Text - HTML Formatted

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.STATUS STATUS_CODE
, 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
, WF_NOTIFICATION.GETSHORTBODY(WF.NOTIFICATION_ID) MESSAGE
, OKC_QUERY.GETKNUMBER(WF.NOTIFICATION_ID
, 'CONTRACT_ID') CONTRACT_NUMBER
, OKC_QUERY.GETKMODIFIER(WF.NOTIFICATION_ID
, 'CONTRACT_ID') CONTRACT_NUMBER_MODIFIER
, OKC_QUERY.GETKID(WF.NOTIFICATION_ID
, 'CONTRACT_ID') CONTRACT_ID
, 1 DUMMY_SORT
FROM FND_USER F
, WF_LOOKUPS_TL L
, WF_NOTIFICATIONS WF
WHERE 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 (WF.MESSAGE_TYPE IN ( SELECT WF_NAME
FROM OKC_PROCESS_DEFS_B
WHERE PDF_TYPE='WPS'
AND USAGE IN ('APPROVE'
, 'CHG_REQ_APPROVE')) OR WF.MESSAGE_TYPE IN ( 'OKCALERT'
, 'OKSKPRCS'))