GL Cash Clearing Account Analysis

Description
Categories: BI Publisher, Financials
Application: General Ledger
Source: GL Cash Clearing Account Analysis Report
Short Name: GLXCCAAR
DB package: GL_CASH_CLR_ACCT_ANAL_RPT_PKG
        SELECT 
                MAX (DECODE (gb.period_name,:period_from_param, NVL (gb.begin_balance_dr, 0),0)) BEGIN_BALANCE_DR
               ,MAX (DECODE (gb.period_name,:period_from_param, NVL (gb.begin_balance_cr, 0),0)) BEGIN_BALANCE_CR
               ,MAX (DECODE (gb.period_name,:period_to_param, NVL (gb.begin_balance_dr, 0)
                                                                  +NVL (gb.period_net_dr, 0),0)) END_BALANCE_DR
               ,MAX (DECODE (gb.period_name,:period_to_param, NVL (gb.begin_balance_cr, 0)
                                                                 + NVL (gb.period_net_cr, 0),0)) END_BALANCE_CR
               ,MAX(gcc.code_combination_id) CCID													 
        FROM    gl_balances          gb
               ,gl_code_combinations gcc
        WHERE  gb.ledger_id = :ledger_id_param
        AND    gb.code_combination_id = :ccid_param
        AND    gb.period_name IN (:period_from_param, :period_to_param)
        AND    gb.currency_code =(
                                  SELECT currency_code
                                  FROM gl_ledgers
                                  WHERE ledger_id = :ledger_id_param
                                 )
        AND   gb.actual_flag = 'A'
        AND   gcc.code_combination_id = gb.code_combination_id
        AND   &GC_ACCESS_WHERE
Parameter Name SQL text Validation
Code Combination
 
Chart Of Accounts ID
 
Number
Access Set ID
 
Detail/Summary Layout
 
LOV Oracle
To Period
 
LOV Oracle
From Period
 
LOV Oracle
Accounting Flexfield
 
Ledger
 
LOV Oracle