Analytics Software

Hello, we recently upgraded to release 12 and planning to implement sub ledger accounting and we are in the process of identifying our customizations written on top of distribution tables so that we can tweak them to go after SLA tables. Majority of our custom objects are discoverer reports. And most of these discoverer reports are based on custom folders which are based on custom views. By running a sql we were able to identify the names of all of our custom views which go after the distribution tables. Now we want to identify which of our discoverer reports are based on these views via custom folders of our custom business areas. Our custom folders might have been named exactly same as custom view or they may have different name and the folder may actually have a sql in which they are referring these custom views.

Would it be possible for someone to provide a sql select statement which takes database table / view name and returns the name of discoverer workbooks referring this table/view? Thanks in advance for help.

Regards,
Anjan Avula.