Budget query in oracle apps

Budget query in oracle apps

In this post , We will be discuss about Budget query in oracle apps. This query will help to extract the budget details in oracle apps. We will get the complete details of the budget uploaded for the year in oracle apps using this budget query. This is the complete budget query in oracle apps. Please find below the detail Budget query in oracle apps.

Important table used by Budget query in oracle apps

1.gl_je_headers

     

2.gl_je_lines

     

3.fnd_user

     

4.gl_code_combinations

Detail Budget query in oracle apps

Here below is the Detail Budget query in oracle apps.

select decode(GJH.STATUS, 'P', 'Posted', 'U', 'Unposted', GJH.STATUS) Status,

     

       fu.USER_NAME User_Created,

     

       GJH.NAME,

     

       GJH.JE_SOURCE,

     

       GJH.JE_CATEGORY,

     

       GJH.PERIOD_NAME,

     

       GJH.DEFAULT_EFFECTIVE_DATE,   GCC.SEGMENT1||'.'||GCC.SEGMENT2||'.'||GCC.SEGMENT3||'.'||GCC.SEGMENT4||'.'||GCC.SEGMENT5||'.'||GCC.SEGMENT6||'.'||GCC.SEGMENT7 GL_ACCOUNT,

     

       GJL.ACCOUNTED_DR Debit,

     

       GJL.ACCOUNTED_CR Credit,

     

       GJL.DESCRIPTION

  from gl_je_headers GJH,

     

       gl_je_lines GJL,

     

       fnd_user fu,

     

       gl_code_combinations GCC

 where GJH.JE_HEADER_ID = GJL.JE_HEADER_ID

     

   and fu.USER_ID = GJH.CREATED_BY

     

   and GCC.CODE_COMBINATION_ID = GJL.CODE_COMBINATION_ID

     

   and GJH.ACTUAL_FLAG = 'B'

   and GJL.LEDGER_ID = GJH.LEDGER_ID

     

   and GJH.LEDGER_ID = GJL.LEDGER_ID

     

   and GJL.LEDGER_ID = :P_LEDGER_ID