Ledger Open Balance Script

select gl.name ledgername,
gjb.name “Journal Batch Name”,
gjh.name “Journal Name”,
gjh.je_source “Journal Source”,
gjh.je_category “Journal Category Name”,
gcc.concatenated_segments accountdisplayvalue,
SUM(NVL(GJL.ACCOUNTED_DR,0)) DebitAmount,
SUM(NVL(GJL.ACCOUNTED_CR,0)) CreditAmount,
SUM(NVL(GJL.ACCOUNTED_DR,0)-NVL(GJL.ACCOUNTED_CR,0)) BALANCE,
gl.currency_code currencycode,gjh.posted_date transdate,gjh.default_effective_Date,gjh.period_name
from gl_je_headers gjh,
gl_je_lines gjl,
gl_ledgers gl,
gl_code_combinations_kfv gcc,
GL_JE_BATCHES GJB
where 1=1
and gjh.ledger_id =:p_Ledger_id — pass ledger id from gl_ledgers
and gjl.je_header_id = gjh.je_header_id
and gjh.status=’P’ — P FOR POSTER JOURNALS — U FOR UNOSTED JOURNALS—
AND gjh.period_name=:p_Period — pass exact period name say ‘JUN-21’
–AND GL.name=’ISE_LEDGER ‘
AND gjh.je_batch_id=gjb.je_batch_id
and gjh.ledger_id=gl.ledger_id
and gjl.code_combination_id=gcc.code_combination_id
AND gjh.actual_flag=’A’
GROUP BY
gjh.je_category ,
gjh.je_source ,
gjb.name,
gl.name,
gjh.name,
gl.currency_code,
gcc.concatenated_segments,
gjh.posted_Date,
gjh.default_effective_Date,gjh.period_name