reneegf33的部落格

SELECT /*+ALL_ROWS */
 srno,
 b.entry_sequence,
 padding,
 RPAD(' ', 4 * (padding - 1)) || prompt menuprompt,
 a.description,
 b.menu_id,
 b.sub_menu_id,
 b.function_id,
 c.user_function_name
  FROM apps.fnd_menu_entries_tl a,
       (SELECT ROWNUM srno,
               LEVEL padding,
               menu_id,
               entry_sequence,
               sub_menu_id,
               function_id
          FROM apps.fnd_menu_entries
        CONNECT BY menu_id = PRIOR sub_menu_id
         START WITH menu_id IN
                    (SELECT /*+ALL_ROWS */
                      menu_id
                       FROM apps.fnd_responsibility_vl
                      WHERE NVL(end_date, SYSDATE) > = SYSDATE
                        AND responsibility_name = 'Purchasing Super User')) b, -- Enter responsibility name here
       fnd_form_functions_tl c
 WHERE a.menu_id = b.menu_id
   AND a.entry_sequence = b.entry_sequence
   AND a.LANGUAGE = USERENV('LANG')
      --AND a.menu_id IN ('80825')
   AND b.function_id = c.function_id(+);