title: Find what tables/columns a global temporary table pulls data from in Oracle
body: <p>I'm trying to find out where a temporary table in Oracle is pulling data from. This database is connected to a CMS.  It is my understanding that when a report is ran in the CMS Oracle creates a temporary table to generate the report.  In Oracle SQL developer I can find the table (empty) and view the column names. However, when I look at the sql that generates the data it just has column specification like "column_name number (9,0)". When I look at dependencies the name and referenced_name are the same, and the type is a synonym. I'm fairly new to the Oracle SQL Developer environment. </p>
  
  <p>My goal is to use data from the report that is generated from the table, but I don't know where the data is coming from, nor do I know what the columns are called since a third party created these tables and I currently don't have access to the table definitions.  </p>
  
  <p>Any help would be much appreciated.  If I need to clarify something just let me know.  Thanks</p>