Blitz Report Dynamic Column Rules

Description

Categories
Enginatics
Repository
GitHub

SQL 27 lines

Parameters 4

ParameterTypeList of values SQL
Rule NameLOV
xrdcr.rule_name=:rule_name
Report NameLOV
xrv.report_name=:report_name
CategoryLOV
xrv.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
)
EnabledLOV Oracle
xrdcr.enabled='Y'