<ROOT>
 <APPS_INITIALIZE_DATA>
  <USER_NAME>ENGINATICS</USER_NAME>
  <RESPONSIBILITY_KEY>SYSTEM_ADMINISTRATOR</RESPONSIBILITY_KEY>
  <APPLICATION_SHORT_NAME>SYSADMIN</APPLICATION_SHORT_NAME>
 </APPS_INITIALIZE_DATA>
<LOVS>
<!-- loader xml for Enginatics Blitz Report lov: Blitz Report Category -->
 <LOVS_ROW>
  <GUID>8E2FF36EDEFA79D2E0530100007F1FF2</GUID>
  <LOV_NAME>Blitz Report Category</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>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</LOV_QUERY>
  <LOV_TRANSLATIONS>
   <LOV_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
   </LOV_TRANSLATIONS_ROW>
  </LOV_TRANSLATIONS>
 </LOVS_ROW>
</LOVS>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: Blitz Report Parameter Custom LOV Duplication Validation -->
 <REPORTS_ROW>
  <GUID>B17EB934E9B47246E0530100007FA5B8</GUID>
  <SQL_TEXT>select
x.*
from
(
select
count(*) over (partition by dbms_lob.substr(xrpv.lov_query_dsp,4000,1)) dupl_count,
count(nvl2(xrpv.lov_id,null,1)) over (partition by dbms_lob.substr(xrpv.lov_query_dsp,4000,1)) custom_count,
xrpv.report_name,
xrpv.category,
xrpv.display_sequence,
xrpv.parameter_name,
xrpv.parameter_type_dsp,
xrpv.lov_name,
dbms_lob.substr(xrpv.lov_query_dsp,4000,1) lov_query_dsp 
from
xxen_report_parameters_v xrpv
where
1=1 and
xrpv.parameter_type=&apos;LOV&apos;
) x
where
x.dupl_count&gt;1 and
x.custom_count&gt;0
order by
x.dupl_count desc,
x.lov_query_dsp</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>معلمات تقرير Blitz باستخدام LOVs المخصصة مع نفس الاستعلام أكثر من مرة حتى يتم إعدادها على أنها قائمة LOV مشتركة بدلاً من ذلك</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Blitz-Berichtsparameter, die benutzerdefinierte LOVs mit der gleichen Abfrage mehr als einmal verwenden, so dass sie stattdessen als gemeinsamer LOV eingerichtet werden sollten</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Parámetros del informe de Blitz utilizando LOVs personalizados con la misma consulta más de una vez para que se configuren como un LOV compartido en su lugar</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Paramètres des rapports Blitz utilisant des LOV personnalisés avec la même requête plus d&apos;une fois, de sorte qu&apos;ils devraient plutôt être définis comme LOV partagé</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Blittare i parametri dei rapporti usando LOV personalizzati con la stessa query più di una volta in modo che siano invece impostati come LOV condivisi</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>カスタムLOVを使用して、同じクエリを複数回使用してブリッツレポートのパラメータを作成し、共有LOVとして設定するようにしました。</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>동일한 쿼리가있는 사용자 정의 LOV를 두 번 이상 사용하는 Blitz 보고서 매개 변수를 대신 공유 LOV로 설정해야합니다.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Parâmetros de relatório Blitz usando LOVs personalizados com a mesma consulta mais de uma vez, de modo que eles devem ser configurados como um LOV compartilhado em vez</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Параметры блиц-отчета, использующие пользовательские LOV с одним и тем же запросом более одного раза, чтобы их можно было настроить в качестве общего LOV вместо этого</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Blitz-rapportparametrar med anpassade LOV med samma fråga mer än en gång så att de bör ställas in som en delad LOV istället</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>Aynı sorguya sahip özel DL&apos;leri kullanan Blitz raporu parametreleri, bunun yerine paylaşılan bir DL olarak ayarlanmaları gerekir</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Duplication Validation</REPORT_NAME>
    <DESCRIPTION>Blitz report parameters using custom LOVs with the same query more than once so that they should be set up as a shared LOV instead</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Custom LOV Validation</REPORT_NAME>
    <DESCRIPTION>使用自定义LOV的突击报表参数与相同的查询超过一次，因此它们应该被设置为共享LOV，而不是。</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>Enginatics</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>1=1</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>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
)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Blitz Report Category</LOV_NAME>
    <LOV_GUID>8E2FF36EDEFA79D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>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</LOV_QUERY_DSP>
    <DEFAULT_VALUE>Discoverer</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Category</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
  </PARAMETER_DEPENDENCIES>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
  <UPLOAD_DEPENDENCIES>
  </UPLOAD_DEPENDENCIES>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
