To identify the menu list in responsibility in Oracle Apps

/* Formatted on 7/17/2014 11:55:20 AM (QP5 v5.115.810.9015) */
SELECT res.responsibility_name,
       app.application_name,
       res.responsibility_key,
       res.description,
       res.start_date,
       res.end_date,
       dat.data_group_name,
       apd.application_name,
       mnu.menu_name,
       req.request_group_name,
       apr.application_name,
       DECODE (exc.rule_type, 'F', 'Function', 'M', 'Menu', rule_type)
          exclusion_type,
       DECODE (exc.rule_type,
          'F', (SELECT function_name || ',' || description
                FROM fnd_form_functions_vl fnc
                WHERE fnc.function_id = exc.action_id),
          'M', (SELECT menu_name || ',' || description
                FROM fnd_menus_vl imn
                WHERE imn.menu_id = exc.action_id),
          TO_CHAR (exc.action_id))
          excluded_menu_or_func
FROM apps.fnd_responsibility_vl res,
     apps.fnd_application_vl app,
     apps.fnd_data_groups dat,
     apps.fnd_menus_vl mnu,
     apps.fnd_request_groups req,
     apps.fnd_application_vl apd,
     apps.fnd_application_vl apr,
     apps.fnd_resp_functions exc
WHERE     res.application_id = app.application_id
      AND res.data_group_id = dat.data_group_id
      AND res.data_group_application_id = apd.application_id
      AND res.menu_id = mnu.menu_id
      AND req.request_group_id = res.request_group_id
      AND req.application_id = res.group_application_id
      AND apr.application_id = req.application_id
      AND exc.application_id = res.application_id
      AND exc.responsibility_id = res.responsibility_id;