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 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US B88A54A6DFBDC53FE0530100007F0EBC select x.* from ( select decode(wlr.orig_system,'FND_RESP',frv.responsibility_name,nvl(wlrt.display_name,wlr.display_name)) role_name, wlr.name role_code, decode(wlr.orig_system,'FND_RESP',fnd_message.get_string('FND','W3H_RESPONSIBILITY_ROLETYPE'),fnd_message.get_string('FND','W3H_ROLE_ROLETYPE')) role_type, wlr.expiration_date, (select count(*) from wf_user_role_assignments wura where wlr.name=wura.role_name and sysdate between wura.effective_start_date and nvl(wura.effective_end_date,sysdate)) assigned_users from wf_local_roles wlr, wf_local_roles_tl wlrt, fnd_responsibility_vl frv where 1=1 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(+) ) x where 2=2 order by x.role_name Y AR FND Roles تقرير بجميع أدوار إدارة المستخدم (UMX) ، بما في ذلك عدد المستخدمين النشطين لكل دور للمساعدة في إدارة التحكم في الوصول المستند إلى الدور (RBAC) D FND Roles Bericht aller User Management (UMX)-Rollen, einschließlich der Anzahl der aktiven Benutzer für jede Rolle, um die Verwaltung der rollenbasierten Zugriffskontrolle (RBAC) zu unterstützen E FND Roles Informe de todas las funciones de gestión de usuarios (UMX), incluido el número de usuarios activos para cada función, para ayudar a gestionar el control de acceso basado en funciones (RBAC) F FND Roles Rapport de tous les rôles de gestion des utilisateurs (UMX), y compris le nombre d'utilisateurs actifs pour chaque rôle afin de faciliter la gestion du contrôle d'accès basé sur les rôles (RBAC) I FND Roles Rapporto di tutti i ruoli di gestione degli utenti (UMX), incluso il numero di utenti attivi per ogni ruolo per aiutare la gestione del controllo di accesso basato sui ruoli (RBAC) JA FND Roles ロールベースのアクセス制御（RBAC）の管理を支援するために、各ロールのアクティブユーザー数を含むすべてのユーザー管理（UMX）ロールのレポート KO FND Roles RBAC (역할 기반 액세스 제어) 관리를 돕기 위해 각 역할에 대한 활성 사용자 수를 포함하여 모든 사용자 관리 (UMX) 역할에 대한 보고서 PTB FND Roles Relatório de todas as funções de Gerenciamento de Usuários (UMX), incluindo o número de usuários ativos para cada função, para ajudar a gerenciar o controle de acesso baseado em funções (RBAC) RU FND Roles Отчет обо всех ролях управления пользователями (UMX), включая количество активных пользователей для каждой роли, чтобы помочь в управлении контролем доступа на основе ролей (RBAC). S FND Roles Rapportera alla UMX-roller (User Management), inklusive antal aktiva användare för varje roll för att hantera rollbaserad åtkomstkontroll (RBAC) TR FND Roles Rol tabanlı erişim denetimini (RBAC) yönetmeye yardımcı olmak için her rol için etkin kullanıcı sayısı dahil olmak üzere tüm Kullanıcı Yönetimi (UMX) rollerinin raporu US FND Roles Report of all User Management (UMX) roles, including number of active users for each role to help managing role-based access control (RBAC) ZHS FND Roles 报告所有用户管理（UMX）角色，包括每个角色的活跃用户数，以帮助管理基于角色的访问控制（RBAC）。 Enginatics 1=1 2=2 1 10 2=2 x.role_name=:role_name 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 wlr.name=: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 3 30 1=1 nvl(wlr.expiration_date,sysdate)>=sysdate LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Actif uniquement US Active only