Follow us: Connect on YouTube Connect on YouTube Connect on YouTube

Pages

Friday, 6 May 2016

GL Batches Query

SELECT jb.NAME, gh.period_name, gh.je_source, gh.je_category,
       gh.currency_code, gc.concatenated_segments, gl.entered_cr,
       gl.entered_dr, gl.accounted_cr, gl.accounted_dr
  FROM gl_je_batches jb,
       gl_je_headers gh,
       gl_je_lines gl,
       gl_code_combinations_kfv gc
 WHERE jb.je_batch_id = gh.je_batch_id
   AND gh.je_header_id = gl.je_header_id
   AND gl.code_combination_id = gc.code_combination_id
  -- AND gc.segment2 IN ('491100', '781900', '794000')
   --AND jb.default_period_name = 'JAN-11'
  -- AND jb.set_of_books_id = 162
  -- AND gh.je_category = 'Labor Cost'

 --  AND gh.je_source = 'Project Accounting'
Share this article :

0 comments:

Post a Comment