GL Cash Clearing Account Analysis

➜ Back to Library
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
Download
Related Blitz Reports
GL Account Analysis XLA Trial Balance - Manual SLA AP Amounts XLA Trial Balance - Non AP Journal Amounts FA Revaluation Reserve FA Depreciation Reserve FA CIP Cost FA Asset Cost XXFT GL Balance GL Balance by Account Hierarchy Mrugesh: GL Balance
Blitz Report™

Blitz Report™ provides multiple benefits: