Approval History - AP Invoice Account Coding Workflow Notification Customization

Summary:

We need to customize "AP Invoice Account Coding Workflow Notification" to display approval history using SQL Query.

In BPM Workflow notification we can see the approval history in UI (Navigation: BPM Worklist -> Open a notification - > Actions -> View Approvals).

The same approval information we want to display in the bottom of the notification. For this we have customized the below BIP Data Model and Template:

Data Model: Invoice Approval Data Model
Path: /shared/Custom/Financials/Workflow Notifications/Payables/Invoices/Data Models

We have used below query to fetch the approval history. But it is not fetching correct information for some of the scenarios: