eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [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

Name	Datatype	Length	Mandatory
AE_HEADER_ID	NUMBER	(15)	Yes
AE_LINE_NUM	NUMBER	(15)	Yes
APPLICATION_ID	NUMBER	(15)	Yes
CODE_COMBINATION_ID	NUMBER	(15)	Yes
GL_TRANSFER_MODE_CODE	VARCHAR2	(1)
GL_SL_LINK_ID	NUMBER	(15)
ACCOUNTING_CLASS_CODE	VARCHAR2	(30)	Yes
PARTY_ID	NUMBER	(15)
PARTY_SITE_ID	NUMBER	(15)
PARTY_TYPE_CODE	VARCHAR2	(1)
ENTERED_DR	NUMBER
ENTERED_CR	NUMBER
ACCOUNTED_DR	NUMBER
ACCOUNTED_CR	NUMBER
DESCRIPTION	VARCHAR2	(1996)
STATISTICAL_AMOUNT	NUMBER
CURRENCY_CODE	VARCHAR2	(15)	Yes
CURRENCY_CONVERSION_DATE	DATE
CURRENCY_CONVERSION_RATE	NUMBER
CURRENCY_CONVERSION_TYPE	VARCHAR2	(30)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
JGZZ_RECON_REF	VARCHAR2	(240)
CONTROL_BALANCE_FLAG	VARCHAR2	(1)
ANALYTICAL_BALANCE_FLAG	VARCHAR2	(1)
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)
GL_SL_LINK_TABLE	VARCHAR2	(30)
DISPLAYED_LINE_NUMBER	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_TAX_REFERENCE_ID1	NUMBER	(15)
UPG_TAX_REFERENCE_ID2	NUMBER	(15)
UPG_TAX_REFERENCE_ID3	NUMBER	(15)
UNROUNDED_ACCOUNTED_DR	NUMBER
UNROUNDED_ACCOUNTED_CR	NUMBER
GAIN_OR_LOSS_FLAG	VARCHAR2	(1)
UNROUNDED_ENTERED_DR	NUMBER
UNROUNDED_ENTERED_CR	NUMBER
SUBSTITUTED_CCID	NUMBER	(15)
BUSINESS_CLASS_CODE	VARCHAR2	(30)
MPA_ACCRUAL_ENTRY_FLAG	VARCHAR2	(1)
ENCUMBRANCE_TYPE_ID	NUMBER	(15)
FUNDS_STATUS_CODE	VARCHAR2	(30)
MERGE_CODE_COMBINATION_ID	NUMBER	(15)
MERGE_PARTY_ID	NUMBER	(15)
MERGE_PARTY_SITE_ID	NUMBER	(15)
ACCOUNTING_DATE	DATE		Yes
LEDGER_ID	NUMBER	(15)	Yes
SOURCE_TABLE	VARCHAR2	(30)
SOURCE_ID	NUMBER	(15)
ACCOUNT_OVERLAY_SOURCE_ID	NUMBER	(15)

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#