Blitz Report Column Templates

Description
Categories: Application, Enginatics
Repository: Github
select
xrv.report_name,
xrcs.selection_name template_name,
xxen_util.meaning(xrcs.public_flag,'YES_NO',0) public_flag,
xxen_util.user_name(xrcs.created_by) created_by,
xrcs.creation_date,
(select count(*) from xxen_report_col_sel_columns xrcsc where xrcs.selection_id=xrcsc.selection_id) column_count
from
xxen_reports_v xrv,
xxen_report_column_selections xrcs
where
1=1 and
xrv.report_id=xrcs.report_id
order by
xrv.report_name,
created_by,
xrcs.selection_name
Parameter Name SQL text Validation
Created By
xrcs.created_by=xxen_util.user_id(:created_by)
LOV
Report Name
upper(xrv.report_name) like upper(:report_name)
LOV
Creation Date From
xrcs.creation_date>=:creation_date_from
Date