[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_TRANSACTION_ACCTS_GT

Object Details

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

Temporary Table Details

XLA.XLA_TRANSACTION_ACCTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$TRANSACTION. Data is removed at the end of this period.

Storage Details

Tablespace:
PCT Free:	10
PCT Used:	40

Indexes

Index	Type	Uniqueness	Tablespace	Column
XLA_TRANSACTION_ACCTS_U1	NORMAL	UNIQUE		LINE_NUMBER LEDGER_ID AE_HEADER_ID TEMP_LINE_NUM
XLA_SS_TRANSACTION_ACCTS_GT_N1	NORMAL	NONUNIQUE		LEDGER_ID AE_HEADER_ID TEMP_LINE_NUM
XLA_TRANSACTION_ACCTS_GT_N1	NORMAL	NONUNIQUE		AE_HEADER_ID TEMP_LINE_NUM LEDGER_ID SL_COA_MAPPING_ID
XLA_TRANSACTION_ACCTS_GT_N2	NORMAL	NONUNIQUE		SL_COA_MAPPING_ID CODE_COMBINATION_ID

Columns

Query Text

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

SELECT LINE_NUMBER
,      AE_HEADER_ID
,      TEMP_LINE_NUM
,      LEDGER_ID
,      SIDE_CODE
,      CODE_COMBINATION_ID
,      SEGMENT
,      FROM_SEGMENT_CODE
,      TO_SEGMENT_CODE
,      PROCESSING_STATUS_CODE
,      SL_COA_MAPPING_ID
FROM XLA.XLA_TRANSACTION_ACCTS_GT;

Dependencies

[top of page]

XLA.XLA_TRANSACTION_ACCTS_GT does not reference any database object

XLA.XLA_TRANSACTION_ACCTS_GT is referenced by following:

APPS

XLA_TRANSACTION_ACCTS_GT