Blitz Report Column Templates

Description
Categories: Enginatics
Repository: Github Columns: Report Name, Template Name, Public Flag, Column Count, Created By, Creation Date ...
select
xrv.report_name,
xrcs.selection_name template_name,
xxen_util.meaning(xrcs.public_flag,'YES_NO',0) public_flag,
(select count(*) from xxen_report_col_sel_columns xrcsc where xrcs.selection_id=xrcsc.selection_id) column_count,
xxen_util.user_name(xrcs.created_by) created_by,
xrcs.creation_date
&columns
from
xxen_reports_v xrv,
xxen_report_column_selections xrcs,
(select xrcsc.* from xxen_report_col_sel_columns xrcsc where '&show_columns'='Y') xrcsc
where
1=1 and
xrv.report_id=xrcs.report_id and
xrcs.selection_id=xrcsc.selection_id(+)
order by
xrv.report_name,
created_by,
xrcs.selection_name
&column_order_by
Parameter Name SQL text Validation
Created By
xrcs.created_by=xxen_util.user_id(:created_by)
LOV
Show Columns
Y
LOV
Report Name
upper(xrv.report_name) like upper(:report_name)
LOV
Creation Date From
xrcs.creation_date>=:creation_date_from
Date
Show Columns
,xrcsc.display_sequence
Show Columns
,xrcsc.display_sequence,
xrcsc.column_name,
xxen_report.column_translation(xrcsc.column_name) translation