[Home] [Help] [Dependency Information]
Object Name: | XLA_TRIAL_BALANCES_GT |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_TRIAL_BALANCES_GT |
Subobject Name: | |
Status: | VALID |
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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_TRIAL_BALANCES_GT_N1 | NORMAL | NONUNIQUE | APPLIED_TO_ENTITY_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
DEFINITION_CODE | VARCHAR2 | (30) | Yes | |
LEDGER_ID | NUMBER | (15) | Yes | |
LEDGER_NAME | VARCHAR2 | (30) | Yes | |
LEDGER_SHORT_NAME | VARCHAR2 | (20) | Yes | |
LEDGER_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
RECORD_TYPE_CODE | VARCHAR2 | (30) | Yes | |
SOURCE_ENTITY_ID | NUMBER | (15) | ||
SOURCE_APPLICATION_ID | NUMBER | (15) | ||
SOURCE_ENTITY_CODE | VARCHAR2 | (30) | ||
APPLIED_TO_ENTITY_ID | NUMBER | (15) | ||
APPLIED_TO_APPLICATION_ID | NUMBER | (15) | ||
APPLIED_TO_ENTITY_CODE | VARCHAR2 | (30) | ||
EVENT_CLASS_CODE | VARCHAR2 | (30) | ||
TRANSACTION_NUMBER | VARCHAR2 | (80) | ||
CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
GL_DATE | DATE | |||
TRX_CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
ENTERED_UNROUNDED_ORIG_AMOUNT | NUMBER | |||
ENTERED_UNROUNDED_REM_AMOUNT | NUMBER | |||
ENTERED_ROUNDED_ORIG_AMOUNT | NUMBER | |||
ENTERED_ROUNDED_REM_AMOUNT | NUMBER | |||
ACCTD_UNROUNDED_ORIG_AMOUNT | NUMBER | |||
ACCTD_UNROUNDED_REM_AMOUNT | NUMBER | |||
ACCTD_ROUNDED_ORIG_AMOUNT | NUMBER | |||
ACCTD_ROUNDED_REM_AMOUNT | NUMBER | |||
THIRD_PARTY_NAME | VARCHAR2 | (360) | ||
THIRD_PARTY_NUMBER | VARCHAR2 | (30) | ||
THIRD_PARTY_TYPE_CODE | VARCHAR2 | (30) | ||
THIRD_PARTY_TYPE | VARCHAR2 | (80) | ||
THIRD_PARTY_SITE_NAME | VARCHAR2 | (240) | ||
THIRD_PARTY_ACCOUNT_NUMBER | VARCHAR2 | (30) | ||
BALANCING_SEGMENT_VALUE | VARCHAR2 | (25) | ||
NATURAL_ACCOUNT_SEGMENT_VALUE | VARCHAR2 | (25) | ||
COST_CENTER_SEGMENT_VALUE | VARCHAR2 | (25) | ||
INTERCOMPANY_SEGMENT_VALUE | VARCHAR2 | (25) | ||
MANAGEMENT_SEGMENT_VALUE | VARCHAR2 | (25) | ||
USER_TRX_IDENTIFIER_NAME_1 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_1 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_2 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_2 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_3 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_3 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_4 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_4 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_5 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_5 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_6 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_6 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_7 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_7 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_8 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_8 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_9 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_9 | VARCHAR2 | (240) | ||
USER_TRX_IDENTIFIER_NAME_10 | VARCHAR2 | (80) | ||
USER_TRX_IDENTIFIER_VALUE_10 | VARCHAR2 | (240) |
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;
XLA.XLA_TRIAL_BALANCES_GT does not reference any database object
XLA.XLA_TRIAL_BALANCES_GT is referenced by following:
|
|
|