Reports2017-11-18T12:27:27+00:00

FND Menu Entries

Description
Categories: Application, Enginatics, Setup

select
fmv.menu_name,
fmv.user_menu_name,
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,
fmev.creation_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

Parameter Name SQL text Validation
Created By
fmev.created_by in (select fu.user_id from fnd_user fu where fu.user_name=:user_name)
LOV
Assigned To Responsibility
fmv.menu_id in (
select
frv.menu_id
from
fnd_responsibility_vl frv
where
frv.responsibility_name=:responsibility_name)
LOV
Form Name
ffv.form_name=:form_name
LOV
User Menu Name
fmv.user_menu_name=:user_menu_name
LOV
User Form Name
upper(ffv.user_form_name) like upper(:user_form_name)
LOV
Function Name
fffv.function_name=:function_name
LOV
User Function Name
upper(fffv.user_function_name) like upper(:user_function_name)
LOV
Submenu
fmev.sub_menu_id in (select fm.menu_id from fnd_menus fm where fm.menu_name=:submenu_name)
LOV
Menu Name
fmv.menu_name=:menu_name
LOV
Creation Date To
fmev.creation_date<=:creation_date_to
DateTime
Creation Date From
fmev.creation_date>=:creation_date_from
DateTime
Menu Entry
(
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)
)
Prompt
fmev.prompt=:prompt
LOV