Thursday, April 25, 2013

Query to get Responsibilities Assigned with Particular Function

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');

2 comments:

  1. It does not check for Grant Flag. This query will display responsibility name, even if grant option is disabled for this function.

    Regards,
    Maaz

    ReplyDelete
  2. Try this instead -

    https://maazdba.blogspot.com/2018/11/query-to-fetch-function-assigned-to.html

    Regards,
    Maaz

    ReplyDelete