ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B2998B7D582438F7E0530100007F1BBB RWB Report Name Y select rr.report_name value, rr.description from xxfo.rx_reports rr order by rr.report_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B299E522DE345645E0530100007FDE9F 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 Y US RWB Report Columns Polaris Reporting Workbench report columns RWB 1=1 1 10 1=1 rr.report_name=:report_name LOV RWB Report Name B2998B7D582438F7E0530100007F1BBB Y select rr.report_name value, rr.description from xxfo.rx_reports rr order by rr.report_name F Nom du rapport US Report Name 2 20 1=1 rrc.enabled_flag='Y' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Activé uniquement US Enabled only Numeric or value error pivot ENGINATICS 10 AGGREGATOR 19 CALCULATION_COLUMN 20 COLUMN_DATA_TYPE 13 COLUMN_FORMAT 6 COLUMN_LABEL 7 DATA_OBJECT 9 DB_COLUMN_NAME 8 DB_VIEW 12 DIRECTION 4 DISTINCT_FLAG 21 ENABLED_FLAG 2 FOLDERS 22 LOOKUP_FUNCTION 3 OWNER 17 PIVOT_COLUMN_ORDER 16 PIVOT_DISPLAY_NAME 14 PIVOT_FIELD 15 PIVOT_FUNCTION 18 PIVOT_SUMMARY 25 REPORT_COLUMN_ID 23 REPORT_ID 1 REPORT_NAME 5 SEQUENCE_NUMBER 11 SORT_ORDER 26 VIEW_COLUMN_ID 24 VIEW_ID COLUMN_FORMAT ROW 1 REPORT_NAME VALUE 1 COUNT S Site Numeric or value error pivot