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


TABLE: XLA.XLA_TRANSACTION_ENTITIES

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

The table XLA_ENTITIES contains information about sub-ledger document or transactions.

Storage Details
Tablespace: Tablespace
PCT Free:
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
XLA_TRANSACTION_ENTITIES_U1 NORMAL UNIQUE Tablespace ColumnENTITY_ID
ColumnAPPLICATION_ID
XLA_TRANSACTION_ENTITIES_N1 FUNCTION-BASED NORMAL NONUNIQUE Tablespace ColumnNVL("SOURCE_ID_INT_1",(-99))
ColumnNVL("SOURCE_ID_INT_2",(-99))
ColumnNVL("SOURCE_ID_INT_3",(-99))
ColumnNVL("SOURCE_ID_INT_4",(-99))
ColumnNVL("SOURCE_ID_CHAR_1",' ')
ColumnNVL("SOURCE_ID_CHAR_2",' ')
ColumnNVL("SOURCE_ID_CHAR_3",' ')
ColumnNVL("SOURCE_ID_CHAR_4",' ')
Columns
Name Datatype Length Mandatory Comments
ENTITY_ID NUMBER (15) Yes Entity id
APPLICATION_ID NUMBER (15) Yes Internal id of the application
LEGAL_ENTITY_ID NUMBER (15)
Legal entity id
ENTITY_CODE VARCHAR2 (30) Yes Entity code
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER (38) Yes Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER (38) Yes Standard Who Column
LAST_UPDATE_LOGIN NUMBER (38)
Standard Who Column
SOURCE_ID_INT_1 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_1 VARCHAR2 (30)
Flexible source id (Char)
SECURITY_ID_INT_1 NUMBER (38)
Flexible security id (Integer)
SECURITY_ID_INT_2 NUMBER (38)
Flexible security id (Integer)
SECURITY_ID_INT_3 NUMBER (38)
Flexible security id (Integer)
SECURITY_ID_CHAR_1 VARCHAR2 (30)
Flexible security id (Char)
SECURITY_ID_CHAR_2 VARCHAR2 (30)
Flexible security id (Char)
SECURITY_ID_CHAR_3 VARCHAR2 (30)
Flexible security id (Char)
SOURCE_ID_INT_2 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_2 VARCHAR2 (30)
Flexible source id (Char)
SOURCE_ID_INT_3 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_3 VARCHAR2 (30)
Flexible source id (Char)
SOURCE_ID_INT_4 NUMBER (38)
Flexible source id (Integer)
SOURCE_ID_CHAR_4 VARCHAR2 (30)
Flexible source id (Char)
TRANSACTION_NUMBER VARCHAR2 (240)
Transaction id
LEDGER_ID NUMBER (15) Yes Internal Identifier for the Ledger.
VALUATION_METHOD VARCHAR2 (30)
Valuation Method
SOURCE_APPLICATION_ID NUMBER (15) Yes Source application identifier
UPG_BATCH_ID NUMBER (15)
Upgrade batch identifier
UPG_SOURCE_APPLICATION_ID NUMBER (15)
Internal Id of the Upgrading application
UPG_VALID_FLAG VARCHAR2 (1)
Flag to indicate if Validation was successfully run for the batch
Query Text

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


SELECT ENTITY_ID
,      APPLICATION_ID
,      LEGAL_ENTITY_ID
,      ENTITY_CODE
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_ID_INT_1
,      SOURCE_ID_CHAR_1
,      SECURITY_ID_INT_1
,      SECURITY_ID_INT_2
,      SECURITY_ID_INT_3
,      SECURITY_ID_CHAR_1
,      SECURITY_ID_CHAR_2
,      SECURITY_ID_CHAR_3
,      SOURCE_ID_INT_2
,      SOURCE_ID_CHAR_2
,      SOURCE_ID_INT_3
,      SOURCE_ID_CHAR_3
,      SOURCE_ID_INT_4
,      SOURCE_ID_CHAR_4
,      TRANSACTION_NUMBER
,      LEDGER_ID
,      VALUATION_METHOD
,      SOURCE_APPLICATION_ID
,      UPG_BATCH_ID
,      UPG_SOURCE_APPLICATION_ID
,      UPG_VALID_FLAG
FROM XLA.XLA_TRANSACTION_ENTITIES;

Dependencies

[top of page]

XLA.XLA_TRANSACTION_ENTITIES does not reference any database object

XLA.XLA_TRANSACTION_ENTITIES is referenced by following:

SchemaXLA
ViewXLA_TRANSACTION_ENTITIES#