SQL query

Hi,

Oracle Fusion Financials.

I am looking for a pointer on which tables I would need to identify the VAT on invoices / journals transferred in to become Fixed Assets / Assets Under Construction.

i.e. to find the VAT which was transferred to the asset from the subledger in question.

Any pointers in terms of tables / views needed would be appreciated.

I started with the usual suspects; - fa_additions_b, fa_transaction_headers, fa_invoice_transactions, fa_transactions_v, fa_additions_vl, fa_asset_transfer_v, fa_invoice_transfer_v - but I am not seeing any obvious link back to the subledger source at distribution level or to the tax tables which would aid me in achieving this requirement.