GL - Period Wise Transaction Summary

/* FORMATTED ON 12/1/2011 11:50:10 AM (QP5 V5.114.809.3010) */
SELECT   B.NAME BATCH_NAME,
         B.DESCRIPTION BATCH_DESCRIPTION,
         B.RUNNING_TOTAL_ACCOUNTED_DR BATCH_TOTAL_DR,
         B.RUNNING_TOTAL_ACCOUNTED_CR BATCH_TOTAL_CR,
         B.STATUS BATCH_STATUS,
         B.DEFAULT_EFFECTIVE_DATE EFFECTIVE_DATE,
         B.DEFAULT_PERIOD_NAME BATCH_PERIOD_NAME,
         B.CREATION_DATE,
         U.USER_NAME BATCH_CREATED_BY,
         H.JE_CATEGORY,
         H.JE_SOURCE,
         H.PERIOD_NAME JE_PERIOD_NAME,
         H.NAME JOURNAL_NAME,
         H.STATUS JOURNAL_STATUS,
         H.CREATION_DATE JE_CREATED_DATE,
         U1.USER_NAME JE_CREATED_BY,
         H.DESCRIPTION JE_DESCRIPTION,
         H.RUNNING_TOTAL_ACCOUNTED_DR JE_TOTAL_DR,
         H.RUNNING_TOTAL_ACCOUNTED_CR JE_TOTAL_CR,
         L.JE_LINE_NUM LINE_NUMBER,
         L.LEDGER_ID,
         GLCC.CONCATENATED_SEGMENTS ACCOUNT,
         L.ENTERED_DR,
         L.ENTERED_CR,
         L.ACCOUNTED_DR,
         L.ACCOUNTED_CR,
         XLAL.UNROUNDED_ACCOUNTED_DR XLA_UNROUNDED_ACCOUNTED_DR,
         XLAL.UNROUNDED_ACCOUNTED_CR XLA_UNROUNDED_ACCOUNTED_CR,
         L.DESCRIPTION,
         XLAL.CODE_COMBINATION_ID,
         XLAL.ACCOUNTING_CLASS_CODE,
         XLAL.ACCOUNTED_DR XLAL_ACCOUNTED_DR,
         XLAL.ACCOUNTED_CR XLAL_ACCOUNTED_CR,
         XLAL.DESCRIPTION XLAL_DESCRIPTION,
         XLAL.ACCOUNTING_DATE XLAL_ACCOUNTING_DATE,
         XLATE.ENTITY_CODE XLATE_ENTITY_CODE,
         XLATE.SOURCE_ID_INT_1 XLATE_SOURCE_ID_INT_1,
         XLATE.SOURCE_ID_INT_2 XLATE_SOURCE_ID_INT_2,
         XLATE.SOURCE_ID_INT_3 XLATE_SOURCE_ID_INT_3,
         XLATE.SECURITY_ID_INT_1 XLATE_SECURITY_ID_INT_1,
         XLATE.SECURITY_ID_INT_2 XLATE_SECURITY_ID_INT_2,
         XLATE.TRANSACTION_NUMBER XLATE_TRANSACTION_NUMBER
  FROM   GL_JE_BATCHES B,
         GL_JE_HEADERS H,
         GL_JE_LINES L,
         FND_USER U,
         FND_USER U1,
         GL_CODE_COMBINATIONS_KFV GLCC,
         GL_IMPORT_REFERENCES GIR,
         XLA_AE_LINES XLAL,
         XLA_AE_HEADERS XLAH,
         XLA_EVENTS XLAE,
         XLA.XLA_TRANSACTION_ENTITIES XLATE
 -- , RCV_TRANSACTIONS RCVT
 WHERE       B.CREATED_BY = U.USER_ID
         AND H.CREATED_BY = U1.USER_ID
         AND B.JE_BATCH_ID = H.JE_BATCH_ID
         AND H.JE_HEADER_ID = L.JE_HEADER_ID
         AND XLAL.CODE_COMBINATION_ID = GLCC.CODE_COMBINATION_ID
         AND L.JE_HEADER_ID = GIR.JE_HEADER_ID
         AND L.JE_LINE_NUM = GIR.JE_LINE_NUM
         AND GIR.GL_SL_LINK_TABLE = XLAL.GL_SL_LINK_TABLE
         AND GIR.GL_SL_LINK_ID = XLAL.GL_SL_LINK_ID
         AND XLAL.AE_HEADER_ID = XLAH.AE_HEADER_ID
         AND XLAH.EVENT_ID = XLAE.EVENT_ID
         AND XLAE.ENTITY_ID = XLATE.ENTITY_ID
         AND XLAE.APPLICATION_ID = XLATE.APPLICATION_ID
         -- AND XLATE.SOURCE_ID_INT_1 = RCVT.TRANSACTION_ID
         AND H.JE_SOURCE = 'Receivables'
         AND H.PERIOD_NAME = 'JUN-11'  --'&PERIOD_NAME'