RWB Views (Data Objects)

➜ Back to Library
Description
Categories: RWB
List of Polaris Reporting Workbench views (data objects)
Run RWB Views (Data Objects) and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
RWB Reports RWB Folders and Folder Asscociations RWB Report Columns RWB Security RWB Execution History RWB Database Objects used by Report Views RWB Execution Summary DIS Workbooks, Folders, Items and LOVs Yanmar - Discount on order lines check
Blitz Report™

Blitz Report™ provides multiple benefits: