<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: IGI Subledger Security: User Allocation Status - draft -->
 <REPORTS_ROW>
  <GUID>82288223F04C3869E053B46B63588994</GUID>
  <SQL_TEXT>SELECT  g.sls_group,
               g.sls_group || &apos; - &apos;|| g.description sls_name_desc,
	IGI_IGISLSUA_XMLP_PKG.cf_1formula(g.sls_group) CF_1
FROM     igi_sls_groups g
WHERE   g.sls_group_type = &apos;S&apos;
AND        g.sls_group like :P_GROUP_NAME_T
AND       g.sls_group != &apos;CEN&apos;
AND        NVL(:P_USER_NAME_T, &apos;%&apos;) = &apos;%&apos;
UNION
SELECT  g.sls_group,
         g.sls_group || &apos; - &apos;|| g.description sls_name_desc,
	IGI_IGISLSUA_XMLP_PKG.cf_1formula(g.sls_group) CF_1
FROM     igi_sls_groups g,
	fnd_profile_options            pro,
	fnd_profile_option_values prv,
	fnd_responsibility              res,
	fnd_user_resp_groups_direct urg,
	fnd_user             usr
WHERE   g.sls_group_type = &apos;S&apos;
AND     g.sls_group != &apos;CEN&apos;
AND     g.sls_group like :P_GROUP_NAME_T
AND     pro.profile_option_name = &apos;IGI_SLS_SECURITY_GROUP&apos;
AND     prv.profile_option_value = g.sls_group
AND     pro.profile_option_id       = prv.profile_option_id
AND     prv.level_value        = res.responsibility_id
AND     urg.user_id = usr.user_id
AND     urg.responsibility_id = res.responsibility_id
AND     NVL(:P_USER_NAME_T, &apos;%&apos;) != &apos;%&apos;
AND     usr.user_name = :P_USER_NAME_T
AND     NVL(usr.end_date,sysdate) &gt;= SYSDATE
ORDER BY sls_group
</SQL_TEXT>
  <DISABLED>Y</DISABLED>
  <XDO_APPLICATION_SHORT_NAME>IGI</XDO_APPLICATION_SHORT_NAME>
  <XDO_DATA_SOURCE_CODE>IGISLSUA_XML</XDO_DATA_SOURCE_CODE>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>IGI سرية دفتر الأستاذ الفرعي: تقرير موقف تخصيص المستخدم (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل</REPORT_NAME>
    <DESCRIPTION>Application: الماليات الدولية للقطاع العام
Source: سرية دفتر الأستاذ الفرعي: تقرير موقف تخصيص المستخدم (بتنسيق XML) - غير مدعم: محجوز للاستخدام الآجل
Short Name: IGISLSUA_XML
DB package: IGI_IGISLSUA_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>IGI Benutzerzuordnungsstatus- Nicht unterstützt: Reserviert für zukünftige Verwendung</REPORT_NAME>
    <DESCRIPTION>Application: Public Sector Financials International
Source: Nebenbuchsicherheit: Benutzerzuordnungsstatus (XML) - Nicht unterstützt: Reserviert für zukünftige Verwendung
Short Name: IGISLSUA_XML
DB package: IGI_IGISLSUA_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>IGI Sécurité des auxiliaires : Statut des affectations utilisateur- Non pris en charge : réservé pour une utilisation ultérieure</REPORT_NAME>
    <DESCRIPTION>Application: Public Sector Financials International
Source: Sécurité des auxiliaires : Statut des affectations utilisateur (XML) - Non pris en charge : réservé pour une utilisation ultérieure
Short Name: IGISLSUA_XML
DB package: IGI_IGISLSUA_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>IGI Subledger Security: User Allocation Status - draft</REPORT_NAME>
    <DESCRIPTION>Application: Public Sector Financials International
Source: Subledger Security: User Allocation Status Report (XML) - Not Supported: Reserved For Future Use
Short Name: IGISLSUA_XML
DB package: IGI_IGISLSUA_XMLP_PKG</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>IGI 子分类帐安全性：用户分配状态报表- 不支持：已保留供将来使用</REPORT_NAME>
    <DESCRIPTION>Application: Public Sector Financials International
Source: 子分类帐安全性：用户分配状态报表 (XML) - 不支持：已保留供将来使用
Short Name: IGISLSUA_XML
DB package: IGI_IGISLSUA_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>:cp_group</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_conc_request_id</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_group_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_group_name_t</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_user_name</ANCHOR>
   </ANCHORS_ROW>
   <ANCHORS_ROW>
    <ANCHOR>:p_user_name_t</ANCHOR>
   </ANCHORS_ROW>
  </ANCHORS>
  <PARAMETERS>
   <PARAMETERS_ROW>
    <SORT_ORDER>1</SORT_ORDER>
    <DISPLAY_SEQUENCE>10</DISPLAY_SEQUENCE>
    <ANCHOR>:p_group_name</ANCHOR>
    <PARAMETER_TYPE_DSP>Char</PARAMETER_TYPE_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>اسم مجموعة سرية SLS</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Nebenbuchsicherheit: Bezeichnung Sicherheitsgruppe</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom du groupe de sécurité SLS</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>SLS Security Group Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>ZHS</LANGUAGE>
      <PARAMETER_NAME>SLS 安全组名</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>2</SORT_ORDER>
    <DISPLAY_SEQUENCE>20</DISPLAY_SEQUENCE>
    <ANCHOR>:p_user_name</ANCHOR>
    <PARAMETER_TYPE_DSP>LOV Oracle</PARAMETER_TYPE_DSP>
    <LOV_NAME>IGI_SLS_USERNAME</LOV_NAME>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
user_name id,
user_name value,
description description
from
fnd_user
order by value,description</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>AR</LANGUAGE>
      <PARAMETER_NAME>معرف المستخدم</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>D</LANGUAGE>
      <PARAMETER_NAME>Benutzerkennung</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>ID utilisateur</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>User Id</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>
