<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: Yes -->
 <LOVS_ROW>
  <GUID>8E2FF36EDEA679D2E0530100007F1FF2</GUID>
  <LOV_NAME>Yes</LOV_NAME>
  <VALIDATE_FROM_LIST>Y</VALIDATE_FROM_LIST>
  <LOV_QUERY>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</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: DBA Table Columns -->
 <REPORTS_ROW>
  <GUID>AC0D41A18E4F10E7E0530100007FA23E</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
dtc.owner,
dtc.table_name,
dtc.column_name,
dtc.data_type||case when dtc.data_type like &apos;%CHAR%&apos; then &apos; (&apos;||dtc.data_length||&apos;)&apos; end data_type,
decode(dtc.nullable,&apos;N&apos;,xxen_util.meaning(dtc.nullable,&apos;YES_NO&apos;,0)) nullable,
dtc.column_id
from
dba_tab_columns dtc
where
1=1
order by
dtc.owner,
dtc.table_name,
dtc.column_id</SQL_TEXT>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>تقرير بجميع أسماء أعمدة الجدول استنادًا إلى dba_tab_columns ، حيث أن العثور على الجداول حسب أسماء الأعمدة مهمة متكررة أثناء تطوير SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Report mit allen Tabellenspaltennamen basierend auf dba_tab_columns, da das Suchen von Tabellen anhand von Spaltennamen eine häufige Aufgabe bei der SQL-Entwicklung ist</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Informe con todos los nombres de las columnas de las tablas basado en dba_tab_columns, ya que encontrar tablas por nombres de columnas es una tarea frecuente durante el desarrollo de SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Rapport avec tous les noms de colonnes des tables basé sur dba_tab_columns, car la recherche de tables par noms de colonnes est une tâche fréquente lors du développement SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Report con tutti i nomi delle colonne delle tabelle basati su dba_tab_columns, poiché trovare le tabelle in base ai nomi delle colonne è un compito frequente durante lo sviluppo SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>SQL開発時にカラム名からテーブルを検索する作業が頻繁に発生するため、dba_tab_columnsをベースに全テーブルのカラム名でレポートを作成する</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>SQL 개발 중에 열 이름으로 테이블을 찾는 것이 빈번한 작업이므로 dba_tab_columns를 기반으로 모든 테이블 열 이름으로보고합니다.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Relatório com todos os nomes de colunas de tabelas com base nas colunas dba_tab_columns, pois encontrar tabelas por nomes de colunas é uma tarefa frequente durante o desenvolvimento de SQL</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Отчет с именами всех столбцов таблицы на основе dba_tab_columns, так как поиск таблиц по именам столбцов является частой задачей при разработке SQL.</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Rapportera med alla tabellkolumnamn baserat på dba_tab_column, eftersom det är en vanlig uppgift att hitta tabeller efter kolumnnamn under SQL-utveckling</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Dba_tab_columns&apos;a göre tüm tablo sütun adlarını içeren raporlar, çünkü tabloları sütun adlarına göre bulmak, SQL geliştirme sırasında sık karşılaşılan bir görevdir</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>Report with all table column names based on dba_tab_columns, as finding tables by column names is a frequent task during SQL development</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>DBA Table Columns</REPORT_NAME>
    <DESCRIPTION>基于dba_tab_columns的所有表列名的报表，因为在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>lower(dtc.column_name) like &apos;%&apos;||lower(:column_name)||&apos;%&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Le nom de la colonne contient</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Column Name contains</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>lower(dtc.table_name) like lower(:table_name)||&apos;%&apos;</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <LOV_QUERY_DSP>select distinct
dt.table_name value,
dt.owner description
from
dba_tables dt
where
dt.owner in (select fou.oracle_username from fnd_oracle_userid fou) 
order by
dt.table_name
</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Le nom de la table commence par</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Table Name starts with</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>100</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>(dtc.owner, dtc.table_name) in (select dt.owner, dt.table_name from dba_tables dt)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV</PARAMETER_TYPE_DSP>
    <LOV_NAME>Yes</LOV_NAME>
    <LOV_GUID>8E2FF36EDEA679D2E0530100007F1FF2</LOV_GUID>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select &apos;Y&apos; id, xxen_util.meaning(&apos;Y&apos;,&apos;YES_NO&apos;,0) value, null description from dual</LOV_QUERY_DSP>
    <DEFAULT_VALUE>Y</DEFAULT_VALUE>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Exclure les vues</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Exclude Views</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>
