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 BC8B8F352F4D3B90E0530100007FD79F select fu.user_name, fu.description, papf.first_name, papf.last_name, fu.email_address, papf.email_address hr_email_address, fu.start_date user_start_date, fu.end_date user_end_date, fu.last_logon_date, xxen_util.client_time(fu.password_date) password_date, (select count(*) from fnd_user_resp_groups furg where fu.user_id=furg.user_id) active_responsibilities, (select 'Y' from fnd_user_resp_groups furg, fnd_responsibility fr where fu.user_id=furg.user_id and furg.responsibility_application_id=fr.application_id and furg.responsibility_id=fr.responsibility_id and fr.responsibility_key='SYSTEM_ADMINISTRATOR') has_sysadmin, xrr.total blitz_report_runs, xrr.runs_12m, xrr.runs_6m, xrr.runs_3m, xrr.runs_1m, xxen_util.user_name(fu.created_by) created_by, xxen_util.client_time(fu.creation_date) creation_date, xxen_util.user_name(fu.last_updated_by) last_updated_by, xxen_util.client_time(fu.last_update_date) last_update_date, fu.user_id from fnd_user fu, (select papf.* from per_all_people_f papf where sysdate between papf.effective_start_date and papf.effective_end_date) papf, ( select distinct xrr.created_by, xxen_util.zero_to_null(count(*) over (partition by xrr.created_by)) total, xxen_util.zero_to_null(count(case when xrr.creation_date>sysdate-365 then 1 end) over (partition by xrr.created_by)) runs_12m, xxen_util.zero_to_null(count(case when xrr.creation_date>sysdate-182 then 1 end) over (partition by xrr.created_by)) runs_6m, xxen_util.zero_to_null(count(case when xrr.creation_date>sysdate-91 then 1 end) over (partition by xrr.created_by)) runs_3m, xxen_util.zero_to_null(count(case when xrr.creation_date>sysdate-30 then 1 end) over (partition by xrr.created_by)) runs_1m from xxen_report_runs xrr ) xrr where 1=1 and fu.employee_id=papf.person_id(+) and fu.user_id=xrr.created_by(+) order by case when nvl(fu.end_date,sysdate)>=trunc(sysdate) then 1 else 2 end, fu.creation_date desc, fu.user_name Y US FND Users Listing of all EBS users, their status, responsibility count, and if they were using blitz reports 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 fu.user_id in ( select furg.user_id from fnd_responsibility_vl frv, fnd_user_resp_groups furg where frv.responsibility_name=:responsibility and frv.responsibility_id=furg.responsibility_id and frv.application_id=furg.responsibility_application_id ) LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name F A accès à la responsabilité US Has Access to Responsibility 3 30 1=1 fu.user_id in ( select furg.user_id from fnd_application_vl fav, fnd_user_resp_groups furg where fav.application_name=:application and fav.application_id=furg.responsibility_application_id ) 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 F A accès à l'application US Has Access to Application 4 40 1=1 sysdate between fu.start_date and nvl(fu.end_date,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 5 50 1=1 fu.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 6 60 1=1 fu.creation_date<:creation_date_to+1 Date F Date de création au US Creation Date To 7 70 1=1 fu.creation_date>=sysdate-:days Number F Créé en quelques jours US Created within days