FND_TABLES Table Name, FND_COLUMNS Column Name

If you are looking for specific column name which comes along with the table name, use the query below in Oracle: -

SELECT t.table_name , c.column_name, c.table_id FROM fnd_columns c, fnd_tables t
WHERE c.column_name = 'STOP_ID'
AND c.table_id = t.table_id

To search for the table name, you can use the query as below: -

SELECT object_name,object_type
FROM dba_objects
WHERE lower(object_name) LIKE '%countr%'
AND object_type IN ('TABLE','VIEW')