How to Join ZX_LINES and XLA_AE_LINES to Get Tax Details (Rate, Amounts etc.)

Good Day Experts,

How can I join ZX_LINES and XLA_AE_LINES?

I have a custom tax report where subledger debit/credit amount (Item Expense or Revenue) is displayed then this amount will be multiplied based on the tax rate available in detail (Payables or Receivables) level as a new column.

In Subledger, the tax amount (Tax or Recoverable Tax) is available but it shows only in 1 subledger line.

The amount should split if there are multiple transactions in the amount just like the screenshot below and is the reason I need the tax rate/tax amount.

Transaction Number: XYZ123