VIEW: APPS.CSF_M_MAIL_MESSAGES_V

Source

View Text - Preformatted

SELECT acc.access_id, wfn.notification_id, src.name as sender, wf_notification.getBody(wfn.notification_id,'text/plain') as message, wfn.begin_date as datereceived, csm_util_pkg.get_varchar(wfn.recipient_role) as receiver, asg_base.get_resource_id(wfn.recipient_role) as resource_id, asg_base.get_user_name as client_name, src.display_name as SENDER_FULL_NAME, recv.DISPLAY_NAME as RECEIVER_FULL_NAME, wf_notification.getSubject(wfn.notification_id) as SUBJECT, csm_util_pkg.get_varchar(decode(substr(wfn.recipient_role,1,9),'JRES_GRP:','b','i')) as MESSAGE_TYPE FROM CSM_NOTIFICATIONS_ACC acc, WF_NOTIFICATIONS wfn, wf_local_roles recv ,wf_local_roles src WHERE acc.notification_id = wfn.notification_id AND acc.user_id = asg_base.get_user_id AND recv.name=wfn.recipient_role and src.name(+)=csm_util_pkg.get_wf_attrText(wfn.notification_id,'#FROM_ROLE')

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, WFN.NOTIFICATION_ID
, SRC.NAME AS SENDER
, WF_NOTIFICATION.GETBODY(WFN.NOTIFICATION_ID
, 'TEXT/PLAIN') AS MESSAGE
, WFN.BEGIN_DATE AS DATERECEIVED
, CSM_UTIL_PKG.GET_VARCHAR(WFN.RECIPIENT_ROLE) AS RECEIVER
, ASG_BASE.GET_RESOURCE_ID(WFN.RECIPIENT_ROLE) AS RESOURCE_ID
, ASG_BASE.GET_USER_NAME AS CLIENT_NAME
, SRC.DISPLAY_NAME AS SENDER_FULL_NAME
, RECV.DISPLAY_NAME AS RECEIVER_FULL_NAME
, WF_NOTIFICATION.GETSUBJECT(WFN.NOTIFICATION_ID) AS SUBJECT
, CSM_UTIL_PKG.GET_VARCHAR(DECODE(SUBSTR(WFN.RECIPIENT_ROLE
, 1
, 9)
, 'JRES_GRP:'
, 'B'
, 'I')) AS MESSAGE_TYPE
FROM CSM_NOTIFICATIONS_ACC ACC
, WF_NOTIFICATIONS WFN
, WF_LOCAL_ROLES RECV
, WF_LOCAL_ROLES SRC
WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND RECV.NAME=WFN.RECIPIENT_ROLE
AND SRC.NAME(+)=CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, '#FROM_ROLE')