1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

R12- General Ledger- Journal Queries

Discussion in 'Oracle Apps Technical' started by Ramji, Feb 9, 2012.

  1. Ramji

    Ramji Forum Guru

    Messages:
    525
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Simple queries to retrieve Journal Info

    1.
    Select *
    from gl_je_batches
    where name = '&batch_name';

    2.
    Select *
    from gl_je_headers
    where je_batch_id = &je_batch_id; -- returned in script a


    3.
    Select *
    from gl_je_lines
    where je_header_id = &je_header_id; -- all returned in script b

    4 .
    SELECT kfv.concatenated_segments, gjl.*
    FROM gl_je_lines gjl, gl_code_combinations_kfv kfv
    WHERE gjl.code_combination_id = kfv.code_combination_id
    AND gjl.je_header_id IN
    (SELECT DISTINCT je_header_id
    FROM gl_je_headers
    WHERE je_batch_id = &JE_BATCH_ID);