Query to get GL batch, Journal related important column details.

SELECT
GJH.name Journal_Name,
GJB.name Batch_name,
GJL.ACCOUNTED_CR,
GJL.ACCOUNTED_DR,
gcc.CONCATENATED_SEGMENTS,
GJH.CREATED_BY,
gjc.JE_CATEGORY_NAME,
gl.NAME,
GJH.CURRENCY_CODE,
GJL.DESCRIPTION,
GJB.STATUS
FROM apps.GL_JE_HEADERS GJH,
apps.GL_JE_LINES GJL,
apps.GL_JE_BATCHES GJB,
apps.GL_JE_CATEGORIES gjc,
apps.gl_ledgers gl,
apps.gl_code_combinations_kfv gcc
WHERE GJH.JE_HEADER_ID=GJL.JE_HEADER_ID
AND GJB.JE_BATCH_ID=GJH.JE_BATCH_ID
and gcc.CODE_COMBINATION_ID=GJL.CODE_COMBINATION_ID
and gjc.JE_CATEGORY_NAME=GJH.JE_CATEGORY
and gl.LEDGER_ID=GJH.LEDGER_ID
AND GJB.NAME LIKE 'GLbatchName%'
and gjh.name like 'JournalHeaderName';