Blitz Report Parameter Dependencies

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

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