<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: FND Responsibility Menu Exclusions -->
 <REPORTS_ROW>
  <GUID>5BEA547A6E64274FE0530100007F0FFA</GUID>
  <SQL_TEXT>select
frv.responsibility_name,
fav.application_name application,
xxen_util.meaning(frf.rule_type,&apos;FND_RESP_FUNC_RULE_TYPE&apos;,0) type,
decode(frf.rule_type,&apos;F&apos;,fffv.user_function_name,fmv.user_menu_name) name,
decode(frf.rule_type,&apos;F&apos;,fffv.function_name,fmv.menu_name) system_name,
decode(frf.rule_type,&apos;F&apos;,fffv.description,fmv.description) description,
xxen_util.user_name(frf.created_by) created_by,
xxen_util.client_time(frf.creation_date) creation_date,
xxen_util.user_name(frf.last_updated_by) last_updated_by,
xxen_util.client_time(frf.last_update_date) last_update_date
from
fnd_application_vl fav,
fnd_responsibility_vl frv,
fnd_resp_functions frf,
fnd_form_functions_vl fffv,
fnd_menus_vl fmv
where
1=1 and
fav.application_id=frv.application_id and
frv.application_id=frf.application_id and
frv.responsibility_id=frf.responsibility_id and
decode(frf.rule_type,&apos;F&apos;,frf.action_id)=fffv.function_id(+) and
decode(frf.rule_type,&apos;M&apos;,frf.action_id)=fmv.menu_id(+)
order by
frv.responsibility_name,
type,
name</SQL_TEXT>
  <ENABLED>Y</ENABLED>
  <REPORT_TRANSLATIONS>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>AR</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>استثناءات قائمة المسؤولية</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>D</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Verantwortung Menüausschlüsse</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>E</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Exclusiones del menú de responsabilidad</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>F</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Exclusions du menu responsabilité</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>I</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Esclusioni del menu di responsabilità</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>JA</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>責任メニューの除外</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>KO</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>책임 메뉴 제외</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>PTB</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Exclusões do menu de responsabilidade</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>RU</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Исключения из меню ответственности</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>S</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Ansvarsmeny undantag</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>TR</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Sorumluluk menüsü hariç tutmaları</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>US</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>Responsibility menu exclusions</DESCRIPTION>
   </REPORT_TRANSLATIONS_ROW>
   <REPORT_TRANSLATIONS_ROW>
    <LANGUAGE>ZHS</LANGUAGE>
    <REPORT_NAME>FND Responsibility Menu Exclusions</REPORT_NAME>
    <DESCRIPTION>责任菜单排除项</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>upper(frv.responsibility_name) like upper(:responsibility_name)</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
frv.responsibility_name value,
frv.description
from
fnd_responsibility_vl frv
where
(frv.application_id,frv.responsibility_id) in (select frf.application_id, frf.responsibility_id from fnd_resp_functions frf)
order by
frv.responsibility_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom de la responsabilité</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Responsibility Name</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>fffv.user_function_name=:user_function_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fffv.user_function_name value,
xxen_util.meaning(fffv.type,&apos;FORM_FUNCTION_TYPE&apos;,0)||&apos;: &apos;||fffv.function_name description
from
fnd_form_functions_vl fffv
where
fffv.function_id in (select frf.action_id from fnd_resp_functions frf where frf.rule_type=&apos;F&apos;)
order by
fffv.function_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom de la fonction de l&apos;utilisateur exclu</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Excluded User Function Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>3</SORT_ORDER>
    <DISPLAY_SEQUENCE>30</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fffv.function_name=:function_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fffv.function_name value,
xxen_util.meaning(fffv.type,&apos;FORM_FUNCTION_TYPE&apos;,0)||&apos;: &apos;||fffv.user_function_name description
from
fnd_form_functions_vl fffv
where
fffv.function_id in (select frf.action_id from fnd_resp_functions frf where frf.rule_type=&apos;F&apos;)
order by
fffv.function_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom de la fonction exclue</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Excluded Function Name</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
    </PARAMETER_TRANSLATIONS>
   </PARAMETERS_ROW>
   <PARAMETERS_ROW>
    <SORT_ORDER>4</SORT_ORDER>
    <DISPLAY_SEQUENCE>40</DISPLAY_SEQUENCE>
    <ANCHOR>1=1</ANCHOR>
    <SQL_TEXT>fmv.menu_name=:menu_name</SQL_TEXT>
    <PARAMETER_TYPE_DSP>LOV custom</PARAMETER_TYPE_DSP>
    <VALIDATE_FROM_LIST_DSP>Y</VALIDATE_FROM_LIST_DSP>
    <LOV_QUERY_DSP>select
fmv.menu_name value,
fmv.user_menu_name description
from
fnd_menus_vl fmv
where
fmv.menu_id in (select frf.action_id from fnd_resp_functions frf where frf.rule_type=&apos;M&apos;)
order by
fmv.menu_name</LOV_QUERY_DSP>
    <PARAMETER_TRANSLATIONS>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>F</LANGUAGE>
      <PARAMETER_NAME>Nom du menu exclu</PARAMETER_NAME>
     </PARAMETER_TRANSLATIONS_ROW>
     <PARAMETER_TRANSLATIONS_ROW>
      <LANGUAGE>US</LANGUAGE>
      <PARAMETER_NAME>Excluded Menu 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>
