XLA Trial Balance - Raw Data
Description
Run
XLA Trial Balance - Raw Data and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Report Definition |
|
LOV | |
As of Date |
|
Date |