Blitz Report Parameter Dependencies

➜ Back to Library
Description
Categories: Enginatics
Repository: Github

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
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
Category 
xrpv1.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
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 CAC Calculate ICP PII Item Costs PA Project Event Upload Blitz Report Parameter Comparison between reports Blitz Report LOV SQL Validation
Blitz Report™

Blitz Report™ provides multiple benefits: