DBA Data[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_AE_HEADER_ACS

Object Details
Object Name: XLA_AE_HEADER_ACS
Object Type: TABLE
Owner: XLA
FND Design Data: TableXLA.XLA_AE_HEADER_ACS
Subobject Name:
Status: VALID


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


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_AE_HEADER_ACS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnAE_HEADER_ID
ColumnANALYTICAL_CRITERION_CODE
ColumnANALYTICAL_CRITERION_TYPE_CODE
ColumnAMB_CONTEXT_CODE
XLA_AE_HEADER_ACS_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_TX_IDX ColumnANALYTICAL_CRITERION_CODE
ColumnANALYTICAL_CRITERION_TYPE_CODE
ColumnAMB_CONTEXT_CODE
ColumnAC1
ColumnAC2
ColumnAC3
ColumnAC4
ColumnAC5
Columns
Name Datatype Length Mandatory Comments
AE_HEADER_ID NUMBER (15) Yes Journal entry identifier
ANALYTICAL_CRITERION_CODE VARCHAR2 (30) Yes Supporting reference code
ANALYTICAL_CRITERION_TYPE_CODE VARCHAR2 (30) Yes Supporting reference type code
AMB_CONTEXT_CODE VARCHAR2 (30) Yes AMB context code
OBJECT_VERSION_NUMBER NUMBER (15) Yes Object version number
AC1 VARCHAR2 (30)
Supporting reference detail value
AC2 VARCHAR2 (30)
Supporting reference detail value
AC3 VARCHAR2 (30)
Supporting reference detail value
AC4 VARCHAR2 (30)
Supporting reference detail value
AC5 VARCHAR2 (30)
Supporting reference detail value
Query Text

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


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

Dependencies

[top of page]

XLA.XLA_AE_HEADER_ACS does not reference any database object

XLA.XLA_AE_HEADER_ACS is referenced by following:

SchemaXLA
ViewXLA_AE_HEADER_ACS#