Link Between FA and GL table using XLA tables

Query for FA and Gl Link

SELECT *
FROM
GL_JE_HEADERS GJH,
GL_JE_LINES GJL,
GL_IMPORT_REFERENCES GIR,
XLA_AE_LINES XAL,
XLA_AE_HEADERS XAH,
FA_TRANSACTION_HEADERS FTH,
FA_ADJUSTMENTS FAA
WHERE
GJH.JE_HEADER_ID=GJL.JE_HEADER_ID
AND GJH.JE_HEADER_ID=GIR.JE_HEADER_ID
AND GJL.JE_LINE_ID=GIR.JE_LINE_ID
AND GIR.GL_SL_LINK_ID=XAL.GL_SL_LINK_ID
AND XAL.AE_HEADER_ID=XAH.AE_HEADER_ID
AND XAH.EVENT_ID=FTH.EVENT_ID
AND FTH.TRANSACTION_HEADER_ID=FAA.TRANSACTION_HEADER_ID

please note for an event_id which pertains to Depreciation category, the event_id is not available in fa_transaction_headers, instead it is available in fa_deprn_summary

You have to make appropriate adjustments to the query for book type code, ledger, MRC if any etc.