XLA Import Initial Balances for Supporting References

Description

Categories: BI Publisher
Columns: Application Id, App Name, Ledger Id, Ledger Name, Code Combination Id, Concatenated Segments, Analytical Criterion Code, Analytical Criterion Type Code, Ac1, Ac2 ...

Application: Subledger Accounting
Source: Import Initial Balances for Supporting References
Short Name: XLAACSUPREF
DB package: XLA_AC_BALANCES_PKG

Copy

select  xla.application_id,
        app.application_short_name app_name,
        xla.ledger_id,
        gl.name ledger_name,
        xla.code_combination_id,
        cc.concatenated_segments,
        xla.analytical_criterion_code,
        xla.analytical_criterion_type_code,
        xla.AC1,
        xla.AC2,
        xla.AC3,
        xla.AC4,
        xla.AC5,
        xla.period_name,
        xla.init_balance_dr,
        xla.init_balance_cr,
        xla.message_codes
from    xla_ac_balances_int xla,
        fnd_application app,
        gl_ledgers gl,
        gl_code_combinations_kfv cc
where   xla.status = 'ERROR'
and     xla.application_id = app.application_id(+)
and     xla.ledger_id = gl.ledger_id(+)
and     xla.code_combination_id = cc.code_combination_id(+)
and     xla.batch_code = NVL(:P_BATCH_CODE,xla.batch_code)
order by    xla.application_id,
            app.application_short_name