Journal Entries SQL

SELECT GLS.USER_JE_SOURCE_NAME,
  GLC.USER_JE_CATEGORY_NAME,
  GLH.PERIOD_NAME,
  GLL.ENTERED_DR,
  GLL.ENTERED_CR,
  GLH.CURRENCY_CODE,
  GLL.ACCOUNTED_DR,
  GLL.ACCOUNTED_CR,
  GCC.CONCATENATED_SEGMENTS,
  GLL.DESCRIPTION LINE_DESCRIPTION,
  GLB.NAME BATCH_NAME,
  GLB.DESCRIPTION,
  GLH.NAME
FROM GL_JE_BATCHES GLB,
  GL_JE_HEADERS GLH,
  GL_JE_LINES GLL,
  GL_CODE_COMBINATIONS_KFV GCC,
  GL_JE_CATEGORIES_TL GLC,
  GL_JE_SOURCES_TL GLS
WHERE GLB.JE_BATCH_ID       = GLH.JE_BATCH_ID
AND GLH.JE_HEADER_ID        = GLL.JE_HEADER_ID
AND GLL.CODE_COMBINATION_ID = GCC.CODE_COMBINATION_ID
AND GLH.JE_CATEGORY         = GLC.JE_CATEGORY_NAME
AND GLH.JE_SOURCE           = GLS.JE_SOURCE_NAME
AND GLB.NAME                = '%BATCH NAME%'