====== The archivelog files containing requested SCN ======

  select THREAD#,sequence# from v$archived_log where &scn between FIRST_CHANGE# and NEXT_CHANGE#-1;
  
  
Source link.[[https://www.dba-scripts.com/scripts/administration/archivelog-containing-scn/]]