RWB Views (Data Objects)

Description
Categories: RWB
List of Polaris Reporting Workbench views (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 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
Parameter Name SQL text Validation
Used witin x days
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