<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>
<REPORTS>
<!-- loader xml for Enginatics Blitz Report: GL Chart of Accounts - Segment Values Listing -->
 <REPORTS_ROW>
  <GUID>C6E085D4727451A9E05362FB09050512</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select
        vi.flex_value                                    isval,
        vit.description                                   isdsc,
        vd.flex_value                                    dsval,
        vdt.description                                   dsdsc,
        vd.start_date_active                             sdate,
        vd.end_date_active                               edate,
        l1.meaning                                       eflag,
        l3.meaning                                       pflag,
        l4.meaning                                       bflag,
        l5.description                                atype
from
        fnd_flex_values                 vi,
        fnd_flex_values_tl             vit,
        fnd_flex_values                 vd,
        fnd_flex_values_tl             vdt,
       gl_lookups                      l1,
        gl_lookups                      l3,
        gl_lookups                      l4,
        gl_lookups                      l5
where
        vi.flex_value_set_id = :PVSETID
    and vit.flex_value_id = vi.flex_value_id + 0
    and vit.language = userenv(&apos;LANG&apos;)
    and vd.flex_value_set_id = :VSETID
    and vd.parent_flex_value_low = vi.flex_value
    and vd.enabled_flag = l1.lookup_code
    and vdt.flex_value_id = vd.flex_value_id + 0
    and vdt.language = userenv(&apos;LANG&apos;)
   and l1.lookup_type = &apos;YES/NO&apos;
    and substrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline,
                          instrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline
                                      ,fnd_global.newline, 1, :POST_POSITION
                                    ) +1, 1 ) = l3.lookup_code
    and l3.lookup_type = &apos;YES/NO&apos;
    and substrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline,
                          instrb ( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline,
                                       fnd_global.newline,1, :BUDGET_POSITION
                                    )+1, 1 ) = l4.lookup_code
    and l4.lookup_type = &apos;YES/NO&apos;
    and nvl(substrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline,
                                 instrb( fnd_global.newline||vd.compiled_value_attributes||fnd_global.newline,
                                            fnd_global.newline, 1, :POSITION 
                                           ) +1, 1
                              ),&apos;A&apos;) = l5.lookup_code(+)
    and l5.lookup_type(+) = &apos;ACCOUNT TYPE&apos;
