Blitz Report Parameter Dependencies

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,
':$flex$.'||xrpd.flex_bind flex_bind,
xrpv1.display_sequence,
xrpv2.display_sequence dependent_display_sequence,
xrpd.created_by,
xrpd.creation_date,
xrpd.last_updated_by,
xrpd.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