How to find table name when knowing column name and column value in Oracle

A tester in my project asked me today for a little help: how to find a list of tables that has column name A with value B. So I wrote a short script and sent him. I thought I would share it here too, in case if might be useful to someone. Usually cases like this, you will query from user_tab_cols or all_tab_cols for list of tables that has a column with that name and find out.