Blitz Report Parameter Dependencies

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
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 NameSQL textValidation
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 Upload Dependencies Blitz Report Parameter Default Values ORB Report Parameters Blitz Report History Blitz Report Assignment Upload Blitz Report Assignments CAC AP Accrual IR ISO Match Analysis CAC WIP Account Value
Blitz Report™