[Home] [Help]
[Dependency Information]
Object Name: | XLA_AE_HEADERS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | ![]() |
Subobject Name: | |
Status: | VALID |
A supplementary view used to simplify forms coding.
Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
AE_HEADER_ID | NUMBER | (15) | Yes | Accounting entry id |
BALANCE_TYPE_CODE | VARCHAR2 | (1) | Yes | Balance type (Actual, Budget, or Encumbrance) |
APPLICATION_ID | NUMBER | (15) | Yes | Internal Id of the application |
LEDGER_ID | NUMBER | (15) | Yes | Ledger id |
LEGAL_ENTITY_ID | NUMBER | (15) | Legal entity id | |
JE_CATEGORY_NAME | VARCHAR2 | (30) | Yes | General Ledger category name |
DESCRIPTION | VARCHAR2 | (1996) | Description | |
BUDGET_VERSION_ID | NUMBER | (15) | Budget version defining column | |
GL_DATE | DATE | Yes | Accounting date | |
PERIOD_NAME | VARCHAR2 | (15) | Subledger journal entry period name. | |
REFERENCE_DATE | DATE | Accounting Entry reference Date. | ||
COMPLETED_DATE | DATE | Subledger journal entry completion date | ||
DOC_SEQUENCE_ID | NUMBER | Sub-Ledger document sequence identifier | ||
DOC_SEQUENCE_VALUE | NUMBER | Sub-Ledger document sequence value | ||
COMPLETION_ACCT_SEQ_VERSION_ID | NUMBER | (15) | Subledger journal entry creation sequence Identifier | |
COMPLETION_ACCT_SEQ_VALUE | NUMBER | Subledger journal entry creation sequence Value | ||
CLOSE_ACCT_SEQ_VERSION_ID | NUMBER | (15) | Accounting entry reporting sequence | |
CLOSE_ACCT_SEQ_VALUE | NUMBER | Accounting entry reporting sequence Value | ||
EVENT_ID | NUMBER | (15) | Yes | Event id |
EVENT_TYPE_CODE | VARCHAR2 | (30) | Yes | Event type code |
GL_TRANSFER_STATUS_CODE | VARCHAR2 | (30) | Yes | General Ledger transfer status code |
GL_TRANSFER_DATE | DATE | General Ledger transfer date | ||
ACCOUNTING_BATCH_ID | NUMBER | (15) | Accounting Program batch Id | |
ACCOUNTING_ENTRY_STATUS_CODE | VARCHAR2 | (30) | Yes | Accounting entry status code |
ACCOUNTING_ENTRY_TYPE_CODE | VARCHAR2 | (30) | Yes | Accounting entry type code |
PRODUCT_RULE_TYPE_CODE | VARCHAR2 | (1) | Application Accounting Definition type code, not applicable for manual adjustments | |
PRODUCT_RULE_CODE | VARCHAR2 | (30) | Application Accounting Definition type code, not applicable for manual adjustments | |
PRODUCT_RULE_VERSION | VARCHAR2 | (30) | Version of the rules, not applicable for manual adjustments | |
AMB_CONTEXT_CODE | VARCHAR2 | (30) | Accounting Methods Builder context. | |
FUNDS_STATUS_CODE | VARCHAR2 | (30) | Funds checker status | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (150) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (150) | Descriptive flexfield segment | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | (15) | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | |
PACKET_ID | NUMBER | (15) | Budgetary control packet defining column. | |
PARENT_AE_HEADER_ID | NUMBER | (15) | The journal entry header id of the parent entry. | |
PARENT_AE_LINE_NUM | NUMBER | (15) | The journal entry line number of the parent entry. | |
ACCRUAL_REVERSAL_FLAG | VARCHAR2 | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT AE_HEADER_ID
, BALANCE_TYPE_CODE
, APPLICATION_ID
, LEDGER_ID
, LEGAL_ENTITY_ID
, JE_CATEGORY_NAME
, DESCRIPTION
, BUDGET_VERSION_ID
, GL_DATE
, PERIOD_NAME
, REFERENCE_DATE
, COMPLETED_DATE
, DOC_SEQUENCE_ID
, DOC_SEQUENCE_VALUE
, COMPLETION_ACCT_SEQ_VERSION_ID
, COMPLETION_ACCT_SEQ_VALUE
, CLOSE_ACCT_SEQ_VERSION_ID
, CLOSE_ACCT_SEQ_VALUE
, EVENT_ID
, EVENT_TYPE_CODE
, GL_TRANSFER_STATUS_CODE
, GL_TRANSFER_DATE
, ACCOUNTING_BATCH_ID
, ACCOUNTING_ENTRY_STATUS_CODE
, ACCOUNTING_ENTRY_TYPE_CODE
, PRODUCT_RULE_TYPE_CODE
, PRODUCT_RULE_CODE
, PRODUCT_RULE_VERSION
, AMB_CONTEXT_CODE
, FUNDS_STATUS_CODE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, PACKET_ID
, PARENT_AE_HEADER_ID
, PARENT_AE_LINE_NUM
, ACCRUAL_REVERSAL_FLAG
FROM APPS.XLA_AE_HEADERS_V;
APPS.XLA_AE_HEADERS_V is not referenced by any database object
|
|
|