Travel&Expense 9.1: Delete big quantity of expense reports

Hello,

We have more than 300 expense reports with status not(approved, staged, paid,closed) without applied cash advanced, to cleanup  for our fiscal end year process.

I am looking for a query or script to run to delete those expense reports and releasing correctly the encumbrances. I am listing all the tables dependencies used by the expense report.

Your Help is most welcome.

Thank you,

Salah.