Blitz Report Templates

Description
Categories: Enginatics
Repository: Github Columns: Report Name, Template Name, Public Flag, Global Default, Column Count, Owner, Creation Date ...
Blitz Report column or pivot aggregation layout templates
select
xrtv.report_name,
xrtv.template_name,
xxen_util.meaning(xrtv.public_flag,'YES_NO',0) public_flag,
xxen_util.meaning(xrtv.global_default,'YES_NO',0) global_default,
(select count(*) from xxen_report_template_columns xrtc where xrtv.template_id=xrtc.template_id) column_count,
xrtv.owner,
xrtv.creation_date
&columns
from
xxen_report_templates_v xrtv,
(select xrtc.* from xxen_report_template_columns xrtc where '&show_columns'='Y') xrtc
where
1=1 and
xrtv.template_id=xrtc.template_id(+)
order by
xrtv.report_name,
owner,
xrtv.template_name
&column_order_by
Parameter Name SQL text Validation
Owner
xrtv.created_by=xxen_util.user_id(:created_by)
LOV
Show Columns
Y
LOV
Report Name
upper(xrtv.report_name) like upper(:report_name)
LOV
Category
xrv.report_id in (
select
xrca.report_id
from
xxen_report_category_assigns xrca,
xxen_report_categories_v xrcv
where
xrcv.category=:category and
xrcv.category_id=xrca.category_id
)
LOV
Creation Date From
xrtv.creation_date>=:creation_date_from
Date
Show Columns
,xrtc.display_sequence
Show Columns
,xrtc.display_sequence,
xrtc.column_name,
xxen_report.column_translation(xrtc.column_name) translation