Responsibities Function

Dear All,

I am developing a report in which the report will shows the responsibilities and the functions’s prompt associated with the menu are in use in that responsibility.

I have done the hereunder script but I still need to exclude from the query all (functions or menus ) which already excluded from the responsibility.

Anybody can help me how to conduct these exclusions. I have checked the FND_RESP_FUNCTIONS for the excluded functions/menus but this table does not show the excluded function names or IDs…

Currently we're in EBS 11i 11.5.9

 

SELECT res.responsibility_name    ,

       res.responsibility_id