ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 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 49A8B1A8036508ACE0530100007FEB91 select y.report_name, y.count, y.type_dsp type, y.category, xxen_util.time(avg_seconds) avg_time, xxen_util.time(max_seconds) max_time, xxen_util.time(sum_seconds) sum_time, y.avg_seconds, y.max_seconds, y.sum_seconds, y.users, y.most_frequent, y.created_by, xxen_util.client_time(y.creation_date) creation_date, y.last_updated_by, xxen_util.client_time(y.last_update_date) last_update_date, y.total_users from ( select distinct count(x.run_id) over (partition by x.report_id) count, x.report_name, round(sum(x.seconds) over (partition by x.report_id)/count(*) over (partition by x.report_id),2) avg_seconds, round(max(x.seconds) over (partition by x.report_id),2) max_seconds, round(sum(x.seconds) over (partition by x.report_id),2) sum_seconds, count(distinct x.xrr_created_by) over (partition by x.report_id) users, max(xxen_util.user_name(x.xrr_created_by)) keep (dense_rank last order by x.count_per_user, x.xrr_created_by) over (partition by x.report_id) most_frequent, x.category, x.created_by, x.creation_date, x.last_updated_by, x.last_update_date, x.type_dsp, count(distinct x.xrr_created_by) over () total_users from ( select xrv.report_name, xrv.type_dsp, xxen_util.user_name(xrv.created_by) created_by, xrv.creation_date, xxen_util.user_name(xrv.last_updated_by) last_updated_by, xrv.last_update_date, (xrr.completion_date-xrr.creation_date)*86400 seconds, xrr.run_id, xrr.report_id, xrr.created_by xrr_created_by, xxen_api.category(xrv.report_id) category, count(xrr.run_id) over (partition by xrr.report_id, xrr.created_by) count_per_user from xxen_reports_v xrv, xxen_report_runs xrr where 1=1 and xrr.completion_date is not null and xrr.completion_message is null and xrv.report_id=xrr.report_id(+) ) x ) y order by y.count desc nulls last Y US Blitz Report History Summary Count and performance summary of historic Blitz Report executions Enginatics 1=1 1 10 1=1 upper(xrv.report_name) like upper(:report_name) LOV custom Y select xrv.report_name value, xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null)||substrb(xrv.description,1,4000-lengthb(xrv.type_dsp||nvl2(xrv.type,' ',null)||nvl2(xrv.category,'('||xrv.category||') ',null))) description from xxen_reports_v xrv where xrv.report_id in (select xrr.report_id from xxen_report_runs xrr where :$flex$.Submitted_within_Days is null or xrr.creation_date>=sysdate-:$flex$.Submitted_within_Days) order by xrv.report_name F Nom du rapport Contrats de services US Report Name Service Contracts 2 20 1=1 xrr.created_by=xxen_util.user_id(:created_by) 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 Soumis par US Submitted By 3 30 1=1 xrr.creation_date>=sysdate-:submitted_within Number 60 F Soumis dans les jours qui suivent US Submitted within Days 4 40 1=1 nvl(xrr.type,'x')<>'S' LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Exclure les rapports du système US Exclude System Reports 5 50 1=1 xrr.created_by<>fnd_global.user_id LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual Y F Exclure ses propres soumissions US Exclude own Submissions :$flex$.Submitted_within_Days Submitted within Days Report Name