Very useful. Thank you. I was looking around for other ideas and found your query. I want to run a query that will show me all OWB jobs coming from different projects. Right now I have five different OWB projects and workflow jobs on one production instance. I should be able to run this in OWBSYS to see all of them? I will need to check. Just started looking into this.
There is also a set of reports available in a zip here: Oracle PL/SQL Sample Code. Scroll down to "OWB SQL Developer Reports". These then can be installed in Oracle SQL Developer.
Also, is there somewhere a document that elaborates more on public views, like for instance all_rt_audit_exec_messages and all the other deployment and runtime public views?
Of course there is the doco, but it doesn't elaborate about each one of them: Public Views for the Runtime Environmenthttp://www.findthatpdf.com/search-59603838-hPDF/download-documents-owb11gr2runtimemodel.pdf.htm
And then there is this great find with the ER model for runtime. Have not seen it in the past.