<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 - Suspense Accounts Listing -->
 <REPORTS_ROW>
  <GUID>82288223F4EC3869E053B46B63588994</GUID>
  <SQL_TEXT>select
  gjs.user_je_source_name  JOURNAL_ENTRY_SOURCE,
  gjc.user_je_category_name  JOURNAL_ENTRY_CATEGORY,
  null  FLEX_DATA_ALL, 
	fnd_flex_xml_publisher_apis.process_kff_combination_1(&apos;flex_field_all&apos;, &apos;SQLGL&apos;, &apos;GL#&apos;, gcc.CHART_OF_ACCOUNTS_ID, NULL, gcc.CODE_COMBINATION_ID, &apos;ALL&apos;, &apos;Y&apos;, &apos;VALUE&apos;) FLEX_FIELD_ALL
from
  gl_code_combinations  gcc,
  gl_je_categories  gjc,
  gl_je_sources  gjs,
  gl_suspense_accounts  gsa
where
          gsa.ledger_id = :P_LEDGER_ID
  and  gsa.je_source_name = gjs.je_source_name
  and  gsa.je_category_name = gjc.je_category_name
  and  gsa.code_combination_id = gcc.code_combination_id (+)
order by
  gjs.user_je_source_name,
  gjc.user_je_category_name
</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <XDO_APPLICATION_SHORT_NAME>SQLGL</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>GLXRLSUS_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>GL جدول تصنيف الحسابات - قائمة الحسابات المعلقة (بتنسيق XML)</REPORT_NAME>
    <DESCRIPTION>Application: الأستاذ العام
Source: جدول تصنيف الحسابات - قائمة الحسابات المعلقة (بتنسيق XML)
Short Name: GLXRLSUS_XML
DB package: GL_GLXRLSUS_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>GL Kontenplan - Interimskonten-Liste</REPORT_NAME>
    <DESCRIPTION>Application: Rechnungswesen
Source: Kontenplan - Interimskonten-Liste (XML)
Short Name: GLXRLSUS_XML
DB package: GL_GLXRLSUS_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>GL Plan de comptes - Liste des comptes d&apos;attente</REPORT_NAME>
    <DESCRIPTION>Application: General Ledger
Source: Plan de comptes - Liste des comptes d&apos;attente (XML)
Short Name: GLXRLSUS_XML
DB package: GL_GLXRLSUS_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>GL Chart of Accounts - Suspense Accounts Listing</REPORT_NAME>
    <DESCRIPTION>Application: General Ledger
Source: Chart of Accounts - Suspense Accounts Listing (XML)
Short Name: GLXRLSUS_XML
DB package: GL_GLXRLSUS_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>GL 科目表 - 暂记账户列表</REPORT_NAME>
    <DESCRIPTION>Application: 总帐管理系统
Source: 科目表 - 暂记账户列表 (XML)
Short Name: GLXRLSUS_XML
DB package: GL_GLXRLSUS_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>:flex_select_all</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:ledger_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_ledger_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:struct_num</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_ledger_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>GL_SRS_LEDGER_NO_SETS_STORE_ID</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
led.ledger_id id,
led.name value,
led.description description
from
gl_access_set_ledgers ac,gl_ledgers led
where
ac.access_set_id=fnd_profile.value(&apos;GL_ACCESS_SET_ID&apos;)
and led.ledger_id=ac.ledger_id
and led.object_type_code=&apos;L&apos;
order by name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>select name from gl_ledgers where ledger_id = gl_access_set_security_pkg.get_default_ledger_id(fnd_profile.value(&apos;GL_ACCESS_SET_ID&apos;), &apos;R&apos;)</DEFAULT_VALUE>
    <REQUIRED>Y</REQUIRED>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>الأستاذ</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Buch</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Livre</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Ledger</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>分类账</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>
