Jeelan test

Description
Run Jeelan test and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Parameter Name SQL text Validation
Ledger
gl.name=:ledger
LOV
Period
gjh.period_name=:period_name
LOV