ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA879D2E0530100007F1FF2 Blitz Report Name Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name US 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US A527D302F11D36CFE0530100007F7335 select x.* from ( select xrpv1.report_name report_name1, xrpv2.report_name report_name2, xrpv1.display_sequence display_sequence1, xrpv2.display_sequence display_sequence2, xrpv1.parameter_name parameter_name1, xrpv2.parameter_name parameter_name2, xrpv1.anchor anchor1, xrpv2.anchor anchor2, xrpv1.sql_text sql_text1, xrpv2.sql_text sql_text2, case when nvl(dbms_lob.substr(xrpv1.sql_text,32767,1),'x')<>nvl(dbms_lob.substr(xrpv2.sql_text,32767,1),'x') then 'different' end sql_text_check, xrpv1.parameter_type_dsp parameter_type1, xrpv2.parameter_type_dsp parameter_type2, case when nvl(xrpv1.parameter_type,'x')<>nvl(xrpv2.parameter_type,'x') then 'different' end parameter_type_check, xrpv1.lov_name lov_name1, xrpv2.lov_name lov_name2, case when nvl(xrpv1.lov_name,'x')<>nvl(xrpv2.lov_name,'x') then 'different' end lov_name_check, xrpv1.lov_query lov_query1, xrpv2.lov_query lov_query2, case when nvl(dbms_lob.substr(xrpv1.lov_query,32767,1),'x')<>nvl(dbms_lob.substr(xrpv2.lov_query,32767,1),'x') then 'different' end lov_query_check, xrpv1.matching_value matching_value1, xrpv2.matching_value matching_value2, case when nvl(xrpv1.matching_value,'x')<>nvl(xrpv2.matching_value,'x') then 'different' end matching_value_check, xrpv1.default_value default_value1, xrpv2.default_value default_value2, case when nvl(xrpv1.default_value,'x')<>nvl(xrpv2.default_value,'x') then 'different' end default_value_check, xrpv1.description description1, xrpv2.description description2, case when nvl(xrpv1.description,'x')<>nvl(xrpv2.description,'x') then 'different' end description_check, xrpv1.required required1, xrpv2.required required2, case when nvl(xrpv1.required,'x')<>nvl(xrpv2.required,'x') then 'different' end required_check from (select xrpv.* from xxen_report_parameters_v xrpv where xrpv.report_name=:report_name1) xrpv1 full join (select xrpv.* from xxen_report_parameters_v xrpv where xrpv.report_name=:report_name2) xrpv2 on ( xrpv1.parameter_name=xrpv2.parameter_name and xrpv1.anchor=xrpv2.anchor and nvl(xrpv1.matching_value,'x')=nvl(xrpv2.matching_value,'x') ) ) x where 1=1 Y AR Compare Blitz Report Parameters يقارن بارامترات تقريرين للاختلافات D Compare Blitz Report Parameters Vergleicht die Parameter von zwei Reports auf Unterschiede E Compare Blitz Report Parameters Compara los parámetros de dos informes en busca de diferencias F Compare Blitz Report Parameters Comparer les paramètres de deux rapports pour déceler les différences I Compare Blitz Report Parameters Confronta i parametri di due rapporti per le differenze JA Compare Blitz Report Parameters 2つのレポートのパラメタを比較して、その差を比較します。 KO Compare Blitz Report Parameters 두 보고서의 매개 변수를 비교하여 차이점을 찾습니다. PTB Compare Blitz Report Parameters Compara os paramaters de dois relatórios por diferenças RU Compare Blitz Report Parameters Сравнивает параматеры двух отчетов для расхождений S Compare Blitz Report Parameters Jämför parametrarna i två rapporter för skillnader TR Compare Blitz Report Parameters Farklılıklar için iki raporun parametrelerini karşılaştırır US Blitz Report Parameter Comparison between reports Compares the paramaters of two reports for differences ZHS Compare Blitz Report Parameters 比较两份报告的参数差异。 Enginatics 1=1 :report_name1 :report_name2 1 10 :report_name1 LOV Blitz Report Name 8E2FF36EDEA879D2E0530100007F1FF2 Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name Y US Report Name1 2 20 :report_name2 LOV Blitz Report Name 8E2FF36EDEA879D2E0530100007F1FF2 Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where nvl(xrv.type,'x')<>'S' and (fnd_profile.value('XXEN_REPORT_ACCESS')='S' or nvl(xrv.type,'x')<>'U') order by xrv.report_name Y US Report Name2 3 30 1=1 ( x.parameter_type_check is not null or x.lov_name_check is not null or x.lov_query_check is not null or x.matching_value_check is not null or x.default_value_check is not null or x.description_check is not null or x.required_check is not null ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Afficher uniquement les différences US Show Differences only