RWB Folders and Folder Asscociations

Description
Categories: RWB
Polaris Reporting Workbench folders, their included reports and accessed data objects

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

select
decode(rf.folder_type,'ADMIN','Data Objects','SEEDED','Seeded Reports','Oracle Reports') folder_type,
rf.folder_name,
rf.description,
xxen_util.user_name(rf.owner_person_id) owner,
xxen_util.user_name(rf.previous_owner_person_id) previous_owner,
rv.view_alias,
rv.db_view_name,
rr.report_name,
xxen_util.user_name(rfa.user_id) user_name,
xxen_util.user_name(rf.created_by) folder_created_by,
xxen_util.client_time(rf.creation_date) folder_creation_date,
xxen_util.user_name(rf.last_updated_by) folder_last_updated_by,
xxen_util.client_time(rf.last_update_date) folder_last_update_date,
xxen_util.user_name(rfa.created_by) association_created_by,
xxen_util.client_time(rfa.creation_date) association_creation_date,
xxen_util.user_name(rfa.last_updated_by) association_last_updated_by,
xxen_util.client_time(rfa.last_update_date) association_last_update_date,
rf.folder_key,
(select rf0.folder_name from rx_folders rf0 where rf.parent_folder_id=rf0.folder_id) parent_folder,
rf.folder_type
from
rx_folders rf,
rx_folder_association rfa,
rx_views rv,
rx_reports rr
where
rf.folder_id=rfa.folder_id and
rfa.view_id=rv.view_id(+) and
rfa.report_id=rr.report_id(+)
order by
rf.folder_type,
rf.folder_name,
rv.view_alias,
rr.report_name