Let me check my understanding of your business requirements, is the idea to get a list of the tables that include a particular column name?

Like... select table_name, column_name from user_tab_columns where column_name = 'whatever-column-name';