Blitz Report Parameter Default Values

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Blitz Report's user or template specific parameter default values
select
xrpv.report_name,
xrpv.category,
nvl2(xrpdv.user_id,'User','Template') type,
xxen_util.user_name(xrpdv.user_id) user_name,
xrtv.template_name,
xrpv.display_sequence,
xrpv.parameter_name,
xrpv.anchor,
xrpv.sql_text,
xrpdv.default_value,
xxen_util.user_name(xrpdv.created_by) created_by,
xxen_util.client_time(xrpdv.creation_date) creation_date,
xxen_util.user_name(xrpdv.last_updated_by) last_updated_by,
xxen_util.client_time(xrpdv.last_update_date) last_update_date
from
xxen_report_parameters_v xrpv,
xxen_report_param_default_vals xrpdv,
xxen_report_templates_v xrtv
where
1=1 and
xrpv.parameter_id=xrpdv.parameter_id and
xrpdv.template_id=xrtv.template_id(+)
order by
user_name,
xrpv.report_name,
xrpv.display_sequence
Parameter NameSQL textValidation
Category
xrpv.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
Anchor
xrpv.anchor=:anchor
LOV
Report Name
xrpv.report_name=:report_name
LOV
Download
Related Blitz Reports
DIS End User Layers Blitz Report Assignments AP Supplier Upload Blitz Report Default Templates Blitz Report Templates Blitz Reports Blitz Report Parameter Dependencies ORB Report Parameters Blitz Report History
Blitz Report™