If you create a view as follows
create view my_view (view_col_names) as
select tab_col_names from my_table;
then the view column names only go into COL$ and are not visible in the view
text. To find the table and column names used in the procedure, you need only
have queried the TAB and COL data dictionary views.
I'm sure I'm overlooking the obvious, but . . .
In trying to chase down an un-documented procedure written by a departed co-worker, we could not find any of the tables referenced in the procedure. We did a SELECT OWNER, TABLE_NAME, COLUMN_NAME FROM DBA_TAB_COLUMNS and examined the results for any of the column names referenced in the procedure. We found them, and the related table names were the same as referenced in the procedure, but did not show up in a query of DBA_TABLES. We finally realized that these "tables" were really views. But that raised the question of where the column names got created. The column names are not defined in the view definitions, and they do not exist in the tables referenced by the view definitions.