<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 Other - Data Access Set Listing -->
 <REPORTS_ROW>
  <GUID>82288223F4D53869E053B46B63588994</GUID><ENABLED>Y</ENABLED>
  <SQL_TEXT>select  an.ledger_id LEDGER_ID, l.name LEDGER_NAME, lp.meaning LEDGER_TYPE , 
        an.all_segment_value_flag ALL_SEGMENT_VALUE_FLAG,
        an.access_privilege_code ACCESS_PRIVILEGE_CODE, an.segment_value SESGMENT_VALUE
from gl_access_set_norm_assign an, gl_ledgers l, gl_lookups lp
where an.access_set_id = :P_ACCESS_SET_ID
and l.ledger_id = an.ledger_id
and lp.lookup_type = &apos;LEDGERS&apos;
and lp.lookup_code = l.object_type_code
order by l.name, an.segment_value
</SQL_TEXT>
  <XDO_APPLICATION_SHORT_NAME>SQLGL</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>GLXDALST_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: GLXDALST_XML
DB package: GL_GLXDALST_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>GL Sonstiges - DatenzugriffsSets</REPORT_NAME>
    <DESCRIPTION>Application: Rechnungswesen
Source: Sonstiges - DatenzugriffsSets (XML)
Short Name: GLXDALST_XML
DB package: GL_GLXDALST_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>GL Autre - Liste des jeux d&apos;accès aux données</REPORT_NAME>
    <DESCRIPTION>Application: General Ledger
Source: Autre - Liste des jeux d&apos;accès aux données (XML)
Short Name: GLXDALST_XML
DB package: GL_GLXDALST_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>GL Other - Data Access Set Listing</REPORT_NAME>
    <DESCRIPTION>Application: General Ledger
Source: Other - Data Access Set Listing (XML)
Short Name: GLXDALST_XML
DB package: GL_GLXDALST_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>GL 其它 - 数据访问权限集列表</REPORT_NAME>
    <DESCRIPTION>Application: 总帐管理系统
Source: 其它 - 数据访问权限集列表 (XML)
Short Name: GLXDALST_XML
DB package: GL_GLXDALST_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>:calendar</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:coa</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:data_as_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:default_ledger</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:description</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:l_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_access_set_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:period_type</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:security_segment_code</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_access_set_id</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>GL_SRS_DATA_ACCESS_SETS</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
a1.access_set_id id,
a1.name value,
a1.description description
from
gl_access_sets a1,gl_access_sets a2
where a2.access_set_id=fnd_profile.value(&apos;GL_ACCESS_SET_ID&apos;) and a1.period_set_name=a2.period_set_name and a1.accounted_period_type=a2.accounted_period_type and a1.chart_of_accounts_id=a2.chart_of_accounts_id and a1.enabled_flag=&apos;Y&apos; order by a1.name</LOV_QUERY_DSP>
    <DEFAULT_VALUE>SELECT name 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>مجموعة صلاحيات الوصول للبيانات</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>DatenzugriffsSet</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Jeu d&apos;accès aux données</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Data Access Set</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>数据访问权限集</PARAMETER_NAME>
     </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>
