How to restore deleted batch from audit trail shadow tables
I am writing a PL/SQL script to restore a deleted batch and its header and lines from the Audit Trail shadow tables. The problem I have is in retrieving the lines because if I deleted certain lines during the creation of the journal batch, these deleted lines were saved in the GL_JE_LINES_A table with a AUDIT_TRANSACTION_TYPE of 'D' , a AUDIT_TIMESTAMP and a AUDIT_SESSION_ID. But during the final deletion of the batch, all the remaing journal lines are also saved in the GL_JE_LINES_A table with a AUDIT_TRANSACTION_TYPE of 'D', a AUDIT_TIMESTAMP and a AUDIT_SESSION_ID. How can I distinguish the lines deleted earlier from the one
0