RWB Report Columns
Description
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Report Name |
|
LOV | |
Enabled only |
|
LOV |