ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN CAD4A5E834A72604E0530100007FE3C2Y 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 SQLAP #,##0.00 US XLA Trial Balance - Raw Data xla_trial_balances - Raw Data XLA Trial Balance Analysis 1=1 :p_as_of_date :p_definition_code 1 20 :p_definition_code LOV custom Y select xtdv.definition_code value, xtdv.name description from xla_tb_definitions_vl xtdv where xtdv.enabled_flag='Y' and exists (select null from xla_trial_balances xtb where xtb.definition_code = xtdv.definition_code) order by xtdv.definition_code Y AR تعريف التقرير D Auswertungsdefinition F Définition de l'état US Report Definition ZHS 报表定义 2 30 :p_as_of_date Date Y US As of Date 9FF47D0071D1F8406E2AD9D62DD4BCFD Pivot: Default Template DEVELOPER 3 ACCOUNT_SEGMENTS 23 ACCTD_ROUNDED_CR 22 ACCTD_ROUNDED_DR 24 ACCTD_ROUNDED_NET 26 ACCTD_UNROUNDED_CR 25 ACCTD_UNROUNDED_DR 27 ACCTD_UNROUNDED_NET 35 AE_HEADER_ID 10 APPLIED_TO_APPLICATION 31 APPLIED_TO_APPLICATION_ID 30 APPLIED_TO_ENTITY_ID 37 APPLIED_VALUATION_METHOD 4 BALANCING_SEGMENT_VALUE 38 CODE_COMBINATION_ID 6 COST_CENTER_SEGMENT_VALUE 40 CREATED_BY 39 CREATION_DATE 1 DEFINITION_CODE 17 ENTERED_ROUNDED_CR 16 ENTERED_ROUNDED_DR 18 ENTERED_ROUNDED_NET 20 ENTERED_UNROUNDED_CR 19 ENTERED_UNROUNDED_DR 21 ENTERED_UNROUNDED_NET 13 EVENT_CLASS_CODE 14 GENERATED_BY_CODE 11 GL_DATE 7 INTERCOMPANY_SEGMENT_VALUE 42 LAST_UPDATED_BY 41 LAST_UPDATE_DATE 43 LAST_UPDATE_LOGIN 2 LEDGER 8 MANAGEMENT_SEGMENT_VALUE 5 NATURAL_ACCOUNT_SEGMENT_VALUE 32 PARTY_ID 33 PARTY_SITE_ID 34 PARTY_TYPE_CODE 45 PROGRAM_APPLICATION_ID 46 PROGRAM_ID 47 PROGRAM_UPDATE_DATE 12 RECORD_TYPE_CODE 44 REQUEST_ID 9 SOURCE_APPLICATION 29 SOURCE_APPLICATION_ID 28 SOURCE_ENTITY_ID 36 SOURCE_VALUATION_METHOD 15 TRX_CURRENCY_CODE ACCOUNT_SEGMENTS ROW 3 ACCTD_ROUNDED_CR VALUE 8 SUM ACCTD_ROUNDED_DR VALUE 7 SUM ACCTD_ROUNDED_NET VALUE 9 SUM ACCTD_UNROUNDED_CR VALUE 11 SUM ACCTD_UNROUNDED_DR VALUE 10 SUM ACCTD_UNROUNDED_NET VALUE 12 SUM APPLIED_TO_APPLICATION ROW 5 DEFINITION_CODE ROW 1 ENTERED_ROUNDED_CR VALUE 2 SUM ENTERED_ROUNDED_DR VALUE 1 SUM ENTERED_ROUNDED_NET VALUE 3 SUM ENTERED_UNROUNDED_CR VALUE 5 SUM ENTERED_UNROUNDED_DR VALUE 4 SUM ENTERED_UNROUNDED_NET VALUE 6 SUM LEDGER ROW 2 SOURCE_APPLICATION ROW 4 S Site 9FF47D0071D1F8406E2AD9D62DD4BCFD