GL Account Inquiry Query for Payables Reconciliation - Oracle EBS R12

http://generalledger-gl.blogspot.com/2016/01/gl-account-inquiry-query-for-payables.html

GL Account Inquiry Query for Payables Reconciliation

ON PKR CURRENCY & ENTRED DR/CR

select
--H.JE_CATEGORY,H.JE_SOURCE,
--h.je_header_id, h.name,
L.EFFECTIVE_DATE,
--L.ENTERED_DR, L.ENTERED_CR, (nvl(L.ENTERED_DR,0) - nvl(L.ENTERED_CR,0)) BAL
SUM(L.ENTERED_DR) DR, SUM(L.ENTERED_CR) CR, SUM(nvl(L.ENTERED_DR,0) - nvl(L.ENTERED_CR,0)) BAL
from
gl_je_headers h,
gl_je_lines l,
gl_code_combinations gcc
where 1=1
and h.je_header_id=l.je_header_id
and l.code_combination_id=gcc.code_combination_id
--and h.default_effective_date<='31-OCT-15'
--and h.period_name='OCT-15'
AND L.EFFECTIVE_DATE BETWEEN '01-OCT-15' AND '31-OCT-15'
--and h.je_category='Purchase Invoices'
and gcc.segment4='?'
AND H.CURRENCY_CODE='PKR'
AND H.LEDGER_ID=?
and H.STATUS='P'
and H.Actual_flag='A'
--AND H.JE_SOURCE='Payables'
--AND H.JE_CATEGORY='Purchase Invoices'
GROUP BY L.EFFECTIVE_DATE
--GROUP BY H.JE_CATEGORY,H.JE_SOURCE
ORDER BY L.EFFECTIVE_DATE