check_seq.sql

 select unique
        a.sequence_name seq, 
        substr(b.table_name,1,25) tab, 
        substr(b.column_name,1,15) col, 
        a.last_number cur_val
 from   user_sequences a,
        user_ind_columns b
 where  a.sequence_name like 'SEQ_%'
 and    b.column_position = 1
 and    a.sequence_name = 'SEQ_'||b.column_name;