About Gl Trial Balance Report Query In Oracle Apps

About Gl Trial Balance Report Query In Oracle Apps

It gives you detail for balance for each code combination with journal, category, batch name and source details.

gl trial balance report query in oracle apps-

select

gjh.name Journal_name,

gjh.je_category category_name,

gjh.je_source sorce_name,

gib.name batch_name,

GCC.SEGMENT1, –company

GCC.SEGMENT2, –cost center

GCC.SEGMENT3, — account

GCC.SEGMENT4, –project

GCC.SEGMENT5, –product

GCC.SEGMENT6, –others

SUM(NVL(GJL.ACCOUNTED_DR,0))ACCOUNTED_DR,

SUM(NVL(GJL.ACCOUNTED_CR,0))ACCOUNTED_CR,

SUM(NVL(GJL.ACCOUNTED_DR,0)-

NVL(GJL.ACCOUNTED_CR,0))BALANCE

From gl_je_header gjh,

gl_je_lines gjl,

gl_ledger gl,

gl_code_combinations gcc,

GL_JE _BATCHES GJB

where gjl.je_header_id = gjh.je_header_id

AND gjh.je_batch_id=gjb.je_batch_id

and

gjl.code_combination_id=gcc.code1_combination_id

and gjh.ledger_id=gl.ledger_id

and gjh.status=’P’

AND gjh.actual_flag=’A’

Budget

AND gjh.period_name=’MAY-2019’

AND GL.name=’US Vision Operation’

Organization

GROUP BY

GCC.STATEMENT1,

GCC.STATEMENT2,

GCC.STATEMENT3,

GCC.STATEMENT4,

GCC.STATEMENT5,

GCC.STATEMENT6,

GCC.STATEMENT7,

gjh.je_category,

gjh.je_source,

gjb.name,

gjh.name;