eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: XLA.XLA_TRIAL_BALANCES#

Source

View Text - Preformatted


select DEFINITION_CODE DEFINITION_CODE, LEDGER_ID LEDGER_ID, RECORD_TYPE_CODE RECORD_TYPE_CODE, SOURCE_ENTITY_ID SOURCE_ENTITY_ID, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID, APPLIED_TO_ENTITY_ID APPLIED_TO_ENTITY_ID, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID, EVENT_CLASS_CODE EVENT_CLASS_CODE, GL_DATE GL_DATE, TRX_CURRENCY_CODE TRX_CURRENCY_CODE, ENTERED_ROUNDED_DR ENTERED_ROUNDED_DR, ENTERED_ROUNDED_CR ENTERED_ROUNDED_CR, ENTERED_UNROUNDED_DR ENTERED_UNROUNDED_DR, ENTERED_UNROUNDED_CR ENTERED_UNROUNDED_CR, ACCTD_ROUNDED_DR ACCTD_ROUNDED_DR, ACCTD_ROUNDED_CR ACCTD_ROUNDED_CR, ACCTD_UNROUNDED_DR ACCTD_UNROUNDED_DR, ACCTD_UNROUNDED_CR ACCTD_UNROUNDED_CR, CODE_COMBINATION_ID CODE_COMBINATION_ID, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE, NATURAL_ACCOUNT_SEGMENT_VALUE NATURAL_ACCOUNT_SEGMENT_VALUE, COST_CENTER_SEGMENT_VALUE COST_CENTER_SEGMENT_VALUE, INTERCOMPANY_SEGMENT_VALUE INTERCOMPANY_SEGMENT_VALUE, MANAGEMENT_SEGMENT_VALUE MANAGEMENT_SEGMENT_VALUE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, PARTY_TYPE_CODE PARTY_TYPE_CODE, AE_HEADER_ID AE_HEADER_ID, GENERATED_BY_CODE GENERATED_BY_CODE, SOURCE_VALUATION_METHOD SOURCE_VALUATION_METHOD, APPLIED_VALUATION_METHOD APPLIED_VALUATION_METHOD, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE from "XLA"."XLA_TRIAL_BALANCES"

View Text - HTML Formatted

SELECT DEFINITION_CODE DEFINITION_CODE
, LEDGER_ID LEDGER_ID
, RECORD_TYPE_CODE RECORD_TYPE_CODE
, SOURCE_ENTITY_ID SOURCE_ENTITY_ID
, SOURCE_APPLICATION_ID SOURCE_APPLICATION_ID
, APPLIED_TO_ENTITY_ID APPLIED_TO_ENTITY_ID
, APPLIED_TO_APPLICATION_ID APPLIED_TO_APPLICATION_ID
, EVENT_CLASS_CODE EVENT_CLASS_CODE
, GL_DATE GL_DATE
, TRX_CURRENCY_CODE TRX_CURRENCY_CODE
, ENTERED_ROUNDED_DR ENTERED_ROUNDED_DR
, ENTERED_ROUNDED_CR ENTERED_ROUNDED_CR
, ENTERED_UNROUNDED_DR ENTERED_UNROUNDED_DR
, ENTERED_UNROUNDED_CR ENTERED_UNROUNDED_CR
, ACCTD_ROUNDED_DR ACCTD_ROUNDED_DR
, ACCTD_ROUNDED_CR ACCTD_ROUNDED_CR
, ACCTD_UNROUNDED_DR ACCTD_UNROUNDED_DR
, ACCTD_UNROUNDED_CR ACCTD_UNROUNDED_CR
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BALANCING_SEGMENT_VALUE BALANCING_SEGMENT_VALUE
, NATURAL_ACCOUNT_SEGMENT_VALUE NATURAL_ACCOUNT_SEGMENT_VALUE
, COST_CENTER_SEGMENT_VALUE COST_CENTER_SEGMENT_VALUE
, INTERCOMPANY_SEGMENT_VALUE INTERCOMPANY_SEGMENT_VALUE
, MANAGEMENT_SEGMENT_VALUE MANAGEMENT_SEGMENT_VALUE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_TYPE_CODE PARTY_TYPE_CODE
, AE_HEADER_ID AE_HEADER_ID
, GENERATED_BY_CODE GENERATED_BY_CODE
, SOURCE_VALUATION_METHOD SOURCE_VALUATION_METHOD
, APPLIED_VALUATION_METHOD APPLIED_VALUATION_METHOD
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
FROM "XLA"."XLA_TRIAL_BALANCES"