order by
        vi.flex_value,
        vd.flex_value
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>SQLGL</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>GLXRLSEG_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>GL جدول تصنيف الحسابات - قائمة قيم المقاطع (بتنسيق XML)</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: تقارير قيم المقاطع بواسطة المقطع
Application: الأستاذ العام
Source: جدول تصنيف الحسابات - قائمة قيم المقاطع (بتنسيق XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>GL Kontenplan - Segmentwert-Liste</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Wertet Segmentwerte nach Segment aus.
Application: Rechnungswesen
Source: Kontenplan - Segmentwert-Liste (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>GL Plan de Cuentas - Listado de Valores de Segmentos</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Informa sobre los valores de segmentos por segmento.
Application: General Ledger
Source: Plan de Cuentas - Listado de Valores de Segmentos (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>GL Plan de comptes - Liste valeurs de segments</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Valeurs de segments par segment
Application: General Ledger
Source: Plan de comptes - Liste valeurs de segments (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>GL Piano dei conti - Elenco valori segmento</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Rapporti sui valori segmento per segmento
Application: General Ledger
Source: Piano dei conti - Elenco valori segmento (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>GL 勘定体系 - セグメント値リスト</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: セグメント別セグメント値レポート。
Application: General Ledger
Source: 勘定体系 - セグメント値リスト (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>GL 계정 코드집 - 세그먼트값 목록</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 세그먼트별 세그먼트 값에 대한 보고서.
Application: General Ledger
Source: 계정 코드집 - 세그먼트값 목록(XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>GL Plano de Contas - Lista de Valores do Segmento</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Relatórios sobre valores de segmento por segmento.
Application: General Ledger
Source: Plano de Contas - Lista de Valores do Segmento (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>GL План счетов - список значений сегмента</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Отчет о значениях сегментов по сегментам.
Application: Главная книга
Source: План счетов - список значений сегмента  (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>GL Kontoplan - Lista över segmentvärden</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Rapporter om segmentvärden efter segment.
Application: General Ledger
Source: Kontoplan - Lista över segmentvärden (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>GL Hesap Planı - Segment Değerleri Listesi</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Segment bazında segment değerleri raporlar.
Application: Genel Muhasebe
Source: Hesap Planı - Segment Değerleri Listesi (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>GL Chart of Accounts - Segment Values Listing</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: Reports on segment values by segment.
Application: General Ledger
Source: Chart of Accounts - Segment Values Listing (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>GL 科目表 - 段值列表</REPORT_NAME>
    <DESCRIPTION>Imported from BI Publisher
Description: 按段报告段值
Application: 总帐管理系统
Source: 科目表 - 段值列表 (XML)
Short Name: GLXRLSEG_XML
DB package: GL_GLXRLSEG_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
  </REPORT_TRANSLATIONS>
  <CATEGORY_ASSIGNMENTS>
   <CATEGORY_ASSIGNMENTS_ROW>
    <CATEGORY>BI Publisher</CATEGORY>
   </CATEGORY_ASSIGNMENTS_ROW>
  </CATEGORY_ASSIGNMENTS>
  <ANCHORS>
   <ANCHORS_ROW>
    <ANCHOR>:aprintswitch</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:aprompt</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:budget_position</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:coa_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_segment_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_struct_num</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:paprompt</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:position</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:post_position</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:pvsetid</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:segment_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:vsetid</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>-20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_struct_num</ANCHOR>
    <PARAMETER_TYPE_DSP>Number</PARAMETER_TYPE_DSP>
    <DEFAULT_VALUE>SELECT chart_of_accounts_id FROM gl_access_sets WHERE access_set_id = fnd_profile.value(&apos;GL_ACCESS_SET_ID&apos;)</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>معرف جدول تصنيف الحسابات</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Kontenplankennung</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Id Plan de Cuentas</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>ID plan de comptes</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Id piano dei conti</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>勘定体系ID</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>계정 코드집 ID</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Id do Plano de Contas</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Идент. плана счетов</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Kontoplans-id</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Hesap Planı No</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>Chart of Accounts Id</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>GL_SRS_COA_UNVALIDATED</PARAMETER_NAME>
      <DESCRIPTION>科目表标识</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_segment_name</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>GL_SRS_SEGMENT_NAME</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
segment_name id,
segment_name value,
description description
from
fnd_id_flex_segments_vl
where id_flex_code=&apos;GL#&apos;
and id_flex_num=:$flex$.gl_srs_coa_unvalidated
and enabled_flag=&apos;Y&apos;
order by value,description</LOV_QUERY_DSP>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>اسم المقطع</PARAMETER_NAME>
      <DESCRIPTION>اسم المقطع</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Segmentbezeichnung</PARAMETER_NAME>
      <DESCRIPTION>Segmentbezeichnung</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>E</LANGUAGE>
      <PARAMETER_NAME>Nombre de Segmento</PARAMETER_NAME>
      <DESCRIPTION>Nombre de Segmento</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom de segment</PARAMETER_NAME>
      <DESCRIPTION>Nom de segment</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>I</LANGUAGE>
      <PARAMETER_NAME>Nome segmento</PARAMETER_NAME>
      <DESCRIPTION>Nome segmento</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>JA</LANGUAGE>
      <PARAMETER_NAME>セグメント名</PARAMETER_NAME>
      <DESCRIPTION>セグメント名</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>KO</LANGUAGE>
      <PARAMETER_NAME>세그먼트명</PARAMETER_NAME>
      <DESCRIPTION>세그먼트명</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>PTB</LANGUAGE>
      <PARAMETER_NAME>Nome do Segmento</PARAMETER_NAME>
      <DESCRIPTION>Nome do Segmento</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>RU</LANGUAGE>
      <PARAMETER_NAME>Имя сегмента</PARAMETER_NAME>
      <DESCRIPTION>Имя сегмента</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>S</LANGUAGE>
      <PARAMETER_NAME>Segmentnamn</PARAMETER_NAME>
      <DESCRIPTION>Segmentnamn</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>TR</LANGUAGE>
      <PARAMETER_NAME>Segment Adı</PARAMETER_NAME>
      <DESCRIPTION>Segment Adı</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Segment Name</PARAMETER_NAME>
      <DESCRIPTION>Segment Name</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>段名</PARAMETER_NAME>
      <DESCRIPTION>段名</DESCRIPTION>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
  </PARAMETERS>
  <TEMPLATES>
  </TEMPLATES>
  <DEFAULT_TEMPLATES>
  </DEFAULT_TEMPLATES>
  <UPLOAD_COLUMNS>
  </UPLOAD_COLUMNS>
  <UPLOAD_PARAMETERS>
  </UPLOAD_PARAMETERS>
  <UPLOAD_SQLS>
  </UPLOAD_SQLS>
 </REPORTS_ROW>
</REPORTS>
</ROOT>
