List of Functions assigned to 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,
         (SELECT user_menu_name
            FROM fnd_menus_tl
           WHERE     1 = 1
                 AND language = USERENV ('LANG')
                 AND ROWNUM = 1
                 AND menu_id = fmep.menu_id)
            Menu_name,
         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 IN
            (SELECT menu_id
               FROM fnd_menus_tl
              WHERE UPPER (user_menu_name) LIKE 'INV%REPORTS%'
                    AND language = USERENV ('LANG') --Change the menu according to your requirement
                                                   )
         AND fmep.sub_menu_id = fmec.menu_id(+)
         AND fff.language = USERENV ('LANG')
         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);

SELECT *
  FROM fnd_menus_tl
 WHERE language = USERENV ('LANG')
       AND UPPER (user_menu_name) LIKE 'RECI%MAN%';