Query GL to AR
Mr,
I need a query to find CASH_RECEIPT_ID from a journal line. I wrote a query :
select count(jel.ledger_id)
from apps.gl_je_lines jel,
apps.gl_je_headers jeh,
apps.gl_je_batches jeb,
apps.gl_code_combinations c,
apps.gl_import_references gir,
apps.xla_ae_lines xlal,
apps.xla_ae_headers xlah,
apps.xla_events xlae,
apps.xla_distribution_links xdl,
apps.RA_CUST_TRX_LINE_GL_DIST_ALL RCT
where jel.ledger_id = 2085
AND jel.period_name IN ('NOV-12') AND jel.status = 'P'
AND jel.je_header_id = jeh.je_header_id