Thursday 18 May 2017

Link Between FA and GL table using XLA tables

/* Formatted on 5/18/2017 4:39:48 PM (QP5 v5.114.809.3010) */
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

1 comment: