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)