Blitz Report Parameter Dependencies

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Run Blitz Report Parameter Dependencies and other Oracle EBS reports with Blitz Report™ on our demo environment
select
xrpv1.report_name,
xrpv1.category,
xrpv1.parameter_name,
xrpv2.parameter_name dependent_parameter_name,
xrpd.flex_bind,
xrpv1.display_sequence,
xrpv2.display_sequence dependent_display_sequence,
xxen_util.user_name(xrpd.created_by) created_by,
xxen_util.client_time(xrpd.creation_date) creation_date,
xxen_util.user_name(xrpd.last_updated_by) last_updated_by,
xxen_util.client_time(xrpd.last_update_date) last_update_date,
xrpd.report_id,
xrpd.parameter_id,
xrpd.dependent_parameter_id
from
xxen_report_param_dependencies xrpd,
xxen_report_parameters_v xrpv1,
xxen_report_parameters_v xrpv2
where
1=1 and
xrpd.parameter_id=xrpv1.parameter_id and
xrpd.dependent_parameter_id=xrpv2.parameter_id
Parameter Name SQL text Validation
Report Name 
xrpv1.report_name=:report_name
 LOV
Parameter Name 
xrpv1.parameter_name=:parameter_name
 LOV
Dependent Parameter Name 
xrpv2.parameter_name=:dependent_parameter_name
 LOV
Download
Related Blitz Reports
Blitz Report Parameter Table Alias Validation Blitz Report Execution History Blitz Report Parameter Default Values Blitz Report Assignments Blitz Report Text Search MRP Item Forecast Upload BOM Bill of Materials Upload PA Project Event Upload Blitz Report Parameter Comparison between reports
Blitz Report™

Blitz Report™ provides multiple benefits: