ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN F1D2E3C4B5A697081A2B3C4D5E6F7081Y select null action_, null status_, null message_, null request_id_, null modified_columns_, fmv.user_menu_name, fmv.menu_name, fmv.description menu_description, xxen_util.meaning(fmv.type,'MENU_TYPE',0) type, fme.entry_sequence, fmet.prompt, fmv2.user_menu_name sub_menu, fffv.user_function_name function_name, fmet.description entry_description, xxen_util.yes(fme.grant_flag) grant_flag, to_char(null) delete_record, row_number() over (order by fmv.menu_name, fme.entry_sequence) upload_row from fnd_menus_vl fmv, fnd_menu_entries fme, fnd_menu_entries_tl fmet, fnd_menus_vl fmv2, fnd_form_functions_vl fffv where 1=1 and fmv.menu_id=fme.menu_id and fme.menu_id=fmet.menu_id and fme.entry_sequence=fmet.entry_sequence and fmet.language=userenv('lang') and fme.sub_menu_id=fmv2.menu_id(+) and fme.function_id=fffv.function_id(+) Grant Flag shows Yes or blank, and a blank Grant Flag entered on a row makes the entry not grantable. Entry Sequence defaults to the next multiple of ten above the highest sequence of the menu. Distinct messages for created and updated entries. U A xxen_fnd_upload.menu_entry US FND Menu Entry Upload Upload to create, update and delete the entries of existing menus, as in the Menus form. Upload Mode Create opens an empty sheet for new entries. Create, Update downloads the entries of the menus selected by the parameters; new rows can be added to the same file. User Menu Name and Menu Name select the menu and default each other. An entry is identified by the menu and its Entry Sequence, which defaults to the next multiple of ten above the highest sequence of the menu. Changing the Entry Sequence of a downloaded row creates a new entry and keeps the old one; delete the old entry with Delete Record Yes. Either Sub Menu or Function Name is required. A blank Grant Flag makes the entry not grantable. Enginatics Upload 1=1 1 10 1=1 :p_upload_mode like '%' || xxen_upload.action_update LOV Blitz Upload Mode E811F942597A2075E0530100007FF4F2 select xxen_upload.action_create id, xxen_upload.action_meaning(xxen_upload.action_create) value, null description from dual union all select xxen_upload.action_create||','||xxen_upload.action_update id, xxen_upload.action_meaning(xxen_upload.action_create)||', '||xxen_upload.action_meaning(xxen_upload.action_update) value, null description from dual C Y US Upload Mode 2 20 1=1 fmv.user_menu_name=:user_menu_name LOV FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 select fmv.menu_id id, fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name value US User Menu Name 3 30 1=1 fmv.menu_name=:menu_name LOV FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 select fmv.menu_id id, fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name value US Menu Name 4 40 1=1 fffv.function_name=:function_name LOV FND Function Name 8E2FF36EDEBB79D2E0530100007F1FF2 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 Function Name 5 50 1=1 fffv.user_function_name=:user_function_name LOV FND User Function Name 8E2FF36EDE8A79D2E0530100007F1FF2 Y 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 User Function Name 6 60 1=1 exists (select null from fnd_responsibility_vl frv where frv.menu_id=fmv.menu_id and frv.responsibility_name=:responsibility_name) LOV FND Responsibility Name (all) 09F3BD7AC59948C48074E55D79406C72 select frv.responsibility_name value, fav.application_name description from fnd_responsibility_vl frv, fnd_application_vl fav where frv.application_id=fav.application_id order by frv.responsibility_name US Responsibility 13C22F5F84E9416F86BB1F01654DE8AB Default All columns. ENGINATICS 11 DELETE_RECORD 9 ENTRY_DESCRIPTION 5 ENTRY_SEQUENCE 8 FUNCTION_NAME 10 GRANT_FLAG 3 MENU_DESCRIPTION Y 2 MENU_NAME 6 PROMPT 7 SUB_MENU 4 TYPE 1 USER_MENU_NAME S Site 13C22F5F84E9416F86BB1F01654DE8AB 1 ACTION_ Char varchar2 2 STATUS_ Char varchar2 3 MESSAGE_ Char varchar2 4 REQUEST_ID_ Char varchar2 Y 5 MODIFIED_COLUMNS_ Char varchar2 Y 6 USER_MENU_NAME LOV varchar2 80 FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 select fmv.menu_id id, fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name select fmv.user_menu_name from fnd_menus_vl fmv where fmv.menu_name=:$column$.menu_name Y 7 MENU_NAME LOV varchar2 30 FND Menu Name 8E2FF36EDE9379D2E0530100007F1FF2 select fmv.menu_id id, fmv.menu_name value, fmv.user_menu_name description from fnd_menus_vl fmv order by fmv.menu_name select fmv.menu_name from fnd_menus_vl fmv where fmv.user_menu_name=:$column$.user_menu_name Y 8 MENU_DESCRIPTION Char varchar2 240 select fmv.description from fnd_menus_vl fmv where fmv.menu_name=:$column$.menu_name 9 TYPE LOV varchar2 FND Menu Type D4E632B4BAD94AB298BBEA07EA9868A1 select flvv.lookup_code id, flvv.meaning value, flvv.description from fnd_lookup_values_vl flvv where flvv.lookup_type='MENU_TYPE' and flvv.security_group_id=0 and flvv.enabled_flag='Y' order by flvv.meaning select xxen_util.meaning(fm.type,'MENU_TYPE',0) from fnd_menus fm where fm.menu_name=:$column$.menu_name 10 ENTRY_SEQUENCE Number number select floor(nvl(max(fme.entry_sequence),0)/10)*10+10 from fnd_menus fm, fnd_menu_entries fme where fm.menu_name=:$column$.menu_name and fm.menu_id=fme.menu_id 11 PROMPT Char varchar2 60 12 SUB_MENU LOV varchar2 80 FND User Menu Name 8E2FF36EDE8B79D2E0530100007F1FF2 select fmv.menu_id id, fmv.user_menu_name value, fmv.menu_name||': '||fmv.description description from fnd_menus_vl fmv order by fmv.user_menu_name 13 FUNCTION_NAME LOV custom varchar2 80 select fffv.function_id id, fffv.user_function_name value, fffv.function_name description from fnd_form_functions_vl fffv order by fffv.user_function_name 14 ENTRY_DESCRIPTION Char varchar2 240 15 GRANT_FLAG LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual xxen_util.meaning('Y','YES_NO',0) 16 DELETE_RECORD LOV varchar2 Yes 8E2FF36EDEA679D2E0530100007F1FF2 select 'Y' id, xxen_util.meaning('Y','YES_NO',0) value, null description from dual 17 UPLOAD_ROW Number number Y U 2 status_ out Char STATUS_CODE_ U 3 message_ out Char MESSAGE_ U 4 p_menu_id in Number MENU_NAME U 5 p_entry_sequence in Number ENTRY_SEQUENCE U 6 p_sub_menu_id in Number SUB_MENU U 7 p_function_id in Number FUNCTION_NAME U 8 p_prompt in Char PROMPT U 9 p_description in Char ENTRY_DESCRIPTION U 10 p_grant_flag in Char GRANT_FLAG U 11 p_delete_record in Char DELETE_RECORD Error SQL Order By upload_row, menu_name, entry_sequence Success SQL select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, xu.user_menu_name, xu.menu_name, xu.menu_description, xu.type, nvl(fme.entry_sequence,xu.entry_sequence) entry_sequence, nvl(fmet.prompt,xu.prompt) prompt, nvl(fmv2.user_menu_name,xu.sub_menu) sub_menu, nvl(fffv.user_function_name,xu.function_name) function_name, nvl(fmet.description,xu.entry_description) entry_description, decode(fme.menu_id,null,xu.grant_flag,xxen_util.yes(fme.grant_flag)) grant_flag, to_char(null) delete_record, to_number(xu.upload_row) upload_row from ( select xu.action_, xu.status_, xu.message_, xu.request_id_, xu.modified_columns_, fmv.user_menu_name, fmv.menu_name, fmv.description menu_description, xxen_util.meaning(fmv.type,'MENU_TYPE',0) type, to_number(xu.entry_sequence) entry_sequence, xu.prompt, xu.sub_menu, xu.function_name, xu.entry_description, xu.grant_flag, xu.upload_row, fmv.menu_id from xxen_fnd_menu_entry_upl_1137_u xu, fnd_menus_vl fmv where xu.status_code_='S' and xu.menu_name=fmv.menu_name ) xu, --before 12c an outer joined table may reference at most one other table, so the driving tables are wrapped fnd_menu_entries fme, fnd_menu_entries_tl fmet, fnd_menus_vl fmv2, fnd_form_functions_vl fffv where xu.menu_id=fme.menu_id(+) and xu.entry_sequence=fme.entry_sequence(+) and xu.menu_id=fmet.menu_id(+) and xu.entry_sequence=fmet.entry_sequence(+) and fmet.language(+)=userenv('lang') and fme.sub_menu_id=fmv2.menu_id(+) and fme.function_id=fffv.function_id(+)