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. 71D38CE714E46227E053F400140A79E4 select erp.request_id, xxen_util.user_name(erp.created_by) user_name, frv.responsibility_name, nvl(err.report_name,rr.name) report_name, err.view_name, coalesce( (select flv2.meaning||' - '||flv1.meaning status from fnd_lookup_values flv1, fnd_lookup_values flv2 where decode(fcr.phase_code, 'P',decode(fcr.hold_flag,'Y','H',case when fcr.requested_start_date>sysdate then 'P' else fcr.status_code end), 'R',decode(fcr.hold_flag,'Y','S',decode(fcr.status_code,'Q','B','I','B',fcr.status_code)), fcr.status_code)=flv1.lookup_code and case when flv1.lookup_code in ('H','S','U','M') then 'I' else fcr.phase_code end=flv2.lookup_code and flv1.lookup_type(+)='CP_STATUS_CODE' and flv2.lookup_type(+)='CP_PHASE_CODE' and flv1.language(+)=userenv('lang') and flv2.language(+)=userenv('lang') and flv1.view_application_id(+)=0 and flv2.view_application_id(+)=0 and flv1.security_group_id(+)=0 and flv2.security_group_id(+)=0), nvl2(erp.end_time,'Completed','Active') ) status, xxen_util.client_time(erp.start_time) start_date, xxen_util.time((nvl(erp.end_time,sysdate)-erp.start_time)*86400) time, (nvl(erp.end_time,sysdate)-erp.start_time)*86400 seconds, erp.submission_source, ers.operating_unit, erp.rows_retrieved, erp.parameter1, erp.parameter2, erp.parameter3, erp.parameter4, erp.parameter5, erp.parameter6, erp.parameter7, erp.parameter8, erp.parameter9, erp.parameter10 from xxeis.eis_rs_processes erp, xxeis.eis_rs_sessions ers, xxeis.eis_rs_reports err, xxeis.rg_reports rr, fnd_responsibility_vl frv, fnd_concurrent_requests fcr where 1=1 and erp.session_id=ers.session_id(+) and case when erp.submission_source like 'Email Distribution~%' then to_number(substr(erp.submission_source,20)) when erp.submission_source in ('eXpress','XL Connect') then erp.report_id end=err.report_id(+) and decode(nvl(erp.submission_source,'FSG'),'FSG',erp.report_id)=rr.report_id(+) and ers.responsibility_id=frv.responsibility_id(+) and ers.application_id=frv.application_id(+) and erp.request_id=fcr.request_id(+) order by erp.process_id desc Y US EIS Execution History Execution history of EIS reports. This can be used, for example, when migrating from EIS to Blitz Report, to analyze which EIS reports were previously used by the business. EIS 1=1 1 5 1=1 err.view_name=:view_name LOV custom Y select distinct err.view_name value, null description from xxeis.eis_rs_reports err order by err.view_name F Nom de vue US View Name 2 7 1=1 erp.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 l'utilisateur US Submitted by User 3 10 1=1 erp.creation_date>=sysdate-:submitted_within Number 180 F Soumis dans les jours qui suivent US Submitted within Days 4 20 1=1 erp.submission_source not like 'Email Distribution%' LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description Y Y F Exclure la distribution d'e-mails US Exclude Email Distribution