Select table_name, owner from all_tab_columns where column_name like
'MANUFACTURER_NAME'

However you need to know what you are looking for that is the column name,
it has to be very close to the column name of the table. In this case for
supplier you may be looking for the vendor which is found in the
po.po_vendors table.

Don't we need to use '%' in our search string when using a like clause.
Otherwise, doesn't the like become an equal? If no column s found that
exactly matches 'MANUFACTURER_NAME', you will get no hits.
If the select is formatted as follows:

Select table_name,
owner
from all_tab_columns
where column_name like '%MANUFACTURER_NAME%'

the query will return all tables/owners that have a column name that
"contains" MANUFACTURER_NAME" somewhere in its name.