Below query to get the list of Custom Form List in oracle application.
Query:
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
-- FORMSTL.language
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;
Query:
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
-- FORMSTL.language
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;
No comments:
Post a Comment