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/