ERPstuff - Oracle EBS Community

source is payables and entry is posted to gl in summary .
we need the detail data of particular month in exce sheet for which source is payable how it is possible kindly help

Hello.

See if this query has enough info for you:

SELECT h.name,
l.effective_date,
l.accounted_dr,
l.accounted_cr,
l.description,
l.reference_1,
l.reference_3,
l.reference_4
FROM gl_je_lines l,
gl_je_headers h
WHERE l.je_header_id = h.je_header_id
AND h.period_name = '<your period name>'
AND h.set_of_books_id = <your set_of_books_id>
AND h.je_source = 'Payables'


Hope this helps.
Octavio