[Home] [Help] [Dependency Information]

TABLE: XLA.XLA_TRIAL_BALANCES_GT

Object Details

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

Temporary Table Details

XLA.XLA_TRIAL_BALANCES_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$SESSION. 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_TRIAL_BALANCES_GT_N1	NORMAL	NONUNIQUE		APPLIED_TO_ENTITY_ID

Columns

Query Text

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

SELECT DEFINITION_CODE
,      LEDGER_ID
,      LEDGER_NAME
,      LEDGER_SHORT_NAME
,      LEDGER_CURRENCY_CODE
,      RECORD_TYPE_CODE
,      SOURCE_ENTITY_ID
,      SOURCE_APPLICATION_ID
,      SOURCE_ENTITY_CODE
,      APPLIED_TO_ENTITY_ID
,      APPLIED_TO_APPLICATION_ID
,      APPLIED_TO_ENTITY_CODE
,      EVENT_CLASS_CODE
,      TRANSACTION_NUMBER
,      CODE_COMBINATION_ID
,      GL_DATE
,      TRX_CURRENCY_CODE
,      ENTERED_UNROUNDED_ORIG_AMOUNT
,      ENTERED_UNROUNDED_REM_AMOUNT
,      ENTERED_ROUNDED_ORIG_AMOUNT
,      ENTERED_ROUNDED_REM_AMOUNT
,      ACCTD_UNROUNDED_ORIG_AMOUNT
,      ACCTD_UNROUNDED_REM_AMOUNT
,      ACCTD_ROUNDED_ORIG_AMOUNT
,      ACCTD_ROUNDED_REM_AMOUNT
,      THIRD_PARTY_NAME
,      THIRD_PARTY_NUMBER
,      THIRD_PARTY_TYPE_CODE
,      THIRD_PARTY_TYPE
,      THIRD_PARTY_SITE_NAME
,      THIRD_PARTY_ACCOUNT_NUMBER
,      BALANCING_SEGMENT_VALUE
,      NATURAL_ACCOUNT_SEGMENT_VALUE
,      COST_CENTER_SEGMENT_VALUE
,      INTERCOMPANY_SEGMENT_VALUE
,      MANAGEMENT_SEGMENT_VALUE
,      USER_TRX_IDENTIFIER_NAME_1
,      USER_TRX_IDENTIFIER_VALUE_1
,      USER_TRX_IDENTIFIER_NAME_2
,      USER_TRX_IDENTIFIER_VALUE_2
,      USER_TRX_IDENTIFIER_NAME_3
,      USER_TRX_IDENTIFIER_VALUE_3
,      USER_TRX_IDENTIFIER_NAME_4
,      USER_TRX_IDENTIFIER_VALUE_4
,      USER_TRX_IDENTIFIER_NAME_5
,      USER_TRX_IDENTIFIER_VALUE_5
,      USER_TRX_IDENTIFIER_NAME_6
,      USER_TRX_IDENTIFIER_VALUE_6
,      USER_TRX_IDENTIFIER_NAME_7
,      USER_TRX_IDENTIFIER_VALUE_7
,      USER_TRX_IDENTIFIER_NAME_8
,      USER_TRX_IDENTIFIER_VALUE_8
,      USER_TRX_IDENTIFIER_NAME_9
,      USER_TRX_IDENTIFIER_VALUE_9
,      USER_TRX_IDENTIFIER_NAME_10
,      USER_TRX_IDENTIFIER_VALUE_10
FROM XLA.XLA_TRIAL_BALANCES_GT;

Dependencies

[top of page]

XLA.XLA_TRIAL_BALANCES_GT does not reference any database object

XLA.XLA_TRIAL_BALANCES_GT is referenced by following:

APPS

XLA_TRIAL_BALANCES_GT