Blitz Report Parameter Default Values

➜ Back to Library
Description
Categories: Enginatics, Kcapps
Repository: Github
Blitz Report's user or template specific parameter default values
Run Blitz Report Parameter Default Values and other Oracle EBS reports with Blitz Report™ on our demo environment
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.category=:category
 LOV
Report Name 
xrpv.report_name=:report_name
 LOV
Download
 
Related Blitz Reports
DIS End User Layers Blitz Report Templates Blitz Reports Blitz Report Execution History Blitz Report Parameter Dependencies Blitz Report Text Search Compare Blitz Report Parameters DIS Workbook Import Validation QP Customer Pricing Engine Request
Blitz Report™

Blitz Report™ provides multiple benefits: