I'm using Oracle Designer 10.1.2.6, and need to know where to find Role Descriptions for a module.
Here's my starting point in Designer-Repository Object Navigator,
These point to here, so ultimately I want to get Role Responsibilities --> "ACADEMIC_DEPARTMENT" on the right.
I've looked at these tables but can't find where to find this data.
SELECT * FROM sdd_folders app -- applications
SELECT * from sdd_folder_members afm -- intersect between applications and folders
SELECT * from sdd_folders fol -- folders
SELECT * from sdd_folder_members fms -- intersect between folders and modules
SELECT * from sdd_mod gmd WHERE -- modules
SELECT * from sdd_mun mco -- module components
SELECT * from sdd_mti mdt -- module detail table usages
SELECT * from sdd_tab tab -- tables
SELECT * from sdd_ite dbi -- data bound items
SELECT * from sdd_col col -- columns