VIEW: APPS.CSF_M_MAIL_RECIPIENTS_V

Source

View Text - Preformatted

SELECT acc.access_id , wfn.notification_id , csm_util_pkg.get_wf_attrText(wfn.notification_id,'#FROM_ROLE') as msgorigaddress , csm_util_pkg.get_varchar('N') as delete_flag , csm_util_pkg.get_wf_attrText(wfn.notification_id,'READ_FLAG') as read_flag , wfn.begin_date as datereceived , csm_util_pkg.get_varchar(wfn.recipient_role) as recipaddress , asg_base.get_resource_id(csm_util_pkg.get_wf_attrText(wfn.notification_id,'#FROM_ROLE')) as resource_id , asg_base.get_resource_id(wfn.recipient_role) as resource_recv_id , asg_base.get_user_name as client_name FROM CSM_NOTIFICATIONS_ACC acc, WF_NOTIFICATIONS wfn WHERE acc.notification_id = wfn.notification_id AND acc.user_id = asg_base.get_user_id AND ( (decode(substr(wfn.recipient_role,1,9),'JRES_GRP:','b','i')='i' AND EXISTS(select 1 from asg_user au where wfn.recipient_role = au.user_name and acc.user_id=au.owner_id) ) OR (decode(substr(wfn.recipient_role,1,9),'JRES_GRP:','b','i')='b' AND CSM_UTIL_PKG.get_group_owner(substr(wfn.recipient_role,instr(wfn.recipient_role,':')+1))=acc.user_id ) )

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, WFN.NOTIFICATION_ID
, CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, '#FROM_ROLE') AS MSGORIGADDRESS
, CSM_UTIL_PKG.GET_VARCHAR('N') AS DELETE_FLAG
, CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, 'READ_FLAG') AS READ_FLAG
, WFN.BEGIN_DATE AS DATERECEIVED
, CSM_UTIL_PKG.GET_VARCHAR(WFN.RECIPIENT_ROLE) AS RECIPADDRESS
, ASG_BASE.GET_RESOURCE_ID(CSM_UTIL_PKG.GET_WF_ATTRTEXT(WFN.NOTIFICATION_ID
, '#FROM_ROLE')) AS RESOURCE_ID
, ASG_BASE.GET_RESOURCE_ID(WFN.RECIPIENT_ROLE) AS RESOURCE_RECV_ID
, ASG_BASE.GET_USER_NAME AS CLIENT_NAME
FROM CSM_NOTIFICATIONS_ACC ACC
, WF_NOTIFICATIONS WFN
WHERE ACC.NOTIFICATION_ID = WFN.NOTIFICATION_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND ( (DECODE(SUBSTR(WFN.RECIPIENT_ROLE
, 1
, 9)
, 'JRES_GRP:'
, 'B'
, 'I')='I'
AND EXISTS(SELECT 1
FROM ASG_USER AU
WHERE WFN.RECIPIENT_ROLE = AU.USER_NAME
AND ACC.USER_ID=AU.OWNER_ID) ) OR (DECODE(SUBSTR(WFN.RECIPIENT_ROLE
, 1
, 9)
, 'JRES_GRP:'
, 'B'
, 'I')='B'
AND CSM_UTIL_PKG.GET_GROUP_OWNER(SUBSTR(WFN.RECIPIENT_ROLE
, INSTR(WFN.RECIPIENT_ROLE
, ':')+1))=ACC.USER_ID ) )