Jeelan test

select
gl.name ledger,
gjh.period_name,
gjh.name journal_name,
gjh.description journal_description,
gjh.je_source,
gjh.je_category,
gjl.effective_date line_effective_date,
gjl.entered_dr,
gjl.entered_cr,
nvl(gjl.entered_dr,0)-nvl(gjl.entered_cr,0) entered_amount,
gjl.accounted_dr,
gjl.accounted_cr,
nvl(gjl.accounted_dr,0)-nvl(gjl.accounted_cr,0) accounted_amount
from
gl_ledgers gl,
gl_je_headers gjh,
gl_je_lines gjl
where
1=1 and
gl.ledger_id=gjl.ledger_id and
gjh.je_header_id=gjl.je_header_id

select gl.name ledger, gjh.period_name, gjh.name journal_name, gjh.description journal_description, gjh.je_source, gjh.je_category, gjl.effective_date line_effective_date, gjl.entered_dr, gjl.entered_cr, nvl(gjl.entered_dr,0)-nvl(gjl.entered_cr,0) entered_amount, gjl.accounted_dr, gjl.accounted_cr, nvl(gjl.accounted_dr,0)-nvl(gjl.accounted_cr,0) accounted_amount from gl_ledgers gl, gl_je_headers gjh, gl_je_lines gjl where 1=1 and gl.ledger_id=gjl.ledger_id and gjh.je_header_id=gjl.je_header_id