Query to find AR Receivables for the Category "CREDIT MEMOS" posted to GL Done in Sona

SELECT DISTINCT
               a.je_category,
               a.je_source,
               a.creation_date,
               a.running_total_cr,
               a.running_total_dr
FROM    gl_je_headers a,
               gl_je_batches_v b
WHERE  a.je_source='Receivables'
AND        a.status='P'
AND        a.je_category='Credit Memos'
AND        a.creation_date BETWEEN '1-AUG-11' AND '31-AUG-11'
AND        b.org_id=246
order by creation_date