XLA Trial Balance - Raw Data

select
xtb.definition_code,
gl.name                      ledger,
gcck.concatenated_segments   account_segments,
xtb.balancing_segment_value,
xtb.natural_account_segment_value,
xtb.cost_center_segment_value,
xtb.intercompany_segment_value,
xtb.management_segment_value,
fav.application_name         source_application,
fav2.application_name        applied_to_application,
xtb.gl_date,
xtb.record_type_code,
xtb.event_class_code,
xtb.generated_by_code,
xtb.trx_currency_code,
xtb.entered_rounded_dr,
xtb.entered_rounded_cr,
nvl(entered_rounded_cr,0) - nvl(entered_rounded_dr,0)     entered_rounded_net,
xtb.entered_unrounded_dr,
xtb.entered_unrounded_cr,
nvl(entered_unrounded_cr,0) - nvl(entered_unrounded_dr,0) entered_unrounded_net,
xtb.acctd_rounded_dr,
xtb.acctd_rounded_cr,
nvl(acctd_rounded_cr,0) - nvl(acctd_rounded_dr,0)         acctd_rounded_net,
xtb.acctd_unrounded_dr,
xtb.acctd_unrounded_cr,
nvl(acctd_unrounded_cr,0) - nvl(acctd_unrounded_dr,0)     acctd_unrounded_net,
--
xtb.source_entity_id,
xtb.source_application_id,
xtb.applied_to_entity_id,
xtb.applied_to_application_id,
xtb.party_id,
xtb.party_site_id,
xtb.party_type_code,
xtb.ae_header_id,
xtb.source_valuation_method,
xtb.applied_valuation_method,
xtb.code_combination_id,
xtb.creation_date,
xtb.created_by,
xtb.last_update_date,
xtb.last_updated_by,
xtb.last_update_login,
xtb.request_id,
xtb.program_application_id,
xtb.program_id,
xtb.program_update_date
from
 xla_trial_balances xtb,
 gl_code_combinations_kfv gcck,
 gl_ledgers gl,
 fnd_application_vl fav,
 fnd_application_vl fav2
where
 gcck.code_combination_id (+) = xtb.code_combination_id and
 gl.ledger_id (+) = xtb.ledger_id and
 fav.application_id (+) = xtb.source_application_id and
 fav2.application_id (+) = xtb.applied_to_application_id and
 xtb.definition_code = :p_definition_code and
 xtb.gl_date <= trunc(:p_as_of_date) and
 1=1
order by
 xtb.definition_code,
 gl.name,
 gcck.concatenated_segments,
 xtb.balancing_segment_value,
 xtb.natural_account_segment_value,
 xtb.cost_center_segment_value,
 xtb.gl_date