In this instance, was it an Oracle database that your Xtraction dashboards/documents were querying against?
Yes, our SDM database is Oracle.
There is no way in the Xtraction interface to see the various queries that it creates. For debugging purposes, we use the trace file to capture the queries, but it is an encrypted file, so you won't be able to read it (and there can be a ton of information to sift through if you have a busy Xtraction server).
For MSSQL customers, I've suggested turning on SQL Profiler on the database server to capture the SQL queries as they come into the SQL server. I don't know if Oracle has the same capability.
Thanks Gregg! Our Oracle team was able to capture SQL queries, but worst case scenario is create the view from scratch.