[Home] [Help] [Dependency Information]
Object Name: | XLA_AE_HEADERS# |
---|---|
Object Type: | VIEW |
Owner: | XLA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_HEADER_ID | NUMBER | (15) | Yes | |
APPLICATION_ID | NUMBER | (15) | Yes | |
LEDGER_ID | NUMBER | (15) | Yes | |
ENTITY_ID | NUMBER | (15) | Yes | |
EVENT_ID | NUMBER | (15) | Yes | |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | |
ACCOUNTING_DATE | DATE | Yes | ||
GL_TRANSFER_STATUS_CODE | VARCHAR2 | (30) | Yes | |
GL_TRANSFER_DATE | DATE | |||
JE_CATEGORY_NAME | VARCHAR2 | (30) | Yes | |
ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | (30) | Yes | |
ACCOUNTING_ENTRY_TYPE_CODE | VARCHAR2 | (30) | Yes | |
AMB_CONTEXT_CODE | VARCHAR2 | (30) | ||
PRODUCT_RULE_TYPE_CODE | VARCHAR2 | (1) | ||
PRODUCT_RULE_CODE | VARCHAR2 | (30) | ||
PRODUCT_RULE_VERSION | VARCHAR2 | (30) | ||
DESCRIPTION | VARCHAR2 | (1996) | ||
DOC_SEQUENCE_ID | NUMBER | |||
DOC_SEQUENCE_VALUE | NUMBER | |||
ACCOUNTING_BATCH_ID | NUMBER | (15) | ||
COMPLETION_ACCT_SEQ_VERSION_ID | NUMBER | (15) | ||
CLOSE_ACCT_SEQ_VERSION_ID | NUMBER | (15) | ||
COMPLETION_ACCT_SEQ_VALUE | NUMBER | |||
CLOSE_ACCT_SEQ_VALUE | NUMBER | |||
BUDGET_VERSION_ID | NUMBER | (15) | ||
FUNDS_STATUS_CODE | VARCHAR2 | (30) | ||
ENCUMBRANCE_TYPE_ID | NUMBER | (15) | ||
BALANCE_TYPE_CODE | VARCHAR2 | (1) | Yes | |
REFERENCE_DATE | DATE | |||
COMPLETED_DATE | DATE | |||
PERIOD_NAME | VARCHAR2 | (15) | ||
PACKET_ID | NUMBER | (15) | ||
COMPLETION_ACCT_SEQ_ASSIGN_ID | NUMBER | (15) | ||
CLOSE_ACCT_SEQ_ASSIGN_ID | NUMBER | (15) | ||
DOC_CATEGORY_CODE | VARCHAR2 | (30) | ||
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | ||
ATTRIBUTE1 | VARCHAR2 | (150) | ||
ATTRIBUTE2 | VARCHAR2 | (150) | ||
ATTRIBUTE3 | VARCHAR2 | (150) | ||
ATTRIBUTE4 | VARCHAR2 | (150) | ||
ATTRIBUTE5 | VARCHAR2 | (150) | ||
ATTRIBUTE6 | VARCHAR2 | (150) | ||
ATTRIBUTE7 | VARCHAR2 | (150) | ||
ATTRIBUTE8 | VARCHAR2 | (150) | ||
ATTRIBUTE9 | VARCHAR2 | (150) | ||
ATTRIBUTE10 | VARCHAR2 | (150) | ||
ATTRIBUTE11 | VARCHAR2 | (150) | ||
ATTRIBUTE12 | VARCHAR2 | (150) | ||
ATTRIBUTE13 | VARCHAR2 | (150) | ||
ATTRIBUTE14 | VARCHAR2 | (150) | ||
ATTRIBUTE15 | VARCHAR2 | (150) | ||
GROUP_ID | NUMBER | (15) | ||
DOC_SEQUENCE_VERSION_ID | NUMBER | (15) | ||
DOC_SEQUENCE_ASSIGN_ID | NUMBER | (15) | ||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
REQUEST_ID | NUMBER | (15) | ||
UPG_BATCH_ID | NUMBER | (15) | ||
UPG_SOURCE_APPLICATION_ID | NUMBER | (15) | ||
UPG_VALID_FLAG | VARCHAR2 | (1) | ||
ZERO_AMOUNT_FLAG | VARCHAR2 | (1) | ||
PARENT_AE_HEADER_ID | NUMBER | (15) | ||
PARENT_AE_LINE_NUM | NUMBER | (15) | ||
ACCRUAL_REVERSAL_FLAG | VARCHAR2 | (1) | ||
MERGE_EVENT_ID | NUMBER | (15) | ||
NEED_BAL_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, APPLICATION_ID
, LEDGER_ID
, ENTITY_ID
, EVENT_ID
, EVENT_TYPE_CODE
, ACCOUNTING_DATE
, GL_TRANSFER_STATUS_CODE
, GL_TRANSFER_DATE
, JE_CATEGORY_NAME
, ACCOUNTING_ENTRY_STATUS_CODE
, ACCOUNTING_ENTRY_TYPE_CODE
, AMB_CONTEXT_CODE
, PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_CODE
, PRODUCT_RULE_VERSION
, DESCRIPTION
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE
, ACCOUNTING_BATCH_ID
, COMPLETION_ACCT_SEQ_VERSION_ID
, CLOSE_ACCT_SEQ_VERSION_ID
, COMPLETION_ACCT_SEQ_VALUE
, CLOSE_ACCT_SEQ_VALUE
, BUDGET_VERSION_ID
, FUNDS_STATUS_CODE
, ENCUMBRANCE_TYPE_ID
, BALANCE_TYPE_CODE
, REFERENCE_DATE
, COMPLETED_DATE
, PERIOD_NAME
, PACKET_ID
, COMPLETION_ACCT_SEQ_ASSIGN_ID
, CLOSE_ACCT_SEQ_ASSIGN_ID
, DOC_CATEGORY_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, GROUP_ID
, DOC_SEQUENCE_VERSION_ID
, DOC_SEQUENCE_ASSIGN_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PROGRAM_UPDATE_DATE
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, REQUEST_ID
, UPG_BATCH_ID
, UPG_SOURCE_APPLICATION_ID
, UPG_VALID_FLAG
, ZERO_AMOUNT_FLAG
, PARENT_AE_HEADER_ID
, PARENT_AE_LINE_NUM
, ACCRUAL_REVERSAL_FLAG
, MERGE_EVENT_ID
, NEED_BAL_FLAG
FROM XLA.XLA_AE_HEADERS#;
|
|
|