GL Cash Clearing Account Analysis

Description
Categories: BI Publisher
Imported from BI Publisher
Application: General Ledger
Source: GL Cash Clearing Account Analysis Report
Short Name: GLXCCAAR
DB package: GL_CASH_CLR_ACCT_ANAL_RPT_PKG
Run GL Cash Clearing Account Analysis and other Oracle EBS reports with Blitz Report™ on our demo environment
        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
Ledger
 
LOV Oracle
Accounting Flexfield
 
Char
From Period
 
LOV Oracle
To Period
 
LOV Oracle
Detail/Summary Layout
 
LOV Oracle
Blitz Report™