Menu and Functions Related Scripts

Apr 172011

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)