QTD Balance Query in oracle apps

QTD Balance Query in oracle apps

Hi Friends, We are going to discuss about QTD Balance Query in oracle apps. This sql query will help to extract the QTD GL Balances in oracle apps. This is one of the important SQL query in Oracle Apps. We need this type of SLQ queries , if we are doing PTD, QTD and YTD financial reconciliations. This SQL query will help to extract the complete QTD balances details in oracle apps. We will be also share the important tables helps to prepare the qtd balance query. Please find below the detail about QTD Balance Query in oracle apps.

QTD Balance Query in oracle apps

5 Important Table used by QTD Balance Query

1,gl_balances

2.gl_ledgers

3.gl_code_combinations_kfv

4.FND_FLEX_VALUES_VL

5.gl_ledgers

Detail Level QTD Balance Query in oracle apps

Here below is the detail sql query helps to extract the GL QTD balances in Oracle Apps,

SELECT   

        gl.name,

        gb.LEDGER_ID,

gcc.segment1|| '-'|| gcc.segment2|| '-'|| gcc.segment3|| '-'|| gcc.segment4|| '-'|| gcc.segment5 "GL ACCOUNT",

        gcc.SEGMENT3 "Natural Account",

         FFV.DESCRIPTION "Natural Account Desc",

         gb.PERIOD_NAME,

         NVL (gb.PERIOD_NET_DR, 0) - NVL (gb.PERIOD_NET_CR, 0) PTD,

         (NVL (gb.BEGIN_BALANCE_DR, 0) - NVL (gb.BEGIN_BALANCE_CR, 0))

         + (NVL (gb.PERIOD_NET_DR, 0) - NVL (gb.PERIOD_NET_CR, 0)) YTD

    FROM  gl_balances gb,

          gl_ledgers gl,

          gl_code_combinations_kfv gcc,

          APPS.FND_FLEX_VALUES_VL FFV,

          gl_ledgers gl

   WHERE  gb.code_combination_id = gcc.code_combination_id

      AND gb.LEDGER_ID = gl.ledger_id

      AND gcc.SEGMENT3 = FFV.FLEX_VALUE

      AND gl.name ='LEDGER NAME'

      AND gb.period_name ='OCT-18-19'

ORDER BY  gb.LEDGER_ID,

gcc.segment1|| '-'|| gcc.segment2|| '-'|| gcc.segment3|| '-'|| gcc.segment4|| '-'|| gcc.segment5

QTD Balance Query in oracle apps

QTD Balance Query in oracle apps