1. Выборка истории
select * from PERSON where ORIGINAL_PERSON_ID = 100;
2. Выборка текущих активных записей
select * from PERSON where IS_ACTIVE = 1

1. Выборка истории
select * from PERSON_AUDIT where PERSON_ID = 100;
2.
select * from PERSON;