ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDE9879D2E0530100007F1FF2 FND Application Name Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US 8E2FF36EDE9E79D2E0530100007F1FF2 FND Responsibility Name Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US 8E2FF36EDE8479D2E0530100007F1FF2 FND User Name Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name US FND user names, excluding iRecruitment candidates. 8E2FF36EDEA679D2E0530100007F1FF2 Yes Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual US 7715059FB59A4E4FE0530100007F14C6 select xxen_util.user_name(furg.user_id) user_name, frv.responsibility_name responsibility, fav.application_name application, furg.start_date, furg.end_date, furg.type, xxen_util.user_name(furg.created_by) assigned_by, xxen_util.client_time(furg.creation_date) assignment_date, xxen_util.user_name(furg.last_updated_by) last_updated_by, xxen_util.client_time(furg.last_update_date) last_update_date, fu.start_date user_start_date, fu.end_date user_end_date, xxen_util.user_name(fu.created_by) user_created_by, xxen_util.client_time(fu.creation_date) user_creation_date, xxen_util.user_name(fu.last_updated_by) user_last_updated_by, xxen_util.client_time(fu.last_update_date) user_last_update_date, furg.user_id, furg.responsibility_id from ( select 'Direct' type, furgd.* from fnd_user_resp_groups_direct furgd union all select 'Indirect' type, furgi.* from fnd_user_resp_groups_indirect furgi ) furg, fnd_user fu, fnd_responsibility_vl frv, fnd_application_vl fav where 1=1 and furg.user_id=fu.user_id and furg.responsibility_application_id=frv.application_id and furg.responsibility_id=frv.responsibility_id and furg.responsibility_application_id=fav.application_id order by case when nvl(fu.end_date,sysdate)>=trunc(sysdate) then 1 else 2 end, fu.user_name, case when nvl(furg.end_date,sysdate)>=trunc(sysdate) then 1 else 2 end, frv.responsibility_name Y AR FND User Responsibilities على غرار تقرير التحكم في الوصول إلى FND ، ولكنه يظهر أيضًا مسؤوليات المستخدم غير النشطة / المؤرخة في حين أن التحكم في الوصول FND يعرض المسؤوليات النشطة المعينة حاليًا فقط. مماثل لتقرير Oracle "المستخدمين النشطين". D FND User Responsibilities Ähnlich wie Bericht FND Access Control, zeigt aber auch inaktive/veraltete Benutzerzuständigkeiten an, während FND Access Control nur die derzeit aktiven zugewiesenen Zuständigkeiten anzeigt. Ähnlich wie der Bericht "Aktive Benutzer" von Oracle. E FND User Responsibilities Similar al informe FND Control de Acceso, pero también muestra las responsabilidades de los usuarios inactivos/finalizados, mientras que FND Control de Acceso sólo muestra las responsabilidades asignadas actualmente activas. Igual que el informe "Usuarios activos" de Oracle. F FND User Responsibilities Semblable au rapport Contrôle d'accès du FND, mais indique également les responsabilités inactives / datées de la fin de l'utilisateur, tandis que le Contrôle d'accès du FND indique uniquement les responsabilités attribuées actuellement actives. Identique au rapport "Utilisateurs actifs" d'Oracle. I FND User Responsibilities Simile al rapporto FND Access Control, ma mostra anche le responsabilità degli utenti inattivi/finiti, mentre FND Access Control mostra solo le responsabilità assegnate attualmente attive. Uguale al rapporto "Utenti attivi" di Oracle. JA FND User Responsibilities FNDアクセス・コントロールのレポートと似ていますが、FNDアクセス・コントロールは現在アクティブな割り当てられた責任のみを表示するのに対し、非アクティブな/終了日付けのユーザーの責任も表示されます。 Oracleの「Active Users」レポートと同じです。 KO FND User Responsibilities 보고서 FND 액세스 제어와 유사하지만 비활성 / 종료 날짜 사용자 책임도 표시하는 반면 FND 액세스 제어는 현재 활성 할당 된 책임 만 표시합니다. Oracle의 '활성 사용자'보고서와 동일합니다. PTB FND User Responsibilities Similar ao relatório FND Controle de Acesso, mas também mostra as responsabilidades inativas / datadas do usuário final, enquanto o FND Controle de Acesso mostra apenas as responsabilidades atribuídas atualmente ativas. O mesmo que o relatório "Usuários Ativos" da Oracle. RU FND User Responsibilities Аналогично отчету FND Access Control, но также показывает неактивные/конечные обязанности пользователя, в то время как FND Access Control показывает только текущие активные назначенные обязанности. То же самое, что и отчет Oracle "Активные пользователи". S FND User Responsibilities Liknar rapport FND Access Control, men visar också inaktiva / slutdaterade användaransvar medan FND Access Control bara visar för närvarande aktivt tilldelat ansvar. Samma som Oracles rapport "Aktiva användare". TR FND User Responsibilities Rapor FND Erişim Kontrolüne benzer, ancak aynı zamanda etkin olmayan / son tarihli kullanıcı sorumluluklarını gösterirken, FND Erişim Kontrolü yalnızca halihazırda aktif olarak atanmış sorumlulukları gösterir. Oracle'ın 'Etkin Kullanıcılar' raporuyla aynı. US FND User Responsibilities Similar to report FND Responsibility Access, but also shows inactive / end dated user responsibilities while FND Access Control shows currently active assigned responsibilities only. Same as Oracle's 'Active Users' report. ZHS FND User Responsibilities 类似于报告FND访问控制，但也显示非活动/结束日期的用户职责，而FND访问控制只显示当前活动的分配职责。 与Oracle的 "活跃用户 "报告相同。 Enginatics 1=1 1 10 1=1 fu.user_name=:user_name LOV FND User Name 8E2FF36EDE8479D2E0530100007F1FF2 Y Y select fu.user_name value, trim(coalesce( trim(papf.first_name||' '||papf.last_name), fu.description, fu.email_address, papf.email_address )||fu.inactive) description from (select case when sysdate between fu.start_date and nvl(fu.end_date,sysdate) then null else ' (inactive)' end inactive, fu.* from fnd_user fu) fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct furg.user_id, count(*) over (partition by furg.user_id) resp_count, max(fr.responsibility_key) over (partition by furg.user_id) max_responsibility_key from fnd_responsibility fr, fnd_user_resp_groups_direct furg where fr.responsibility_id=furg.responsibility_id and fr.application_id=furg.responsibility_application_id ) furg where fu.employee_id=papf.person_id(+) and fu.user_id=furg.user_id(+) and not (furg.resp_count=1 and furg.max_responsibility_key='IRC_EXT_CANDIDATE') order by fu.inactive desc, fu.user_name F Nom de l'utilisateur US User Name 2 20 1=1 frv.responsibility_name=:responsibility LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name F Nom de la responsabilité US Responsibility Name 3 30 1=1 fav.application_name=:application_name LOV FND Application Name 8E2FF36EDE9879D2E0530100007F1FF2 Y select fav.application_name value, fav.application_short_name description from fnd_application_vl fav order by fav.application_name US Application 4 40 1=1 sysdate between fu.start_date and nvl(fu.end_date,sysdate) and sysdate between nvl(furg.start_date,sysdate) and nvl(furg.end_date,sysdate) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Actif uniquement US Active only 5 50 1=1 furg.end_date>=:end_date_from Date F Fin Date de US End Dated from