form,function,菜单常用sql

有时候需要从界面上看from的一些基本信息

属于哪个模块，挂在了那个菜单什么的，一下是比较常用的sql，可以看看

SELECT form.form_name
      ,form.user_form_name
      ,application.application_id
      ,application.application_name
      ,application.application_short_name
  FROM fnd_form_vl        form
      ,fnd_application_vl application
 WHERE form.application_id = application.application_id
   AND form.form_name = 'FNDMNMNU';

SELECT form.form_name
      ,fun.function_name
      ,fun.user_function_name
      ,fun.parameters
  FROM fnd_form_vl           form
      ,fnd_form_functions_vl fun
 WHERE form.form_id = fun.form_id
   AND form.form_name = 'FNDMNMNU';

SELECT LEVEL
      ,entr.prompt
      ,entr.description
      ,menu.menu_name
      ,menu.user_menu_name
      ,menu.menu_id
  FROM fnd_menus_vl        menu
      ,fnd_menu_entries_vl entr
 WHERE menu.menu_id = entr.menu_id
 START WITH function_id =
            (SELECT fun.function_id
               FROM fnd_form_functions_vl fun
              WHERE fun.function_name = 'PERWSEMP')
CONNECT BY PRIOR entr.menu_id = entr.sub_menu_id;

SELECT entr.prompt
  FROM fnd_menus_vl        menu
      ,fnd_menu_entries_vl entr
 WHERE menu.menu_id = entr.menu_id
   AND menu.menu_id = 68050;