VIEW: APPS.CSF_M_MAIL_MESSAGES_V

Source

View Text - Preformatted

SELECT acc.access_id, wfn.notification_id, wfn.from_role as sender, csm_util_pkg.get_wf_attrText(wfn.notification_id,'MESSAGE_TEXT') as message, wfn.begin_date as datereceived, csm_util_pkg.get_varchar(wfn.recipient_role) as receiver, jtrs_recv.resource_id, asg_base.get_user_name as client_name, wfn.from_user as SENDER_FULL_NAME, wfn.to_user as RECEIVER_FULL_NAME, csm_util_pkg.get_wf_attrText(WFN.notification_id,'MSG_SUBJECT') as SUBJECT, csm_util_pkg.get_wf_attrText(wfn.notification_id,'MESSAGE_TYPE') as MESSAGE_TYPE FROM CSM_NOTIFICATIONS_ACC acc, WF_NOTIFICATIONS wfn, JTF_RS_RESOURCE_EXTNS jtrs_recv WHERE acc.notification_id = wfn.notification_id AND acc.user_id = asg_base.get_user_id AND jtrs_recv.user_name(+)=wfn.recipient_role

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, WFN.NOTIFICATION_ID
, WFN.FROM_ROLE AS SENDER
, CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, 'MESSAGE_TEXT') AS MESSAGE
, WFN.BEGIN_DATE AS DATERECEIVED
, CSM_UTIL_PKG.GET_VARCHAR(WFN.RECIPIENT_ROLE) AS RECEIVER
, JTRS_RECV.RESOURCE_ID
, ASG_BASE.GET_USER_NAME AS CLIENT_NAME
, WFN.FROM_USER AS SENDER_FULL_NAME
, WFN.TO_USER AS RECEIVER_FULL_NAME
, CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, 'MSG_SUBJECT') AS SUBJECT
, CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, 'MESSAGE_TYPE') AS MESSAGE_TYPE
FROM CSM_NOTIFICATIONS_ACC ACC
, WF_NOTIFICATIONS WFN
, JTF_RS_RESOURCE_EXTNS JTRS_RECV
WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND JTRS_RECV.USER_NAME(+)=WFN.RECIPIENT_ROLE