SELECT r.responsibility_name
FROM fnd_responsibility_vl r, fnd_form_functions f
WHERE f.function_name = < Function_Name>
AND r.menu_id IN (SELECT me.menu_id
FROM fnd_menu_entries me
START WITH me.function_id = f.function_id
CONNECT BY PRIOR me.menu_id = me.sub_menu_id)
AND r.menu_id NOT IN (
SELECT frf.action_id
FROM fnd_resp_functions frf
WHERE frf.action_id = r.menu_id
AND frf.rule_type = 'M')
AND f.function_id NOT IN (
SELECT frf.action_id
FROM fnd_resp_functions frf
WHERE frf.action_id = f.function_id
AND frf.rule_type = 'F');
It does not check for Grant Flag. This query will display responsibility name, even if grant option is disabled for this function.
ReplyDeleteRegards,
Maaz
Try this instead -
ReplyDeletehttps://maazdba.blogspot.com/2018/11/query-to-fetch-function-assigned-to.html
Regards,
Maaz