RWB Folders and Folder Asscociations
Description
Categories: RWB
Polaris Reporting Workbench folders, their included reports and accessed data objects
Run
RWB Folders and Folder Asscociations and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
