Tables and Columns Information - all_tab_columns & all_objects

all_tab_columns 

select * from all_tab_columns
where table_name = 'PO_REQUISITION_LINES_ALL'
and column_name like '%HAZARD_CLASS%';


all_objects

select * from ALL_OBJECTS
where object_name like 'PS%'
and object_type = 'TABLE'