select
era.application_name application,
errc.category_name category,
err.report_name,
err.report_id "EIS Report ID",
err.view_name,
xxen_util.yes(err.seeded_flag) seeded,
errco.display_order,
errco.display_name,
errco.column_name,
xxen_util.yes(errco.derived_flag) derived,
errco.calculation_column calculation,
xxen_util.yes(case when regexp_like(errco.calculation_column,'xxeis\.','i') then 'Y' end) "XXEIS Reference",
errco.data_type,
ervc.data_type view_column_data_type,
errco.data_format format,
decode(err.group_by_flag,'Y',errco.group_function) group_function,
xxen_util.yes(nvl(errco.enabled_flag,'Y')) enabled,
xxen_util.yes(errco.display_flag) displayed,
ervc_comp.component_name component,
ervc_comp.alias_name component_alias
from
xxeis.eis_rs_reports err,
xxeis.eis_rs_applications era,
xxeis.eis_rs_report_categories errc,
xxeis.eis_rs_report_columns errco,
xxeis.eis_rs_view_columns ervc,
xxeis.eis_rs_view_components ervc_comp
where
1=1 and
err.application_id=era.application_id and
err.category_id=errc.category_id(+) and
err.report_id=errco.report_id and
errco.view_column_id=ervc.view_column_id(+) and
errco.view_component_id=ervc_comp.view_component_id(+)
order by
era.application_name,
errc.category_name,
err.report_name,
errco.display_order,
errco.column_id |
