Responsibility Query Final

SELECT   a.responsibility_id, a.responsibility_name, a.menu_id,
d.user_menu_name menu_name, a.request_group_id, c.request_group_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_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
   WHERE 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 = 'AX General Ledger User'
     --and a.RESPONSIBILITY_ID='52630'
ORDER BY 2, 7, 8