Expense Report Approval flow BIP Report

Summary:

Expense Report Approval flow BIP Report

Content (please ensure you mask any confidential information):

Need a query to get the approval flow for a expense report, example if a user submitted a expense report and it went for approval 2 persons approved and now its assigned/pending with 3rd approver. So report should give us 3 rows with first 2 rows will be with users who approved and 3rd with users to whom its assigned.
In our case problem is that expense report was submitted and it went through 2 approval and 2nd approver rejected it , so the user resubmitted the expense report then it went through the same scenario ( 2 approved and now assigned to 3rd). In our report its giving the 5 rows (approved , rejected , approved , approved ,assigned) . But we need only the recently resubmitted expense report approval list (we tried to take the max(transaction_id) from hrc_txn_header but its object_id join with exm_exp_rep_processing causing this problem)