select responsibility_name
from FND_responsibility_vl fr
, FND_MENUS fm
, FND_COMPILED_MENU_FUNCTIONS fmf
,fnd_Form_functions_vl ff
WHERE ff.USER_FUNCTION_NAME = 'View Suppliers' --1
AND ff.function_id = fmf.function_id --2
AND fmf.menu_id = fm.menu_id --3
AND fm.menu_id = fr.menu_id --4
AND responsibility_name LIKE 'D%';
No comments:
Post a Comment