Thursday, August 11, 2016

Query to get List of Custom Form List

SELECT  DISTINCT forms.form_name,
          formstl.user_form_name,
          func.function_name,
          func.user_function_name,
          fm.menu_name,
          menu.prompt menu_prompt,
          menu.description,
          restl.responsibility_name
   FROM   fnd_form FORMS,
          fnd_form_tl FORMSTL,
          fnd_form_functions_VL FUNC,
          fnd_menu_entries_VL MENU,
          FND_MENUS FM,
          fnd_responsibility RES,
          fnd_responsibility_tl RESTL
  WHERE   1=1
          and forms.form_id = formstl.form_id
          and func.form_id = forms.form_id
          and menu.function_id = func.function_id
          and menu.menu_id=fm.menu_id
          and res.menu_id = menu.menu_id
          and res.responsibility_id = restl.responsibility_id
          and UPPER(forms.form_name) like '%XXCUST%'      
          order by 1;