ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN A1BD664005FC395FE0530100007F4DC1 FND Language (installed) Y select flv.description value, flv.language_code||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.description US A30B566296EA7049E0530100007F123E FND Language Code Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code 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 A30B53EFC3537F42E0530100007FC4F0 select xrc.column_name, xrc.number_format, xrct.language_desc language, xrct.translation, xrct.language language_code, xxen_util.user_name(xrc.created_by) column_created_by, xxen_util.client_time(xrc.creation_date) column_creation_date, xxen_util.user_name(xrc.last_updated_by) column_last_updated_by, xxen_util.client_time(xrc.last_update_date) column_last_update_date, xxen_util.user_name(xrct.created_by) translation_created_by, xxen_util.client_time(xrct.creation_date) translation_creation_date, xxen_util.user_name(xrct.last_updated_by) translation_last_updated_by, xxen_util.client_time(xrct.last_update_date) translation_last_update_date from xxen_report_columns xrc, (select flv.description language_desc, xrct.* from xxen_report_columns_tl xrct, fnd_languages_vl flv where 2=2 and xrct.language=flv.language_code) xrct where 1=1 and xrc.column_id=xrct.column_id(+) order by xrc.column_name, xrct.language_desc Y US Blitz Report Column Translations Enginatics 1=1 2=2 1 10 1=1 xrc.column_name like lower(:column_name) Char US Column Name like 2 20 2=2 flv.language_code=:language_code LOV FND Language Code A30B566296EA7049E0530100007F123E Y select flv.language_code value, flv.description||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.language_code userenv('lang') F Code de la langue US Language Code 3 1=1 (xrc.number_format is not null or xrct.column_id is not null) US Language Code 4 30 2=2 flv.description=:language LOV FND Language (installed) A1BD664005FC395FE0530100007F4DC1 Y select flv.description value, flv.language_code||decode(flv.installed_flag,'B',' (base language)') description from fnd_languages_vl flv where flv.installed_flag in ('I','B') order by flv.installed_flag, flv.description F Langue US Language 5 40 1=1 xrct.last_updated_by=xxen_util.user_id(:last_updated_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 Dernière mise à jour par US Last Updated By 6 50 1=1 xrct.last_update_date>=:last_update_date_from Date F Date de la dernière mise à jour du US Last Update Date From 7 60 1=1 ( xxen_report.underscore_to_space(xrc.column_name)=xrct.translation or lower(xxen_report.underscore_to_space(xrc.column_name))=lower(xrct.translation) and xrct.language<>'US' ) LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Afficher uniquement les obsolètes US Show obsolete only