Blitz Report Parameter Default Values

Description

Categories: Enginatics, Kcapps
Repository: Github

Blitz Report's user or template specific parameter default values

Blitz Report Parameter Default Values and other Oracle EBS reports with Blitz Report™ on our demo environment

Copy

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,
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 Name

SQL text

Validation

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
)