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 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 49A8B1A803B008ACE0530100007FEB91 select fav.application_name, decode(ffcr.rule_type,'A','Function','F','Form',ffcr.rule_type) level_, decode(ffcr.enabled,'Y','Y') enabled, ffcr.form_name, ffv.user_form_name, decode(ffcr.rule_type,'A',ffcr.function_name) function_name, decode(ffcr.rule_type,'A',fffv.user_function_name) user_function_name, ffcr.sequence, ffcr.description, ffcr.trigger_event, ffcr.trigger_object, ffcr.condition, decode(ffcr.fire_in_enter_query,'Y','Both','N','Not in Enter-Query Mode','O','Only in Enter-Query Mode') processing_mode, xxen_util.user_name(nvl(ffca.last_updated_by,ffcr.last_updated_by)) last_updated_by, xxen_util.client_time(nvl(ffca.last_update_date,ffcr.last_update_date)) last_update_date, &context_columns ffca.sequence action_sequence, decode(ffca.action_type,'P','Property','M','Message','B','Builtin','S','Menu') action_type, ffca.summary action_desc, decode(ffca.language,'*','All',flv.description) language, decode(ffca.enabled,'Y','Y') action_enabled, decode(ffca.action_type,'P',decode(ffca.object_type,'VAR','Local Variable','LOV','LOV','GLOBAL','Global Variable','TAB','Tab Page',initcap(ffca.object_type))) property_object_type, decode(ffca.action_type,'P',ffca.target_object) property_target_object, decode(ffca.action_type,'P',ffcpl.property_name) property_name, decode(ffca.action_type,'P',decode(ffcpl.argument_type, 'B',decode(ffca.property_value,'4','True','5','False'), 'L',(select ffcpv.property_value from fnd_form_custom_prop_values ffcpv where ffcpl.property_name=ffcpv.property_name and ffca.property_value=ffcpv.property_id), ffca.property_value) ) property_value, --decode(ffcpl.argument_type,'B','Boolean','C','Character','N','Number','L','LOV','T','Block','I','Item') argument_type decode(ffca.action_type,'M',decode(ffca.message_type,'S','Show','H','Hint','E','Error','D','Debug','W','Warn')) message_type, decode(ffca.action_type,'M',ffca.message_text) message_text, decode(ffca.action_type,'B',decode(ffca.builtin_type, 'C','Launch SRS Form', 'E','Launch a Function', 'U','Launch a URL', 'D','DO_KEY', 'P','Execute a Procedure', 'G','GO_ITEM', 'B','GO_BLOCK', 'F','FORMS_DDL', 'R','RAISE FORM_TRIGGER_FAILURE', 'T','EXECUTE_TRIGGER', 'S','SYNCHRONIZE', 'L','Call Custom Library', 'Q','Create Record Group from Query', 'X','Set Profile Value in Cache' )) builtin_type, decode(ffca.action_type,'B',case when ffca.builtin_type='C' then (select fcpv.user_concurrent_program_name from fnd_concurrent_programs_vl fcpv, fnd_application fa where substr(ffca.builtin_arguments,1,instr(ffca.builtin_arguments,':')-1)=fa.application_short_name and fa.application_id=fcpv.application_id and substr(ffca.builtin_arguments,instr(ffca.builtin_arguments,':')+1)=fcpv.concurrent_program_name) when ffca.builtin_type='E' then (select fffv.user_function_name from fnd_form_functions_vl fffv where ffca.menu_argument_short=fffv.function_name) when ffca.builtin_type in ('Q','X') then ffca.builtin_arguments when ffca.builtin_type in ('U','D','P','G','B','F','T','L') then ffca.builtin_arguments end) builtin_value, decode(ffca.action_type,'B',case when ffca.builtin_type in ('U','Q') then ffca.menu_argument_short when ffca.builtin_type in ('E','X') then ffca.menu_argument_long end) builtin_value2, ffca.menu_entry, ffca.menu_label, decode(ffca.menu_seperator,'Y','Y') render_line_before_menu, ffca.menu_argument_short icon_name, ffca.menu_enabled_in enabled_in_block, ffcr.id from fnd_form_custom_rules ffcr, fnd_form_functions_vl fffv, fnd_form_vl ffv, fnd_application_vl fav, (select ffcs.* from fnd_form_custom_scopes ffcs where '&show_scope'='Y') ffcs, fnd_industries fi, fnd_responsibility_vl frv, fnd_user fu, fnd_form_custom_actions ffca, fnd_languages_vl flv, fnd_form_custom_prop_list ffcpl where 1=1 and ffcr.rule_key is null and ffcr.function_name=fffv.function_name(+) and fffv.application_id=ffv.application_id(+) and fffv.form_id=ffv.form_id(+) and fffv.application_id=fav.application_id(+) and ffcr.id=ffcs.rule_id(+) and decode(ffcs.level_id,10,ffcs.level_value)=fi.industry_id(+) and fi.language(+)=userenv('lang') and decode(ffcs.level_id,30,ffcs.level_value_application_id)=frv.application_id(+) and decode(ffcs.level_id,30,ffcs.level_value)=frv.responsibility_id(+) and decode(ffcs.level_id,40,ffcs.level_value)=fu.user_id(+) and ffcr.id=ffca.rule_id(+) and ffca.language=flv.language_code(+) and decode(ffca.action_type,'P',ffca.object_type)=ffcpl.field_type(+) and ffca.property_name=ffcpl.property_id(+) order by fav.application_name, ffv.form_name, level_, function_name, decode(ffcr.rule_type,'A',ffcr.function_name), ffcr.sequence, ffca.sequence Y AR FND Forms Personalizations نماذج التخصيصات والإجراءات D FND Forms Personalizations Personalisierungen und Aktionen für Formulare E FND Forms Personalizations Personalizaciones y acciones de los formularios F FND Forms Personalizations Personnalisations et actions I FND Forms Personalizations Personalizzazioni e azioni dei moduli JA FND Forms Personalizations フォームのパーソナライズとアクション KO FND Forms Personalizations 개인화 및 작업 형성 PTB FND Forms Personalizations Formulários de personalizações e ações RU FND Forms Personalizations Формы персонализаций и действий S FND Forms Personalizations Formulär personaliseringar och handlingar TR FND Forms Personalizations Form kişiselleştirmeleri ve eylemler US FND Forms Personalizations Forms personalizations and actions ZHS FND Forms Personalizations 表格个性化和行动 Enginatics &context_columns &show_scope 1=1 1 10 1=1 ffcr.form_name=:form_name LOV custom 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 ffv.form_name in (select ffcr.form_name from fnd_form_custom_rules ffcr) and fav.application_id=ffv.application_id order by ffv.form_name F Nom du formulaire US Form Name 2 20 1=1 fffv.function_name=:function_name LOV custom Y select fffv.function_name value, flv.meaning||nvl2(fffv.description,': ',null)||fffv.description description from fnd_form_functions_vl fffv, fnd_lookup_values flv where fffv.function_name in (select ffcr.function_name from fnd_form_custom_rules ffcr) and fffv.type=flv.lookup_code(+) and flv.lookup_type(+)='FORM_FUNCTION_TYPE' and flv.view_application_id(+)='0' and flv.language(+)=userenv('lang') and flv.security_group_id(+)=0 order by fffv.function_name F Nom de la fonction US Function Name 3 30 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 Nom de l'application US Application Name 4 40 1=1 lower(ffcr.description) like lower(:description) LOV custom select distinct ffcr.description value, ffcr.form_name||': '||ffcr.trigger_event description from fnd_form_custom_rules ffcr where 1=1 and ffcr.rule_key is null order by ffcr.description, description US Description like 5 50 1=1 nvl(ffca.last_updated_by,ffcr.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 60 1=1 greatest(nvl(ffca.last_update_date,ffcr.last_update_date),ffcr.last_update_date)>sysdate-:days Number F Dernière mise à jour en quelques jours US Last Update within Days 7 70 1=1 greatest(nvl(ffca.last_update_date,ffcr.last_update_date),ffcr.last_update_date)>=:last_update_date_from Date F Date de la dernière mise à jour du US Last Update Date From 8 80 1=1 greatest(nvl(ffca.last_update_date,ffcr.last_update_date),ffcr.last_update_date)<:last_update_date_to+1 Date US Last Update Date To 9 90 &show_scope Y LOV Yes 8E2FF36EDEA679D2E0530100007F1FF2 Y select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual F Montrer le contexte US Show Context 10 &context_columns decode(ffcs.level_id,10,'Industry',20,'Site',30,'Responsibility',40,'User',ffcs.level_id) context_level, decode(ffcs.level_id,10,fi.industry_name,30,frv.responsibility_name,40,fu.user_name) context_value, F Montrer le contexte US Show Context