This script will accept the menu name as parameter and will list all functions that can be accessed under that menu.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 |
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) |