Manual Source journal Query - Oracle EBS R12

http://generalledger-gl.blogspot.com/2016/01/manual-source-journal-query.html

Manual Source journal Query

select a.period_name,a.doc_sequence_value,a.je_category,a.je_source,b.accounted_dr,b.accounted_cr
from gl_je_headers a,
gl_je_lines b,
gl_code_combinations c

where a.je_header_id=b.je_header_id
and b.code_combination_id=c.code_combination_id
and c.segment4='248111100'
and a.je_source!='Payables'
and a.period_name='MAY-15'
---------------------------------------------------------------------------------------------

select sum(kk.ACCOUNTED_DR), sum(kk.ACCOUNTED_CR)
from gl_je_headers ll, gl_je_lines kk, gl_code_combinations gg

where ll.JE_HEADER_ID=kk.JE_HEADER_ID
and gg.CODE_COMBINATION_ID=kk.CODE_COMBINATION_ID
and kk.LEDGER_ID=ll.LEDGER_ID
and ll.LEDGER_ID=2021
and gg.SEGMENT4='248111100'
and ll.ACTUAL_FLAG='A'
and ll.JE_SOURCE !='Payables'