Mapping tables with sequences & triggers

 Mapping tables with sequences & triggers

select tabs.owner,tabs.table_name,

  trigs.trigger_name,

  seqs.sequence_name

from all_tables tabs

join all_triggers trigs

  on trigs.table_owner = tabs.owner

  and trigs.table_name = tabs.table_name

join all_dependencies deps

  on deps.owner = trigs.owner

  and deps.name = trigs.trigger_name

join all_sequences seqs

  on seqs.sequence_owner = deps.referenced_owner

  and seqs.sequence_name = deps.referenced_name

where tabs.owner not in  ('SYS','SYSTEM', 'DBSNMP','SYSMAN','OUTLN','MDSYS','ORDSYS','EXFSYS','DMSYS','WMSYS','CTXSYS','ANONYMOUS','XDB','ORDPLUGINS','OLAPSYS','PUBLIC','RDSADMIN');