select
rr.report_name,
(
select distinct
listagg(rf.folder_name,'; ') within group (order by rf.folder_name) over (partition by rfa.report_id) folders
from
rx_folder_association rfa,
rx_folders rf
where
rr.report_id=rfa.report_id and
rfa.folder_id=rf.folder_id
) folders,
xxen_util.user_name(rr.owner_person_id) owner,
decode(rr.distinct_flag,'Y','Y') distinct_flag,
rrc.sequence_number,
rrc.column_label,
rv.view_alias data_object,
rv.db_view_name db_view,
rvc.column_name db_column_name,
rrc.aggregator,
rs.sort_order,
rs.asc_or_dsc direction,
rrc.column_format,
rrc.pivot_field,
rrc.pivot_datatype pivot_function,
rrc.pivot_alias_name pivot_display_name,
nvl2(rrc.pivot_field,rrc.pivot_column_order,null) pivot_column_order,
decode(rrc.pivot_summary,'Y','Y') pivot_summary,
rrc.calculation_column,
rvc.column_data_type,
decode(rrc.enabled_flag,'Y','Y') enabled_flag,
rvc.lookup_function,
rrc.report_id,
rvc.view_id,
rrc.report_column_id,
rvc.view_column_id
from
rx_reports rr,
rx_report_columns rrc,
rx_view_columns rvc,
rx_views rv,
rx_sorts rs
where
1=1 and
rr.report_id=rrc.report_id and
rrc.view_column_id=rvc.view_column_id(+) and
rvc.view_id=rv.view_id(+) and
rrc.report_id=rs.report_id(+) and
rrc.view_column_id=rs.view_column_id(+)
order by
rr.report_name,
rrc.sequence_number |
