DCP

Thursday 22 September 2016

List Responsibilities have specific Function

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