USER_MENU AND RESPONSIBILITY_QUERY

SELECT a.responsibility_id,  a.responsibility_name, k.application_name, y.responsibility_key,
         d.user_menu_name menu_name,
         c.request_group_name request_group,
         k.application_name requset_application_name, x.data_group_name,
         k.application_name AS data_application_name,
         DECODE (b.rule_type, 'F', 'Function', 'M', 'Menu') "Rule Type",
         DECODE (b.rule_type,
                 'F', e.user_function_name,
                 'M', f.user_menu_name
                ) "Menu Exclusion"
    FROM fnd_responsibility_vl a,
         fnd_application_tl k,
         fnd_resp_functions b,
         fnd_request_groups c,
         fnd_menus_vl d,
         --fnd_form_functions e,
         fnd_form_functions_tl e,
         --         fnd_menus f
         fnd_menus_tl f,
         fnd_data_groups x,
         fnd_responsibility y
   WHERE a.data_group_id = x.data_group_id
     AND a.application_id = k.application_id
     AND y.responsibility_id = a.responsibility_id
     --AND a.responsibility_name LIKE 'SKG%AP%Super%'
     AND a.application_id = b.application_id(+)
     AND a.responsibility_id = b.responsibility_id(+)
     AND a.application_id = c.application_id(+)
     AND a.request_group_id = c.request_group_id(+)
     AND a.menu_id = d.menu_id(+)
     AND b.action_id = e.function_id(+)
     AND b.action_id = f.menu_id(+)
--     and a.responsibility_name='SKD WIP Manager'
GROUP BY
a.responsibility_id,
a.responsibility_name,
         k.application_name,
         d.user_menu_name,
         k.application_name,
         c.request_group_name,
         k.application_name,
         x.data_group_name,
         k.application_name,
         DECODE (b.rule_type, 'F', 'Function', 'M', 'Menu'),
         DECODE (b.rule_type,
                 'F', e.user_function_name,
                 'M', f.user_menu_name
                ),
         y.responsibility_key
--and a.responsibility_name = 'AX General Ledger User'
--and a.RESPONSIBILITY_ID='52630'
order by a.responsibility_id

--------------   THANK YOU MR.SELVARAJ    ------------------------------