ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 8E2FF36EDEA779D2E0530100007F1FF2 FND Form Name Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name US 8E2FF36EDEBB79D2E0530100007F1FF2 FND Function Name Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name US 8E2FF36EDE9379D2E0530100007F1FF2 FND Menu Name Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_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 8E2FF36EDEBA79D2E0530100007F1FF2 FND User Form Name (wildcard) select ffv.user_form_name value, fav.application_name||': '||ffv.form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.user_form_name US 8E2FF36EDEBC79D2E0530100007F1FF2 FND User Function Name (wildcard) select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where 1=1 and fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name US 8E2FF36EDE8B79D2E0530100007F1FF2 FND User Menu Name Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_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. 5033169A159C2B62E0530100007F1D25 select fmv.user_menu_name, fmv.menu_name, xxen_util.meaning(fmv.type,'MENU_TYPE',0) type, fmev.entry_sequence sequence, fmev.prompt, fmt.user_menu_name sub_menu, fffv.function_name, fffv.user_function_name, nvl(xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0),fffv.type) function_type, ffv.form_name, ffv.user_form_name, fffv.parameters, fffv.web_html_call html_call, xxen_util.user_name(fmev.created_by) created_by, xxen_util.client_time(fmev.creation_date) creation_date, xxen_util.user_name(fmev.last_updated_by) last_updated_by, xxen_util.client_time(fmev.last_update_date) last_update_date from fnd_menus_vl fmv, fnd_menu_entries_vl fmev, fnd_menus_tl fmt, fnd_form_functions_vl fffv, fnd_form_vl ffv where 1=1 and fmv.menu_id=fmev.menu_id and fmev.sub_menu_id=fmt.menu_id(+) and fmt.language(+)=userenv('lang') and fmev.function_id=fffv.function_id(+) and fffv.application_id=ffv.application_id(+) and fffv.form_id=ffv.form_id(+) order by fmv.user_menu_name, fmev.entry_sequence Y AR FND Menu Entries الرجاء إدخال معلمات أكثر تقييدًا. D FND Menu Entries Bitte geben Sie restriktivere Parameter ein. E FND Menu Entries Por favor, introduzca parámetros más restrictivos. F FND Menu Entries Veuillez entrer des paramètres plus restrictifs. I FND Menu Entries Si prega di inserire parametri più restrittivi. JA FND Menu Entries より制限的なパラメータを入力してください。 KO FND Menu Entries 더 제한적인 매개 변수를 입력하십시오. PTB FND Menu Entries Por favor, insira parâmetros mais restritivos. RU FND Menu Entries Пожалуйста, введите более ограничительные параметры. S FND Menu Entries Ange mer begränsande parametrar. TR FND Menu Entries Lütfen daha kısıtlayıcı parametreler girin. US FND Menu Entries Please enter more restrictive parameters. ZHS FND Menu Entries 请输入更多限制性参数。 Enginatics 1=1 1 10 1=1 fmv.user_menu_name=:user_menu_name LOV FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 Y select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name F Nom du menu utilisateur US User Menu Name 2 20 1=1 lower(fmv.user_menu_name) like lower(:user_menu_name_like) LOV custom select fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name US User Menu Name like 3 30 1=1 fmv.menu_name=:menu_name LOV FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name F Nom du menu US Menu Name 4 40 1=1 fmev.prompt=:prompt LOV custom Y select distinct fmev.prompt value, null description from fnd_menu_entries_vl fmev where fmev.prompt is not null order by fmev.prompt US Prompt 5 50 1=1 fmev.sub_menu_id in (select fm.menu_id from fnd_menus fm where fm.menu_name=:submenu_name) LOV FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 Y select fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name F Sous-menu US Submenu 6 60 1=1 ( upper(fffv.user_function_name) like upper(:menu_entry) or upper(fffv.function_name) like upper(:menu_entry) or upper(ffv.user_form_name) like upper(:menu_entry) or upper(ffv.form_name) like upper(:menu_entry) ) Char F Entrée du menu Recherche par joker pour les noms de fonctions et de formulaires (à la fois, interne et système) US Menu Entry Wildcard search for function and form names (both, internal and system) 7 70 1=1 upper(fffv.user_function_name) like upper(:user_function_name) LOV FND User Function Name (wildcard) 8E2FF36EDEBC79D2E0530100007F1FF2 select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where 1=1 and fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.user_function_name F Nom de la fonction utilisateur US User Function Name 8 80 1=1 fffv.function_name=:function_name LOV FND Function Name 8E2FF36EDEBB79D2E0530100007F1FF2 Y select fffv.function_name value, flvv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values_vl flvv where fffv.type=flvv.lookup_code(+) and flvv.lookup_type(+)='FORM_FUNCTION_TYPE' and flvv.view_application_id(+)='0' and flvv.security_group_id(+)=0 order by fffv.function_name F Nom de la fonction US Function Name 9 90 1=1 upper(ffv.user_form_name) like upper(:user_form_name) LOV FND User Form Name (wildcard) 8E2FF36EDEBA79D2E0530100007F1FF2 select ffv.user_form_name value, fav.application_name||': '||ffv.form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.user_form_name F Nom du formulaire de l'utilisateur US User Form Name 10 100 1=1 ffv.form_name=:form_name LOV FND Form Name 8E2FF36EDEA779D2E0530100007F1FF2 Y select ffv.form_name value, fav.application_name||': '||ffv.user_form_name||nvl2(ffv.description,': '||ffv.description,null) description from fnd_application_vl fav, fnd_form_vl ffv where fav.application_id=ffv.application_id order by ffv.form_name F Nom du formulaire US Form Name 11 110 1=1 fmv.menu_id in ( select frv.menu_id from fnd_responsibility_vl frv where frv.responsibility_name=:responsibility_name) LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name F Assigné à la responsabilité US Assigned To Responsibility 12 120 1=1 fmev.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 Créé par US Created By 13 130 1=1 fmev.creation_date>=:creation_date_from Date F Date de création du US Creation Date From 14 140 1=1 fmev.creation_date<:creation_date_to+1 Date F Date de création au US Creation Date To 15 150 1=1 fmev.last_update_date>=:date_from Date US Last Update Date From 16 160 1=1 fmev.last_update_date<:updated_to+1 Date US Last Update Date To