Oracle discoverer - Tables and Queries

Discoverer reports and to get list of those from backend is different from oracle reports . They have own set of tables and these tables are not listed in oracle ETRM .

Below queries can be used to get list of responsibilities that have access to particular workbook .

To get list of Oracle discoverer workbooks,  below query can be used 

select * from disco.EUL5_DOCUMENTS ;

once we get doc id from the above query,  we can run the below query to get list of responsibilities that can run our workbook .

Select * From Apps.Fnd_Responsibility_Tl Where '#'||Responsibility_Id||'#'|| Application_Id in(

Select Eu_Username From Disco.Eul5_Eul_Users Where Eu_Id In (

Select Ap_Eu_Id From Disco.Eul5_Access_Privs Where Gd_Doc_Id=&p_doc_id)) and language='US';