To List out all functions under a particular Menu

This script will accept the menu name as parameter and will list all functions that can be accessed under that menu.

SELECT DISTINCT
 
fmep.menu_id,
 
DECODE(fmep.function_id,NULL, DECODE(fmec.function_id, NULL,DECODE(fmec1.function_id,NULL,
 
'No Func',fmec1.function_id ),
 
fmec.function_id),
 
fmep.function_id) funcID,
 
fff.user_function_name,
 
fff.description 
 
FROM fnd_form_functions_tl fff, 
 
fnd_menu_entries fmec1,
 
fnd_menu_entries fmec,
 
fnd_menu_entries fmep
 
WHERE fmep.menu_id = (SELECT menu_id 
 
FROM fnd_menus
 
WHERE menu_name='INV_NAVIGATE'Â --Change the menu according to your requirement
 
AND ROWNUM=1)
 
AND fmep.sub_menu_id = fmec .menu_id(+)
 
AND fmec.sub_menu_id = fmec1 .menu_id (+)
 
AND fff.function_id = DECODE (fmep.function_id,NULL,DECODE(fmec.function_id, NULL,
 
DECODE(fmec1.function_id,NULL,-999,fmec1.function_id),
 
fmec.function_id),
 
fmep.function_id) 
 
ORDER BY DECODE(fmep .function_id,NULL, DECODE(fmec.function_id, NULL,
 
DECODE(fmec1.function_id,NULL, 'No Func',fmec1.function_id ),
 
fmec.function_id),
 
fmep.function_id)