ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN BE1E0F5B6EFF07E2E0530100007F2DB9 select distinct rv.view_alias data_object, listagg(rf.folder_name,'; ') within group (order by rf.folder_name) over (partition by rv.view_id) data_object_folders, rv.schema_name, rv.db_view_name db_view, case when rv.description<>rv.view_alias and rv.description<>rv.db_view_name then rv.description end description, decode(rv.view_type,'D','Database Object','S','SQL Query') view_type, xxen_util.user_name(rv.created_by) created_by, xxen_util.client_time(rv.creation_date) creation_date, xxen_util.user_name(rv.last_updated_by) last_updated_by, xxen_util.client_time(rv.last_update_date) last_update_date, lower(replace(regexp_replace(rv.db_view_name,'([^_]{1})[^_]*','\1'),'_')) alias, rv.view_id from rx_views rv, rx_folder_association rfa, rx_folders rf where 1=1 and rv.view_id=rfa.view_id(+) and rfa.folder_id=rf.folder_id(+) order by rv.schema_name, rv.db_view_name Y US RWB Views (Data Objects) List of Polaris Reporting Workbench views (data objects) RWB 1=1 1 100 1=1 rv.view_id in ( with x as (select distinct rrs.report_id from rx_report_stats rrs where rrs.start_time>sysdate-:history_days) select rvc.view_id from rx_report_columns rrc, rx_view_columns rvc where rrc.report_id in (select x.report_id from x) and rrc.view_column_id=rvc.view_column_id union select rvj.source_view_id view_id from rx_view_joins rvj where rvj.join_id in (select rrj.join_id from rx_report_joins rrj where rrj.report_id in (select x.report_id from x) and rrj.enabled_flag='Y') union select rvj.dest_view_id view_id from rx_view_joins rvj where rvj.join_id in (select rrj.join_id from rx_report_joins rrj where rrj.report_id in (select x.report_id from x) and rrj.enabled_flag='Y') ) Number 365 F Utilisé dans les x jours US Used witin x days