[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_AE_LINES

Object Details

Object Name:	XLA_AE_LINES
Object Type:	TABLE
Owner:	XLA
FND Design Data:	XLA.XLA_AE_LINES
Subobject Name:
Status:	VALID

The XLA_AE_LINES table stores the subledger journal entry lines. There is a one-to-many relationship between subledger journal entry headers and subledger journal entry lines.

Storage Details

Tablespace:
PCT Free:
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_AE_LINES_U1	NORMAL	UNIQUE		AE_HEADER_ID AE_LINE_NUM APPLICATION_ID
XLA_AE_LINES_N1	NORMAL	NONUNIQUE		CONTROL_BALANCE_FLAG
XLA_AE_LINES_N4	NORMAL	NONUNIQUE		GL_SL_LINK_ID GL_SL_LINK_TABLE
XLA_AE_LINES_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CODE_COMBINATION_ID LEDGER_ID ACCOUNTING_DATE

Columns

Query Text

Cut, paste (and edit) the following text to query this object:

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

Dependencies

[top of page]

XLA.XLA_AE_LINES does not reference any database object

XLA.XLA_AE_LINES is referenced by following:

XLA

XLA_AE_LINES#