Menu and Functions Related Scripts

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)