ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEFA79D2E0530100007F1FF2 Blitz Report Category Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B5B5F37B7791013CE0530100007FCD38 select x.* from ( select case when xrpv.dupl_matching_value>1 then 'Duplicate matching value' when xrpv.dupl_parameter_name>1 then 'Duplicate parameter name' when xrpv.dupl_bind_anchor>1 then 'Duplicate bind anchor' when xrpv.dupl_parameter>1 then 'Duplicated parameter sql text with the same anchor' end problem, xrpv.* from ( select xrpv.report_name, xrpv.category, xrpv.display_sequence, xrpv.parameter_name, xrpv.anchor, xrpv.sql_text, xrpv.parameter_type_dsp type, xrpv.matching_value, xrpv.sort_order, count(nvl2(xrpv.matching_value,xrpv.parameter_id,null)) over (partition by xrpv.report_id, xrpv.parameter_name, xrpv.anchor, xrpv.matching_value) dupl_matching_value, count(nvl2(xrpv.display_sequence,xrpv.parameter_id,null)) over (partition by xrpv.report_id, xrpv.parameter_name) dupl_parameter_name, count(case when xrpv.anchor like ':%' then xrpv.parameter_id end) over (partition by xrpv.report_id, xrpv.anchor) dupl_bind_anchor, count(*) over (partition by xrpv.report_id, xrpv.parameter_name, xrpv.anchor, xrpv.matching_value) dupl_parameter, xrpv.report_id, xrpv.parameter_id from xxen_report_parameters_v xrpv where 1=1 ) xrpv ) x where 2=2 order by x.report_name, x.sort_order Y AR Blitz Report Parameter Uniqueness Validation يتحقق من وجود أي معلمات تقرير خاطفة مكررة D Blitz Report Parameter Uniqueness Validation Überprüft, ob es doppelte Blitzberichtsparameter gibt E Blitz Report Parameter Uniqueness Validation Valida si hay algún parámetro de informe de bombardeo duplicado F Blitz Report Parameter Uniqueness Validation Valide s'il y a des paramètres de rapport de blitz en double I Blitz Report Parameter Uniqueness Validation Valida se ci sono parametri di rapporto blitz duplicati JA Blitz Report Parameter Uniqueness Validation 電撃レポートのパラメータが重複しているかどうかを検証します。 KO Blitz Report Parameter Uniqueness Validation 중복 된 블리츠 보고서 매개 변수가 있는지 확인합니다. PTB Blitz Report Parameter Uniqueness Validation Valida se houver parâmetros duplicados de relatório de blitz RU Blitz Report Parameter Uniqueness Validation Проверяет, есть ли дубликаты параметров отчета о блице. S Blitz Report Parameter Uniqueness Validation Validerar om det finns dubbletter av blitz-rapportparametrar TR Blitz Report Parameter Uniqueness Validation Yinelenen yıldırım raporu parametreleri olup olmadığını doğrular US Blitz Report Parameter Uniqueness Validation Validates if there are any duplicate blitz report parameters ZHS Blitz Report Parameter Uniqueness Validation 验证是否有重复的突击报告参数。 Enginatics 1=1 2=2 1 10 1=1 xrpv.report_id in ( select xrca.report_id from xxen_report_category_assigns xrca, xxen_report_categories_v xrcv where xrcv.category=:category and xrcv.category_id=xrca.category_id ) LOV Blitz Report Category 8E2FF36EDEFA79D2E0530100007F1FF2 Y select xrcv.category value, (select count(*) from xxen_report_category_assigns xrca where xrcv.category_id=xrca.category_id) description from xxen_report_categories_v xrcv order by xrcv.category Discoverer US Category 2 20 2=2 x.problem is not null LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y US Show Duplicates only