VIEW: XLA.XLA_AE_LINES#

Source

View Text - Preformatted

select AE_HEADER_ID AE_HEADER_ID, AE_LINE_NUM AE_LINE_NUM, APPLICATION_ID APPLICATION_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, GL_TRANSFER_MODE_CODE GL_TRANSFER_MODE_CODE, GL_SL_LINK_ID GL_SL_LINK_ID, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE, PARTY_ID PARTY_ID, PARTY_SITE_ID PARTY_SITE_ID, PARTY_TYPE_CODE PARTY_TYPE_CODE, ENTERED_DR ENTERED_DR, ENTERED_CR ENTERED_CR, ACCOUNTED_DR ACCOUNTED_DR, ACCOUNTED_CR ACCOUNTED_CR, DESCRIPTION DESCRIPTION, STATISTICAL_AMOUNT STATISTICAL_AMOUNT, CURRENCY_CODE CURRENCY_CODE, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE, JGZZ_RECON_REF JGZZ_RECON_REF, CONTROL_BALANCE_FLAG CONTROL_BALANCE_FLAG, ANALYTICAL_BALANCE_FLAG ANALYTICAL_BALANCE_FLAG, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, GL_SL_LINK_TABLE GL_SL_LINK_TABLE, DISPLAYED_LINE_NUMBER DISPLAYED_LINE_NUMBER, 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, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, REQUEST_ID REQUEST_ID, UPG_BATCH_ID UPG_BATCH_ID, UPG_TAX_REFERENCE_ID1 UPG_TAX_REFERENCE_ID1, UPG_TAX_REFERENCE_ID2 UPG_TAX_REFERENCE_ID2, UPG_TAX_REFERENCE_ID3 UPG_TAX_REFERENCE_ID3, UNROUNDED_ACCOUNTED_DR UNROUNDED_ACCOUNTED_DR, UNROUNDED_ACCOUNTED_CR UNROUNDED_ACCOUNTED_CR, GAIN_OR_LOSS_FLAG GAIN_OR_LOSS_FLAG, UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_DR, UNROUNDED_ENTERED_CR UNROUNDED_ENTERED_CR, SUBSTITUTED_CCID SUBSTITUTED_CCID, BUSINESS_CLASS_CODE BUSINESS_CLASS_CODE, MPA_ACCRUAL_ENTRY_FLAG MPA_ACCRUAL_ENTRY_FLAG, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, FUNDS_STATUS_CODE FUNDS_STATUS_CODE, MERGE_CODE_COMBINATION_ID MERGE_CODE_COMBINATION_ID, MERGE_PARTY_ID MERGE_PARTY_ID, MERGE_PARTY_SITE_ID MERGE_PARTY_SITE_ID, ACCOUNTING_DATE ACCOUNTING_DATE, LEDGER_ID LEDGER_ID, SOURCE_TABLE SOURCE_TABLE, SOURCE_ID SOURCE_ID, ACCOUNT_OVERLAY_SOURCE_ID ACCOUNT_OVERLAY_SOURCE_ID from "XLA"."XLA_AE_LINES"

View Text - HTML Formatted

SELECT AE_HEADER_ID AE_HEADER_ID
, AE_LINE_NUM AE_LINE_NUM
, APPLICATION_ID APPLICATION_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, GL_TRANSFER_MODE_CODE GL_TRANSFER_MODE_CODE
, GL_SL_LINK_ID GL_SL_LINK_ID
, ACCOUNTING_CLASS_CODE ACCOUNTING_CLASS_CODE
, PARTY_ID PARTY_ID
, PARTY_SITE_ID PARTY_SITE_ID
, PARTY_TYPE_CODE PARTY_TYPE_CODE
, ENTERED_DR ENTERED_DR
, ENTERED_CR ENTERED_CR
, ACCOUNTED_DR ACCOUNTED_DR
, ACCOUNTED_CR ACCOUNTED_CR
, DESCRIPTION DESCRIPTION
, STATISTICAL_AMOUNT STATISTICAL_AMOUNT
, CURRENCY_CODE CURRENCY_CODE
, CURRENCY_CONVERSION_DATE CURRENCY_CONVERSION_DATE
, CURRENCY_CONVERSION_RATE CURRENCY_CONVERSION_RATE
, CURRENCY_CONVERSION_TYPE CURRENCY_CONVERSION_TYPE
, USSGL_TRANSACTION_CODE USSGL_TRANSACTION_CODE
, JGZZ_RECON_REF JGZZ_RECON_REF
, CONTROL_BALANCE_FLAG CONTROL_BALANCE_FLAG
, ANALYTICAL_BALANCE_FLAG ANALYTICAL_BALANCE_FLAG
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, GL_SL_LINK_TABLE GL_SL_LINK_TABLE
, DISPLAYED_LINE_NUMBER DISPLAYED_LINE_NUMBER
, 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
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, REQUEST_ID REQUEST_ID
, UPG_BATCH_ID UPG_BATCH_ID
, UPG_TAX_REFERENCE_ID1 UPG_TAX_REFERENCE_ID1
, UPG_TAX_REFERENCE_ID2 UPG_TAX_REFERENCE_ID2
, UPG_TAX_REFERENCE_ID3 UPG_TAX_REFERENCE_ID3
, UNROUNDED_ACCOUNTED_DR UNROUNDED_ACCOUNTED_DR
, UNROUNDED_ACCOUNTED_CR UNROUNDED_ACCOUNTED_CR
, GAIN_OR_LOSS_FLAG GAIN_OR_LOSS_FLAG
, UNROUNDED_ENTERED_DR UNROUNDED_ENTERED_DR
, UNROUNDED_ENTERED_CR UNROUNDED_ENTERED_CR
, SUBSTITUTED_CCID SUBSTITUTED_CCID
, BUSINESS_CLASS_CODE BUSINESS_CLASS_CODE
, MPA_ACCRUAL_ENTRY_FLAG MPA_ACCRUAL_ENTRY_FLAG
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, FUNDS_STATUS_CODE FUNDS_STATUS_CODE
, MERGE_CODE_COMBINATION_ID MERGE_CODE_COMBINATION_ID
, MERGE_PARTY_ID MERGE_PARTY_ID
, MERGE_PARTY_SITE_ID MERGE_PARTY_SITE_ID
, ACCOUNTING_DATE ACCOUNTING_DATE
, LEDGER_ID LEDGER_ID
, SOURCE_TABLE SOURCE_TABLE
, SOURCE_ID SOURCE_ID
, ACCOUNT_OVERLAY_SOURCE_ID ACCOUNT_OVERLAY_SOURCE_ID
FROM "XLA"."XLA_AE_LINES"