<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 Default Values -->
 <REPORTS_ROW>
  <GUID>732E76C96EEE06C6E0530100007F8F69</GUID>
  <SQL_TEXT>select
xrpv.report_name,
xrpv.category,
nvl2(xrpdv.user_id,&apos;User&apos;,&apos;Template&apos;) type,
xxen_util.user_name(xrpdv.user_id) user_name,
xrtv.template_name,
xrpv.display_sequence,
xrpv.parameter_name,
xrpv.anchor,
xrpv.sql_text,
xrpdv.default_value,
xxen_util.user_name(xrpdv.created_by) created_by,
xxen_util.client_time(xrpdv.creation_date) creation_date,
xxen_util.user_name(xrpdv.last_updated_by) last_updated_by,
xxen_util.client_time(xrpdv.last_update_date) last_update_date
from
xxen_report_parameters_v xrpv,
xxen_report_param_default_vals xrpdv,
xxen_report_templates_v xrtv
where
1=1 and
xrpv.parameter_id=xrpdv.parameter_id and
xrpdv.template_id=xrtv.template_id(+)
order by
user_name,
xrpv.report_name,
xrpv.display_sequence</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>القيم الافتراضية للمعلمات الخاصة بالمستخدم في Blitz Report</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Standardwerte der benutzerspezifischen Parameter von Blitz Report</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Valores por defecto de los parámetros específicos del Informe Blitz</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Valeurs par défaut des paramètres spécifiques à l&apos;utilisateur du rapport Blitz</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Valori predefiniti dei parametri specifici dell&apos;utente di Blitz Report</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>電撃レポートのユーザー固有パラメータのデフォルト値</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Blitz Report의 사용자 별 매개 변수 기본값</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Os valores padrão dos parâmetros específicos do usuário do Blitz Report</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Значения по умолчанию параметров, специфичных для пользователя блиц-отчета</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Blitz Rapports användarspecifika standardvärden</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Blitz Raporunun kullanıcıya özel parametre varsayılan değerleri</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Blitz Report&apos;s user or template specific parameter default values</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>Blitz Report Parameter Default Values</REPORT_NAME>
    <DESCRIPTION>Blitz Report的用户特定参数默认值。</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_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>15</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrpv.anchor=:anchor</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select distinct
xrpv.anchor value,
null description
from
xxen_report_parameters_v xrpv
where
(:$flex$.category is null or xrpv.category like &apos;%&apos;||:$flex$.category||&apos;%&apos;) and
xrpv.parameter_id in (select xrpdv.parameter_id from xxen_report_param_default_vals xrpdv)
order by
xrpv.anchor</LOV_QUERY_DSP>
    <DEFAULT_VALUE>&amp;template_having_clause</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Anchor</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>xrpv.report_name=:report_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
xrv.report_name value,
xrv.type_dsp||nvl2(xrv.type,&apos; &apos;,null)||nvl2(xrv.category,&apos;(&apos;||xrv.category||&apos;) &apos;,null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,&apos; &apos;,null)||nvl2(xrv.category,&apos;(&apos;||xrv.category||&apos;) &apos;,null))) description
from
xxen_reports_v xrv
where
xrv.report_id in (select xrp.report_id from xxen_report_parameters xrp where xrp.parameter_id in (select xrpdv.parameter_id from xxen_report_param_default_vals xrpdv))
order by
xrv.report_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Report Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <PARAMETER_DEPENDENCIES>
   <PARAMETER_DEPENDENCIES_ROW>
    <FLEX_BIND>:$flex$.category</FLEX_BIND>
    <PARAMETER_NAME>Category</PARAMETER_NAME>
    <DEPENDENT_PARAMETER_NAME>Anchor</DEPENDENT_PARAMETER_NAME>
   </PARAMETER_DEPENDENCIES_ROW>
  </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>
