Blitz Report Parameter Default Values

Description
Categories: Enginatics
Repository: Github
Blitz Report's user or template specific parameter default values

Download Blitz Report™ – World’s fastest reporting and data upload for Oracle EBS

Contact us to schedule a demo or if you need help with the installation

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
)
LOV
Report Name
xrpv.report_name=:report_name
LOV