SELECT ffv.TYPE, ff.form_name, ffv.function_name, ffv.user_function_name,
ffv.description, fm.menu_name, frl.responsibility_name,
fme.entry_sequence, fme.prompt
FROM fnd_form_functions_vl ffv,
fnd_form ff,
fnd_menu_entries_vl fme,
fnd_menus fm,
fnd_responsibility fr,
fnd_responsibility_tl frl
WHERE ff.form_id = ffv.form_id
AND fme.function_id = ffv.function_id
AND fm.menu_id = fme.menu_id
AND fr.menu_id = fme.menu_id
AND frl.responsibility_id = fr.responsibility_id
AND ff.form_name = :form_name;
ffv.description, fm.menu_name, frl.responsibility_name,
fme.entry_sequence, fme.prompt
FROM fnd_form_functions_vl ffv,
fnd_form ff,
fnd_menu_entries_vl fme,
fnd_menus fm,
fnd_responsibility fr,
fnd_responsibility_tl frl
WHERE ff.form_id = ffv.form_id
AND fme.function_id = ffv.function_id
AND fm.menu_id = fme.menu_id
AND fr.menu_id = fme.menu_id
AND frl.responsibility_id = fr.responsibility_id
AND ff.form_name = :form_name;
No comments:
Post a Comment