Query to know Specific Journal Entry is Unposted or Posted

Query to know Specific Journal Entry is Unposted or Posted, askhareesh blog for oracle apps

select   b.je_batch_id  batchid ,
            h.je_header_id  headerid ,
            l.je_line_num  lineno ,
            l.code_combination_id  ccid ,
            g.segment1 || '.' || g.segment2 || '.' || g.segment3 ||
            '.' || g.segment4 || '.' || g.segment5 || '.' || g.segment6 ||
            '.' || g.segment7 || '.' || g.segment8 || '.' || g.segment9 ||
            '.' || g.segment10 combination ,
            l.entered_dr    entered_dr,
            l.entered_cr    entered_cr,
            l.accounted_dr  accounted_dr,
            l.accounted_cr  accounted_cr,
            l.status
from     gl_je_lines l,
            gl_je_headers h,
            gl_je_batches b,
            gl_code_combinations g
where   h.je_header_id = l.je_header_id
and       b.je_batch_id = h.je_batch_id
and       h.je_header_id = &je_header_id
and       l.code_combination_id = g.code_combination_id
order by h.je_header_id, l.je_line_num;



*/

1 comment:

  1. You might not buy, sell, or trade Virtual Goods outdoors the Services. Doing so is a violation of this Agreement and will end in termination of your account with the Services and/or authorized motion. Get free stuff, recreation bulletins, and all the 1xbet latest information from the myVEGAS Slots team if you follow us on social media. "Woman sues Isle after she's denied $42 million from slot malfunction". Category A games have been outlined in preparation for the planned "Super Casinos".

    ReplyDelete