ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 15061A7DE695A4F3E0630100007FE24D select x.* from ( select max(case when length(xrt.report_name)<>lengthb(xrt.report_name) or length(xrt.description)<>lengthb(xrt.description) or length(xrt.required_parameters_message)<>lengthb(xrt.required_parameters_message) then 'Y' end) over (partition by xrt.report_id) has_multibyte, xrt.source_lang, max(decode(xrt.language,'US',xrt.report_name)) over (partition by xrt.report_id) report_name_us, xrt.report_name, xrt.description, max(decode(xrt.language,'US',xrt.description)) over (partition by xrt.report_id) description_us, xrt.required_parameters_message, max(decode(xrt.language,'US',xrt.required_parameters_message)) over (partition by xrt.report_id) required_parameters_message_us, xxen_util.user_name(xrt.created_by) created_by, xxen_util.client_time(xrt.creation_date) creation_date, xxen_util.user_name(xrt.last_updated_by) last_updated_by, xxen_util.client_time(xrt.last_update_date) last_update_date from xxen_reports_tl xrt ) x where 1=1 order by x.report_name_us, x.source_lang Y US Blitz Report Translations Enginatics 1=1 1 10 1=1 x.source_lang<>'US' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Translated Only