GL Cash Clearing Account Analysis

Description
Categories: BI Publisher
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)