tag:blogger.com,1999:blog-4715885911366291269.post6713646006287332052..comments2023-10-08T06:18:19.211-04:00Comments on Oracle Applications - Suresh Vaishya: How to query/find discoverer reports in Oracle using APPS SchemaSuresh Vaishyahttp://www.blogger.com/profile/04830206267375957769noreply@blogger.comBlogger4125tag:blogger.com,1999:blog-4715885911366291269.post-84960497273070223982014-01-30T09:18:41.852-05:002014-01-30T09:18:41.852-05:00Right on!
Thank you,
I was looking for the list of...Right on!<br />Thank you,<br />I was looking for the list of reports in Disc EUL<br /><br />..masoudفلاطونhttps://www.blogger.com/profile/01252422234001196905noreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-54091009379201266972013-01-09T13:48:00.250-05:002013-01-09T13:48:00.250-05:00Actually, I just found that we also have OWNER = &...Actually, I just found that we also have OWNER = 'DISCOVERER'.<br /><br />Maybe just look for like %DOCUMENT% and look for reasonable OWNER'sAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-78495510989747003402013-01-09T12:00:07.246-05:002013-01-09T12:00:07.246-05:00That assumes that one knows the EUL...
Try this:
...That assumes that one knows the EUL...<br /><br />Try this:<br /> SELECT OWNER, TABLE_NAME<br /> FROM ALL_TABLES<br /> WHERE OWNER LIKE '%EUL%'<br /> AND TABLE_NAME LIKE '%DOCUMENT%'Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-4715885911366291269.post-75455475209853530672011-06-16T04:49:06.096-04:002011-06-16T04:49:06.096-04:00The query made my task so easy.
ThanksThe query made my task so easy.<br />ThanksSahilnoreply@blogger.com