Join between xla and fa tables

Join between xla and fa tables

Here we will be discuss about SQL join between xla and fa tables . We all know that Data from All modules dumps in to the GL module through xla , so each module should have the link between the XLA too. If I will talk about SQL query , then to find out the transactions detail from FA to GL we need to have SQL join between xla and the fa tables to build this sql query. Here below is the List of Join between xla and fa tables.

 

 

 

2 Important Join between xla and fa tables

 

XLA_AE_HEADERS   ==> EVENT_ID

 

FA_TRANSACTION_HEADERS  ==> EVENT_ID

 

 

SQL Query Using Join between xla and fa tables

 

SELECT *
 FROM
 FA_TRANSACTION_HEADERS FTT,
 FA_ADJUSTMENTS FA,

 FA_ADDITIONS FAA,
 GL_JE_HEADERS GJH,
 GL_JE_LINES GJL,
 GL_IMPORT_REFERENCES GIR,
 XLA_AE_LINES XAL,
 XLA_AE_HEADERS XAH
 WHERE
 AND XAH.EVENT_ID=FTT.EVENT_ID
 AND FTT.TRANSACTION_HEADER_ID=FA.TRANSACTION_HEADER_ID
 AND 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  FTT.ASSET_ID = FAA.ASSET_ID