SQL & PL/SQL

I'm trying to work out some SQL to generate a list of menu and functions that are attached to a given responsibility.

I've got the SQL below which lists menu exclusions against a responsibility:

SELECT   r.responsibility_name "Responsibility Name"
       , a.application_name "Application Name"
       , r.responsibility_key "Responsibility Key"
       , r.description "Description"
       , main.user_menu_name "Menu"
       , fun.user_function_name "Menu Exclusions (Function)"
       , sub.user_menu_name "Menu Exclusions (Menu)"
       , fu.description
       , ex.last_update_date
    FROM apps.fnd_responsibility_vl r
       , apps.fnd_resp_functions ex
       , apps.fnd_form_functions_vl fun
       , apps.fnd_menus_vl main
       , apps.fnd_menus_vl sub
       , apps.fnd_application_tl a
       , apps.fnd_user fu
   WHERE r.responsibility_id = ex.responsibility_id(+)
     AND ex.action_id = fun.function_id(+)
     AND ex.action_id = sub.menu_id(+)
     AND r.menu_id = main.menu_id
     AND r.application_id = a.application_id
     AND fu.user_id = ex.last_updated_by
     AND r.responsibility_name = 'CCC Supplier Profile Manager'
ORDER BY 6,7;

But to do the opposite - to list menus and functions which are associated with a resp seems to be a lot, lot more complicated.

I've looked here at the SQL people have written over the years, and it looks like a real minefield.

I just wondered if anyone else had ever managed to work this one out. Sorry for what seems like a bold as brass "please can I steal your SQL" query.

Thanks