RWB Report Columns

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

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