ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B88A54A6DFBFC53FE0530100007F0EBC FND Role Code Y select wlr.name value, nvl(wlrt.display_name,wlr.display_name) description from wf_local_roles wlr, wf_local_roles_tl wlrt where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') order by wlr.name US B88A54A6DFC0C53FE0530100007F0EBC FND Role Name Y select decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) value, decode(wlr.orig_system,'FND_RESP',fnd_message.get_string('FND','W3H_RESPONSIBILITY_ROLETYPE'),fnd_message.get_string('FND','W3H_ROLE_ROLETYPE'))||': '||wlr.name||case when sysdate>wlr.expiration_date then ' ('||xxen_util.meaning('I','ACTIVE_INACTIVE',3)||')' end description from wf_local_roles wlr, wf_local_roles_tl wlrt, fnd_responsibility_vl frv where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') and wlr.partition_id=wlrt.partition_id(+) and wlr.orig_system_id=frv.responsibility_id(+) order by value US B883FE6270D53168E0530100007F5691 select xxen_util.meaning(connect_by_root x.category_lookup_code,'UMX_CATEGORY_LOOKUP',0) category, lpad(' ',2*(level-1))||level level_, lpad(' ',2*(level-1))||wr.display_name role_name, lpad(' ',2*(level-1))||x.role role_code, fav.application_name application, xxen_util.meaning(connect_by_root x.category_lookup_code,'UMX_CATEGORY_LOOKUP',0)||sys_connect_by_path(x.role,' > ') role_path from ( select urcv.category_lookup_code, null parent_role, urcv.wf_role_name role from umx_role_categories_v urcv union all select null category_lookup_code, wrh.sub_name parent_role, wrh.super_name role from wf_role_hierarchies wrh where wrh.enabled_flag='Y' ) x, wf_roles wr, fnd_application_vl fav where x.role=wr.name and wr.owner_tag=fav.application_short_name(+) connect by prior x.role=x.parent_role start with 1=1 and x.parent_role is null order by role_path Y AR FND Role Hierarchy التسلسل الهرمي لدور إدارة المستخدم (UMX) لإدارة التحكم في الوصول المستند إلى الدور (RBAC). عند التشغيل لدور محدد ، يعرض التقرير جميع التدرجات الهرمية التي تحتوي على هذا الدور أو تؤدي إليه. D FND Role Hierarchy User Management (UMX)-Rollenhierarchie zur Verwaltung der rollenbasierten Zugriffskontrolle (RBAC). Wenn der Bericht für eine bestimmte Rolle ausgeführt wird, zeigt er alle Hierarchien an, die diese Rolle enthalten oder zu einer Vererbung dieser Rolle führen. E FND Role Hierarchy Jerarquía de roles de Gestión de Usuarios (UMX) para gestionar el control de acceso basado en roles (RBAC). Cuando se ejecuta para un rol especificado, el informe muestra todas las jerarquías que contienen o llevan a heredar ese rol. F FND Role Hierarchy La hiérarchie des rôles de la gestion des utilisateurs (UMX) pour gérer le contrôle d'accès basé sur les rôles (RBAC). Lorsqu'il est exécuté pour un rôle spécifique, l'état affiche toutes les hiérarchies qui contiennent ou conduisent à l'héritage de ce rôle. I FND Role Hierarchy Gestione utenti (UMX) gerarchia dei ruoli per gestire il controllo degli accessi basato sui ruoli (RBAC). Quando viene eseguito per un ruolo specificato, il rapporto mostra tutte le gerarchie che contengono o portano ad ereditare quel ruolo. JA FND Role Hierarchy ユーザー管理（UMX）ロール階層を使用して、ロールベースのアクセス制御（RBAC）を管理します。 指定されたロールに対して実行すると、そのロールを含む、またはそのロールの継承につながるすべての階層がレポートに表示されます。 KO FND Role Hierarchy RBAC (역할 기반 액세스 제어)를 관리하기위한 사용자 관리 (UMX) 역할 계층. 지정된 역할에 대해 실행하면 보고서에 해당 역할을 포함하거나 상속하도록 이어지는 모든 계층이 표시됩니다. PTB FND Role Hierarchy Hierarquia de funções de Gerenciamento de Usuários (UMX) para gerenciar o controle de acesso baseado em funções (RBAC). Quando executado para uma função específica, o relatório mostra todas as hierarquias que contêm ou levam a herdar essa função. RU FND Role Hierarchy Иерархия ролей управления пользователями (UMX) для управления контролем доступа на основе ролей (RBAC). При запуске для определенной роли в отчете отображаются все иерархии, которые содержат или ведут к наследованию этой роли. S FND Role Hierarchy User Management (UMX) rollhierarki för att hantera rollbaserad åtkomstkontroll (RBAC). När du kör för en viss roll visar rapporten alla hierarkier som innehåller eller leder till att ärva den rollen. TR FND Role Hierarchy Rol tabanlı erişim denetimini (RBAC) yönetmek için Kullanıcı Yönetimi (UMX) rol hiyerarşisi. Rapor, belirli bir rol için çalıştırıldığında, bu rolü içeren veya devralmaya yol açan tüm hiyerarşileri gösterir. US FND Role Hierarchy User Management (UMX) role hierarchy to manage role-based access control (RBAC). When run for a specified role, the report shows all hierarchies that contain or lead to inheriting that role. ZHS FND Role Hierarchy 用户管理(UMX)角色层次结构来管理基于角色的访问控制(RBAC)。 当为指定角色运行时，报告会显示包含或导致继承该角色的所有层次结构。 Enginatics 1=1 1 10 1=1 x.role in ( select y.role from ( select urcv.category_lookup_code, null parent_role, urcv.wf_role_name role from umx_role_categories_v urcv union all select null category_lookup_code, wrh.sub_name parent_role, wrh.super_name role from wf_role_hierarchies wrh where wrh.enabled_flag='Y' ) y where y.parent_role is null connect by prior y.parent_role=y.role start with y.role in ( select wlr.name from wf_local_roles wlr, wf_local_roles_tl wlrt, fnd_responsibility_vl frv where decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name))=:role_name and wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') and wlr.partition_id=wlrt.partition_id(+) and wlr.orig_system_id=frv.responsibility_id(+) ) ) LOV FND Role Name B88A54A6DFC0C53FE0530100007F0EBC Y select decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) value, decode(wlr.orig_system,'FND_RESP',fnd_message.get_string('FND','W3H_RESPONSIBILITY_ROLETYPE'),fnd_message.get_string('FND','W3H_ROLE_ROLETYPE'))||': '||wlr.name||case when sysdate>wlr.expiration_date then ' ('||xxen_util.meaning('I','ACTIVE_INACTIVE',3)||')' end description from wf_local_roles wlr, wf_local_roles_tl wlrt, fnd_responsibility_vl frv where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') and wlr.partition_id=wlrt.partition_id(+) and wlr.orig_system_id=frv.responsibility_id(+) order by value F Nom du rôle US Role Name 2 20 1=1 x.role in ( select y.role from ( select urcv.category_lookup_code, null parent_role, urcv.wf_role_name role from umx_role_categories_v urcv union all select null category_lookup_code, wrh.sub_name parent_role, wrh.super_name role from wf_role_hierarchies wrh where wrh.enabled_flag='Y' ) y where y.parent_role is null connect by prior y.parent_role=y.role start with y.role=:role_code ) LOV FND Role Code B88A54A6DFBFC53FE0530100007F0EBC Y select wlr.name value, nvl(wlrt.display_name,wlr.display_name) description from wf_local_roles wlr, wf_local_roles_tl wlrt where wlr.orig_system in ('UMX','FND_RESP') and wlr.name=wlrt.name(+) and wlr.orig_system=wlrt.orig_system(+) and wlr.orig_system_id=wlrt.orig_system_id(+) and wlrt.language(+)=userenv('lang') order by wlr.name F Code de rôle US Role Code