<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 Table Alias Validation -->
 <REPORTS_ROW>
  <GUID>A2A318EFBC6048C0E0530100007FA859</GUID>
  <SQL_TEXT>select
x.*
from
(
select
xrpv.report_name,
xrpv.category,
xrpv.display_sequence,
xrpv.parameter_name,
xrpv.anchor,
xrpv.sql_text,
dbms_lob.substr(regexp_substr(xrpv.sql_text,&apos;(\w+)\.\w+.&apos;,1,1,null,1)) table_alias,
dbms_lob.substr(regexp_substr(xrpv.sql_text,&apos;\w+\.\w+(.)&apos;,1,1,null,1)) function_check,
xxen_util.user_name(xrpv.created_by) created_by,
xxen_util.client_time(xrpv.creation_date) creation_date,
xxen_util.user_name(xrpv.last_updated_by) last_updated_by,
xxen_util.client_time(xrpv.last_update_date) last_update_date,
xrpv.report_id,
xrpv.parameter_id
from
xxen_report_parameters_v xrpv
where
1=1 and
xrpv.anchor not like &apos;&amp;%&apos; and
xrpv.report_id in (select xrca.report_id from xxen_report_categories_v xrcv, xxen_report_category_assigns xrca where xrcv.category=&apos;Enginatics&apos; and xrcv.category_id=xrca.category_id) and
(xrpv.display_sequence&gt;0 or xrpv.display_sequence is null) and
xrpv.sql_text is not null
) x
where
x.table_alias not in (&apos;xrrpv&apos;) and
x.function_check&lt;&gt;&apos;(&apos; and
x.table_alias is not null and
not exists (select null from xxen_reports xr where x.report_id=xr.report_id and regexp_like(xr.sql_text,&apos; &apos;||x.table_alias||&apos;\W&apos;,&apos;i&apos;)) and
not exists (select null from xxen_report_parameters_v xrpv2 where x.report_id=xrpv2.report_id and (
x.parameter_name=xrpv2.parameter_name or
xrpv2.parameter_id in (
select
xrplv.parameter_id
from
xxen_report_param_dependencies xrpd,
xxen_report_parameters_link_v xrplv
where
x.parameter_id=xrpd.dependent_parameter_id and
xrpd.parameter_id=xrplv.parameter_id_display
)) and
xrpv2.anchor like &apos;&amp;%&apos; and regexp_like(xrpv2.sql_text,&apos; &apos;||x.table_alias||&apos;\W&apos;,&apos;i&apos;))
order by
x.report_name,
x.display_sequence</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>تشير معلمات تقرير Blitz إلى الأسماء المستعارة للجدول ، والتي لا توجد كجدول في تقرير SQL الرئيسي</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Blitz-Report-Parameter, die Tabellen-Aliase referenzieren, die nicht als Tabelle im Haupt-Report-SQL existieren</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Parámetros del informe Blitz que hacen referencia a los alias de las tablas, que no existen como tabla en el informe principal SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Paramètres du rapport Blitz faisant référence à des alias de table, qui n&apos;existent pas en tant que table dans le rapport principal SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Parametri del rapporto Blitz che fanno riferimento ad alias di tabelle, che non esistono come tabelle nel rapporto principale SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>メインレポートのSQLにテーブルとして存在しないテーブルエイリアスを参照している電撃レポートのパラメータ</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>기본 보고서 SQL에 테이블로 존재하지 않는 테이블 별칭을 참조하는 Blitz 보고서 매개 변수</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Parâmetros de relatório Blitz referentes a aliases de tabela, que não existem como uma tabela no relatório principal SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Параметры блиц-отчета со ссылкой на псевдонимы таблиц, которые не существуют в виде таблицы в основном отчете SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Blitz-rapportparametrar som refererar till tabellalias, som inte finns som en tabell i SQL-huvudrapporten</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Ana rapor SQL&apos;de tablo olarak var olmayan tablo takma adlarına başvuran Blitz raporu parametreleri</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>Blitz report parameters referencing table aliases, which do not exist as a table in the main report SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Table Alias Validation</REPORT_NAME>
    <DESCRIPTION>闪电战报表参数引用表别名，这些表在主报表中不作为表存在，SQL</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>
