select xid,operation,commit_scn,undo_sql
from flashback_transaction_query
where xid in (
select versions_xid
from emp
versions between scn minvalue and maxvalue
)
from flashback_transaction_query
where xid in (
select versions_xid
from emp
versions between scn minvalue and maxvalue
)