How to get the PO number from AP Distributions in OTBI?

Summary:

We are creating an analysis using "Payables Invoices - Transactions Real Time" and when trying to get Purchase Order number from Invoice Lines, it appears blank in some cases such as for Non-Recoverable tax accounting class. So we used the PO column from AP Distributions but as per the database mapping, this column is actually the "Identifying PO" from the Invoice Header.

Distribution PO number column is not available in "Payables Invoices - Transactions Real Time"

Looking for a workaround to achieve this in OTBI. (Relevant Docs are attached explaining the issue as well)

Content (please ensure you mask any confidential information):