FND Menu Entries

➜ Back to Library
Description
Categories: Enginatics
Repository: Github
Run FND Menu Entries and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
User Menu Name 
fmv.user_menu_name=:user_menu_name
 LOV
User Menu Name like 
lower(fmv.user_menu_name) like lower(:user_menu_name)
 LOV
Menu Name 
fmv.menu_name=:menu_name
 LOV
Prompt 
fmev.prompt=:prompt
 LOV
Submenu 
fmev.sub_menu_id in (select fm.menu_id from fnd_menus fm where fm.menu_name=:submenu_name)
 LOV
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)
)
 Char
User Function Name 
upper(fffv.user_function_name) like upper(:user_function_name)
 LOV
Function Name 
fffv.function_name=:function_name
 LOV
User Form Name 
upper(ffv.user_form_name) like upper(:user_form_name)
 LOV
Form Name 
ffv.form_name=:form_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
Created By 
fmev.created_by=xxen_util.user_id(:created_by)
 LOV
Creation Date From 
fmev.creation_date>=:creation_date_from
 DateTime
Creation Date To 
fmev.creation_date<=:creation_date_to
 DateTime
Last Update Date From 
fmev.last_update_date>=:date_from
 Date
Last Update Date To 
fmev.last_update_date<:updated_to+1
 Date
Download
 
Related Blitz Reports
FND Access Control 11i FND Responsibility Access 11i FND Responsibility Access FND Responsibility Menu Exclusions FND User Login Page Favorites FND Forms Personalizations XXEN: FND User Login History with Geolocation FND FNDLOAD Object Transfer FND Form Functions
Blitz Report™

Blitz Report™ provides multiple benefits: