Query to get the final approver of AP Invoice

Summary:

Hello,

We have a requirement to fetch only final approver details along with Invoice/Requisition in a Invoice and requisition workflow report.

Current report is fetching all the approver details. But we need Invoice details should be pulled in the report only when it is assigned for the final approver.

I checked the table AP_INV_APRVL_HIST_ALL, but in this table also I can see all the approver details and not able to differentiate a final approver.

Please let me know if anyone knows how to fetch the invoice in the report only when it is assigned for the final approver.