[Home] [Help] [Dependency Information]
Object Name: | XLA_AC_BAL_INTERIM_GT |
---|---|
Object Type: | TABLE |
Owner: | XLA |
FND Design Data: | XLA.XLA_AC_BAL_INTERIM_GT |
Subobject Name: | |
Status: | VALID |
Intermediate table used for Balance Computation
XLA.XLA_AC_BAL_INTERIM_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.
Tablespace: | |
---|---|
PCT Free: | 10 |
PCT Used: | 40 |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
XLA_AC_BAL_INTERIM_GT_U1 | FUNCTION-BASED NORMAL | UNIQUE |
NVL("AC1",' ')
NVL("AC2",' ') NVL("AC3",' ') NVL("AC4",' ') NVL("AC5",' ') |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
APPLICATION_ID | NUMBER | (15) | Yes | Internal identifier of the application associated with the supporting reference |
LEDGER_ID | NUMBER | (15) | Yes | Internal identifier of the ledger associated with the supporting reference |
CODE_COMBINATION_ID | NUMBER | (15) | Yes | The accounting Code combination identifier of the supporting reference |
ANALYTICAL_CRITERION_CODE | VARCHAR2 | (30) | Yes | Supporting reference code |
ANALYTICAL_CRITERION_TYPE_CODE | VARCHAR2 | (30) | Yes | Supporting reference type code, which indicates whether the supporting reference attached is seeded or user defined. If it is seeded then it will be stamped as S or else C. |
AMB_CONTEXT_CODE | VARCHAR2 | (30) | Yes | AMB context code |
AC1 | VARCHAR2 | (30) | Supporting Reference 1 | |
AC2 | VARCHAR2 | (30) | Supporting Reference 2 | |
AC3 | VARCHAR2 | (30) | Supporting Reference 3 | |
AC4 | VARCHAR2 | (30) | Supporting Reference 4 | |
AC5 | VARCHAR2 | (30) | Supporting Reference 5 | |
PERIOD_NAME | VARCHAR2 | (15) | Accounting period name | |
EFFECTIVE_PERIOD_NUM | NUMBER | (15) | Yes | The effective period number of accounting period |
PERIOD_YEAR | NUMBER | (15) | Yes | Accounting period year |
PERIOD_BALANCE_DR | NUMBER | Current period debit balance: made up of the period activity. If Journal Line Type (JLT) setup enabled for carried forward then this value will be carried forward to the next year. | ||
PERIOD_BALANCE_CR | NUMBER | Current period credit balance: made up of the period activity. If Journal Line Type (JLT) setup enabled for carried forward then this value will be carried forward to the next year. | ||
BEGINNING_BALANCE_DR | NUMBER | Beginning debit balance for the period. For initial period of the supporting reference null value will be populated in this column. | ||
BEGINNING_BALANCE_CR | NUMBER | Beginning credit balance for the period. For initial period of the supporting reference null value will be populated in this column. |
Cut, paste (and edit) the following text to query this object:
SELECT APPLICATION_ID
, LEDGER_ID
, CODE_COMBINATION_ID
, ANALYTICAL_CRITERION_CODE
, ANALYTICAL_CRITERION_TYPE_CODE
, AMB_CONTEXT_CODE
, AC1
, AC2
, AC3
, AC4
, AC5
, PERIOD_NAME
, EFFECTIVE_PERIOD_NUM
, PERIOD_YEAR
, PERIOD_BALANCE_DR
, PERIOD_BALANCE_CR
, BEGINNING_BALANCE_DR
, BEGINNING_BALANCE_CR
FROM XLA.XLA_AC_BAL_INTERIM_GT;
XLA.XLA_AC_BAL_INTERIM_GT does not reference any database object
XLA.XLA_AC_BAL_INTERIM_GT is referenced by following:
|
|
|