Receivables - EBS (MOSC)

MOSC Banner

Query GL to AR

edited Oct 29, 2013 1:58AM in Receivables - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center