Blitz Report Templates

➜ Back to Library
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
Download
Related Blitz Reports
Blitz Reports GL Data Access Sets XXGF GL Balance by Account Hierarchy GL Balance by Account Hierarchy ONT Transaction Types and Line WF Processes GL Summary Templates XDO Publisher Data Definitions INV Item Templates INV Inventory Items
Blitz Report In Action
Blitz Report™

Blitz Report™ provides multiple benefits: