RWB Security

select
nvl2(rfrs.folder_id,'Folder','Report') security_type,
nvl(
decode(rr.report_type,'USER','Adhoc','SEEDED','Seeded Adhoc','DASH_BOARD','BI Publisher','VAR','PL/SQL Custom','FLEX','Dashboard','SEEDED_VAR','Seeded PL/SQL Custom',rr.report_type),
decode(rf.folder_type,'ADMIN','Data Objects','SEEDED','Seeded Reports','Oracle Reports')
) type,
nvl(rf.folder_name,rr.report_name) name,
xxen_util.user_name(rr.owner_person_id) report_owner,
frv.responsibility_name,
xxen_util.user_name(nullif(rfrs.user_id,rr.owner_person_id)) user_name,
decode(rfrs.share_level,1,'Report',2,'Output',3,'Report & Output') share_level,
xxen_util.user_name(rfrs.created_by) shared_by,
xxen_util.client_time(rfrs.creation_date) shared_date,
xxen_util.user_name(rfrs.last_updated_by) last_updated_by,
xxen_util.client_time(rfrs.last_update_date) last_update_date,
rfrs.folder_id,
rfrs.report_id,
rfrs.responsibility_id,
rfrs.user_id
from
rx_folder_report_security rfrs,
rx_folders rf,
rx_reports rr,
fnd_responsibility_vl frv
where
1=1 and
rfrs.folder_id=rf.folder_id(+) and
rfrs.report_id=rr.report_id(+) and
rfrs.responsibility_id=frv.responsibility_id(+) and
nvl(frv.responsibility_key,'x') not in ('XXRX_ADMINISTRATOR','XXRX_REPORTING_USER')
order by
nvl2(rfrs.folder_id,1,2),
type,
name,
frv.responsibility_name,
user_name

select nvl2(rfrs.folder_id,'Folder','Report') security_type, nvl( decode(rr.report_type,'USER','Adhoc','SEEDED','Seeded Adhoc','DASH_BOARD','BI Publisher','VAR','PL/SQL Custom','FLEX','Dashboard','SEEDED_VAR','Seeded PL/SQL Custom',rr.report_type), decode(rf.folder_type,'ADMIN','Data Objects','SEEDED','Seeded Reports','Oracle Reports') ) type, nvl(rf.folder_name,rr.report_name) name, xxen_util.user_name(rr.owner_person_id) report_owner, frv.responsibility_name, xxen_util.user_name(nullif(rfrs.user_id,rr.owner_person_id)) user_name, decode(rfrs.share_level,1,'Report',2,'Output',3,'Report & Output') share_level, xxen_util.user_name(rfrs.created_by) shared_by, xxen_util.client_time(rfrs.creation_date) shared_date, xxen_util.user_name(rfrs.last_updated_by) last_updated_by, xxen_util.client_time(rfrs.last_update_date) last_update_date, rfrs.folder_id, rfrs.report_id, rfrs.responsibility_id, rfrs.user_id from rx_folder_report_security rfrs, rx_folders rf, rx_reports rr, fnd_responsibility_vl frv where 1=1 and rfrs.folder_id=rf.folder_id(+) and rfrs.report_id=rr.report_id(+) and rfrs.responsibility_id=frv.responsibility_id(+) and nvl(frv.responsibility_key,'x') not in ('XXRX_ADMINISTRATOR','XXRX_REPORTING_USER') order by nvl2(rfrs.folder_id,1,2), type, name, frv.responsibility_name, user_name