XLA Import Initial Balances for Supporting References

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

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