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_LINE_ACS

Object Details

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

This table stores the relationship between the subledger journal entry lines and the analytical detail values.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_AE_LINE_ACS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	AE_HEADER_ID AE_LINE_NUM ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_TYPE_CODE AMB_CONTEXT_CODE
XLA_AE_LINE_ACS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ANALYTICAL_CRITERION_CODE ANALYTICAL_CRITERION_TYPE_CODE AMB_CONTEXT_CODE AC1 AC2 AC3 AC4 AC5

Columns

Name	Datatype	Length	Mandatory	Comments
AE_HEADER_ID	NUMBER	(15)	Yes	Internal identifier of the subledger journal entry header of this accounting entry line which has supporting reference, attached to it.
AE_LINE_NUM	NUMBER	(15)	Yes	The Unique internal identifier of the subledger journal entry line of this accounting entry line which has supporting reference, attached to it.
ANALYTICAL_CRITERION_CODE	VARCHAR2	(30)	Yes	Supporting reference code
ANALYTICAL_CRITERION_TYPE_CODE	VARCHAR2	(30)	Yes	Supporting reference type code, which indicates whether the supporting reference attached is seeded or user defined. If it is seeded then it will be stamped as �S� or else �C�.
AMB_CONTEXT_CODE	VARCHAR2	(30)	Yes	Accounting Methods Builder context of the accounting entry.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Object version number
AC1	VARCHAR2	(30)		The detail value of the Supporting reference
AC2	VARCHAR2	(30)		The detail value of the Supporting reference
AC3	VARCHAR2	(30)		The detail value of the Supporting reference
AC4	VARCHAR2	(30)		The detail value of the Supporting reference
AC5	VARCHAR2	(30)		The detail value of the Supporting reference

Query Text

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


SELECT AE_HEADER_ID
,      AE_LINE_NUM
,      ANALYTICAL_CRITERION_CODE
,      ANALYTICAL_CRITERION_TYPE_CODE
,      AMB_CONTEXT_CODE
,      OBJECT_VERSION_NUMBER
,      AC1
,      AC2
,      AC3
,      AC4
,      AC5
FROM XLA.XLA_AE_LINE_ACS;

Dependencies

[top of page]

XLA.XLA_AE_LINE_ACS does not reference any database object

XLA.XLA_AE_LINE_ACS is referenced by following:

APPS: XLA_AE_LINE_ACS