GL Account Analysis - Average Balance Audit

Description
Categories: BI Publisher
Application: General Ledger
Source: Account Analysis - Average Balance Audit (XML)
Short Name: GLXAVADT_XML
DB package: GL_GLXAVADT_XMLP_PKG
SELECT CC.code_combination_id CCID,
                null BAL_DATA,
                null FLEXDATA,
               dbal.accounting_date ACC_DATE,
               dbal.end_of_date_balance_num END_OF_DATE_BALANCE,
               decode(:P_BALANCE_TYPE, 'PATD', dbal.period_aggregate_num,
                                                                'QATD', dbal.quarter_aggregate_num,
                                                                'YATD', dbal.year_aggregate_num, 0) AGGREGATE,
               decode(:P_BALANCE_TYPE, 'PATD', dbal.period_average_to_date_num,
                                                                'QATD', dbal.quarter_average_to_date_num,
                                                                'YATD', dbal.year_average_to_date_num, 0