About Gl Trial Balance Report Query In Oracle Apps

Asked By 60 points N/A Posted on -
qa-featured

What is gl trial balance report query in oracle apps? Please share the gl trial balance report query in detail.

SHARE
Answered By 50 points N/A #320757

About Gl Trial Balance Report Query In Oracle Apps

qa-featured

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;

Login/Register to Answer

Related Questions