Need to create a report to show the details of Supplier approval History

Hi Team,

Product : Oracle Fusion Procurement --> Supplier Portal

Requirement is to create a Audit report for Suppliers, which will include the supplier approval history as well for supplier registration approval, supplier spend authorization approval and supplier profile change approval.

Question --> We are using the database table POZ_APPROVAL_HISTORY, but the APPROVAL_FLOW_CODE consists of only the code of the type of approval. Which table will consists of the exact name of approval flow type to use in my query.

As per an oracle note, they asked to use an OTBI report to achieve the Approval history, but I need to combine the approval history and audit information in the same report, because of which am going through the BI report path.