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 8E2FF36EDEBE79D2E0530100007F1FF2 FND Application Short Name Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name US 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 8E2FF36EDE9E79D2E0530100007F1FF2 FND Responsibility Name Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name US 8E2FF36EDEBD79D2E0530100007F1FF2 FND User Form Name Y 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 8E2FF36EDE8A79D2E0530100007F1FF2 FND User Function Name select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ','')||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.user_function_name US 4E859EF1B4767A20E0530100007F7403Y select fffv.function_name function, fffv.user_function_name, nvl(xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0),fffv.type) type, fav.application_name form_application, ffv.form_name, ffv.user_form_name, fffv.parameters, fffv.web_html_call html_call, xxen_util.user_name(fffv.created_by) created_by, xxen_util.client_time(fffv.creation_date) creation_date, xxen_util.user_name(fffv.last_updated_by) last_updated_by, xxen_util.client_time(fffv.last_update_date) last_update_date from fnd_form_functions_vl fffv, fnd_application_vl fav, fnd_form_vl ffv where 1=1 and ffv.application_id=fav.application_id(+) and fffv.application_id=ffv.application_id(+) and fffv.form_id=ffv.form_id(+) order by ffv.form_name, fffv.function_name US FND Form Functions Enginatics 1=1 1 10 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 2 20 1=1 upper(fffv.user_function_name) like upper(:user_function_name) LOV FND User Function Name 8E2FF36EDE8A79D2E0530100007F1FF2 select fffv.user_function_name value, flvv.meaning||nvl2(fffv.description,': ','')||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.user_function_name F Nom de la fonction utilisateur US User Function Name like 3 30 1=1 fffv.type=xxen_util.lookup_code(:function_type,'FORM_FUNCTION_TYPE',0) LOV custom Y select nvl(xxen_util.meaning(fffv.type,'FORM_FUNCTION_TYPE',0),fffv.type) value, count(*) description from fnd_form_functions_vl fffv group by fffv.type order by count(*) desc US Function Type 4 40 1=1 fav.application_name=:application_name 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 Formulaire Nom de l'application US Form Application Name 5 50 1=1 fav.application_short_name=:short_name LOV FND Application Short Name 8E2FF36EDEBE79D2E0530100007F1FF2 Y select fav.application_short_name value, fav.application_name description from fnd_application_vl fav order by fav.application_short_name F Formulaire de demande Nom court US Form Application Short Name 6 60 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 7 70 1=1 ffv.user_form_name=:user_form_name LOV FND User Form Name 8E2FF36EDEBD79D2E0530100007F1FF2 Y 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 8 80 1=1 fffv.function_id in ( select fcmf.function_id from fnd_responsibility_vl frv, fnd_compiled_menu_functions fcmf where frv.responsibility_name=:responsibility_name and frv.menu_id=fcmf.menu_id and nvl(fcmf.grant_flag,'Y')='Y' ) LOV FND Responsibility Name 8E2FF36EDE9E79D2E0530100007F1FF2 Y select frv.responsibility_name value, frv.description from fnd_responsibility_vl frv order by frv.responsibility_name F Nom de la responsabilité US Responsibility Name 9 90 1=1 lower(fffv.web_html_call) like '%'||lower(:html_call)||'%' Char F Appel HTML comme US HTML Call contains