VIEW: XLA.XLA_AE_HEADERS#

Source

View Text - Preformatted

select AE_HEADER_ID AE_HEADER_ID, APPLICATION_ID APPLICATION_ID, LEDGER_ID LEDGER_ID, ENTITY_ID ENTITY_ID, EVENT_ID EVENT_ID, EVENT_TYPE_CODE EVENT_TYPE_CODE, ACCOUNTING_DATE ACCOUNTING_DATE, GL_TRANSFER_STATUS_CODE GL_TRANSFER_STATUS_CODE, GL_TRANSFER_DATE GL_TRANSFER_DATE, JE_CATEGORY_NAME JE_CATEGORY_NAME, ACCOUNTING_ENTRY_STATUS_CODE ACCOUNTING_ENTRY_STATUS_CODE, ACCOUNTING_ENTRY_TYPE_CODE ACCOUNTING_ENTRY_TYPE_CODE, AMB_CONTEXT_CODE AMB_CONTEXT_CODE, PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE, PRODUCT_RULE_CODE PRODUCT_RULE_CODE, PRODUCT_RULE_VERSION PRODUCT_RULE_VERSION, DESCRIPTION DESCRIPTION, DOC_SEQUENCE_ID DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE, ACCOUNTING_BATCH_ID ACCOUNTING_BATCH_ID, COMPLETION_ACCT_SEQ_VERSION_ID COMPLETION_ACCT_SEQ_VERSION_ID, CLOSE_ACCT_SEQ_VERSION_ID CLOSE_ACCT_SEQ_VERSION_ID, COMPLETION_ACCT_SEQ_VALUE COMPLETION_ACCT_SEQ_VALUE, CLOSE_ACCT_SEQ_VALUE CLOSE_ACCT_SEQ_VALUE, BUDGET_VERSION_ID BUDGET_VERSION_ID, FUNDS_STATUS_CODE FUNDS_STATUS_CODE, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID, BALANCE_TYPE_CODE BALANCE_TYPE_CODE, REFERENCE_DATE REFERENCE_DATE, COMPLETED_DATE COMPLETED_DATE, PERIOD_NAME PERIOD_NAME, PACKET_ID PACKET_ID, COMPLETION_ACCT_SEQ_ASSIGN_ID COMPLETION_ACCT_SEQ_ASSIGN_ID, CLOSE_ACCT_SEQ_ASSIGN_ID CLOSE_ACCT_SEQ_ASSIGN_ID, DOC_CATEGORY_CODE DOC_CATEGORY_CODE, 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, GROUP_ID GROUP_ID, DOC_SEQUENCE_VERSION_ID DOC_SEQUENCE_VERSION_ID, DOC_SEQUENCE_ASSIGN_ID DOC_SEQUENCE_ASSIGN_ID, 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_SOURCE_APPLICATION_ID UPG_SOURCE_APPLICATION_ID, UPG_VALID_FLAG UPG_VALID_FLAG, ZERO_AMOUNT_FLAG ZERO_AMOUNT_FLAG, PARENT_AE_HEADER_ID PARENT_AE_HEADER_ID, PARENT_AE_LINE_NUM PARENT_AE_LINE_NUM, ACCRUAL_REVERSAL_FLAG ACCRUAL_REVERSAL_FLAG, MERGE_EVENT_ID MERGE_EVENT_ID, NEED_BAL_FLAG NEED_BAL_FLAG from "XLA"."XLA_AE_HEADERS"

View Text - HTML Formatted

SELECT AE_HEADER_ID AE_HEADER_ID
, APPLICATION_ID APPLICATION_ID
, LEDGER_ID LEDGER_ID
, ENTITY_ID ENTITY_ID
, EVENT_ID EVENT_ID
, EVENT_TYPE_CODE EVENT_TYPE_CODE
, ACCOUNTING_DATE ACCOUNTING_DATE
, GL_TRANSFER_STATUS_CODE GL_TRANSFER_STATUS_CODE
, GL_TRANSFER_DATE GL_TRANSFER_DATE
, JE_CATEGORY_NAME JE_CATEGORY_NAME
, ACCOUNTING_ENTRY_STATUS_CODE ACCOUNTING_ENTRY_STATUS_CODE
, ACCOUNTING_ENTRY_TYPE_CODE ACCOUNTING_ENTRY_TYPE_CODE
, AMB_CONTEXT_CODE AMB_CONTEXT_CODE
, PRODUCT_RULE_TYPE_CODE PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_CODE PRODUCT_RULE_CODE
, PRODUCT_RULE_VERSION PRODUCT_RULE_VERSION
, DESCRIPTION DESCRIPTION
, DOC_SEQUENCE_ID DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE DOC_SEQUENCE_VALUE
, ACCOUNTING_BATCH_ID ACCOUNTING_BATCH_ID
, COMPLETION_ACCT_SEQ_VERSION_ID COMPLETION_ACCT_SEQ_VERSION_ID
, CLOSE_ACCT_SEQ_VERSION_ID CLOSE_ACCT_SEQ_VERSION_ID
, COMPLETION_ACCT_SEQ_VALUE COMPLETION_ACCT_SEQ_VALUE
, CLOSE_ACCT_SEQ_VALUE CLOSE_ACCT_SEQ_VALUE
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, FUNDS_STATUS_CODE FUNDS_STATUS_CODE
, ENCUMBRANCE_TYPE_ID ENCUMBRANCE_TYPE_ID
, BALANCE_TYPE_CODE BALANCE_TYPE_CODE
, REFERENCE_DATE REFERENCE_DATE
, COMPLETED_DATE COMPLETED_DATE
, PERIOD_NAME PERIOD_NAME
, PACKET_ID PACKET_ID
, COMPLETION_ACCT_SEQ_ASSIGN_ID COMPLETION_ACCT_SEQ_ASSIGN_ID
, CLOSE_ACCT_SEQ_ASSIGN_ID CLOSE_ACCT_SEQ_ASSIGN_ID
, DOC_CATEGORY_CODE DOC_CATEGORY_CODE
, 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
, GROUP_ID GROUP_ID
, DOC_SEQUENCE_VERSION_ID DOC_SEQUENCE_VERSION_ID
, DOC_SEQUENCE_ASSIGN_ID DOC_SEQUENCE_ASSIGN_ID
, 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_SOURCE_APPLICATION_ID UPG_SOURCE_APPLICATION_ID
, UPG_VALID_FLAG UPG_VALID_FLAG
, ZERO_AMOUNT_FLAG ZERO_AMOUNT_FLAG
, PARENT_AE_HEADER_ID PARENT_AE_HEADER_ID
, PARENT_AE_LINE_NUM PARENT_AE_LINE_NUM
, ACCRUAL_REVERSAL_FLAG ACCRUAL_REVERSAL_FLAG
, MERGE_EVENT_ID MERGE_EVENT_ID
, NEED_BAL_FLAG NEED_BAL_FLAG
FROM "XLA"."XLA_AE_HEADERS"