Form Details:-
SELECT DISTINCT application_short_name, 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,
fnd_application fat
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 fat.application_id=forms.application_id
AND UPPER (forms.form_name) LIKE 'XX%'
ORDER BY 1,2
Form Personalization:
SELECT DISTINCT ffv.form_name, fa.application_name,ffv.form_id, ffv.user_form_name,
ffv.description form_description, ffcr.sequence,
ffcr.description personalization_rule_name
FROM fnd_form_vl ffv, fnd_form_custom_rules ffcr, fnd_application_tl fa
WHERE ffv.form_name = ffcr.form_name
AND fa.application_id=ffv.application_id
ORDER BY 2, 1;
SELECT DISTINCT application_short_name, 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,
fnd_application fat
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 fat.application_id=forms.application_id
AND UPPER (forms.form_name) LIKE 'XX%'
ORDER BY 1,2
Form Personalization:
SELECT DISTINCT ffv.form_name, fa.application_name,ffv.form_id, ffv.user_form_name,
ffv.description form_description, ffcr.sequence,
ffcr.description personalization_rule_name
FROM fnd_form_vl ffv, fnd_form_custom_rules ffcr, fnd_application_tl fa
WHERE ffv.form_name = ffcr.form_name
AND fa.application_id=ffv.application_id
ORDER BY 2, 1;
No comments:
Post a Comment