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

TABLE: GL.GL_BALANCES_DELTA_INTERIM

Object Details
Object Name: GL_BALANCES_DELTA_INTERIM
Object Type: TABLE
Owner: GL
FND Design Data: TableSQLGL.GL_BALANCES_DELTA_INTERIM
Subobject Name:
Status: VALID


GL_BALANCES_DELTA_INTERIM is used to temporarily store data from the GL_BALANCES_DELTA table. This table is used only when executing the Analyzer - Delete Incremental Balances program in the Defragment mode.
The primary key on this table consists of the following columns: delta_run_id, ledger_id, code_combination_id, currency_code, period_name, actual_flag, budget_version_id, encumbrance_type_id and translated_flag


Storage Details
Tablespace: TablespaceAPPS_TS_NOLOGGING
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
GL_BALANCES_DELTA_INTERIM_N1 NORMAL NONUNIQUE TablespaceAPPS_TS_NOLOGGING ColumnDELTA_RUN_ID
Columns
Name Datatype Length Mandatory Comments
DELTA_RUN_ID NUMBER (15) Yes Posting run defining column
LEDGER_ID NUMBER (15) Yes Ledger defining column
CODE_COMBINATION_ID NUMBER (15) Yes Key flexfield combination defining column
CURRENCY_CODE VARCHAR2 (15) Yes Currency
PERIOD_NAME VARCHAR2 (15) Yes Accounting period
ACTUAL_FLAG VARCHAR2 (1) Yes Balance type(Actual, Budget, or Encumbrance)
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
CREATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_LOGIN NUMBER (15) Yes Standard Who column
BUDGET_VERSION_ID NUMBER (15)
Budget version defining column
ENCUMBRANCE_TYPE_ID NUMBER (15)
Encumbrance type defining column
TRANSLATED_FLAG VARCHAR2 (1)
Translated balance flag
TEMPLATE_ID NUMBER (15)
Summary template defining column
PERIOD_YEAR NUMBER (15)
Accounting period year
PERIOD_NUM NUMBER (15)
Accounting period number
PERIOD_NET_DR NUMBER

period net debit balance
PERIOD_NET_CR NUMBER

Period net credit balance
QUARTER_TO_DATE_DR NUMBER

Quarter to date debit balance
QUARTER_TO_DATE_CR NUMBER

Quarter to date credit balance
PROJECT_TO_DATE_DR NUMBER

Accumulated project debit balance(life to date balance)
PROJECT_TO_DATE_CR NUMBER

Accumulated project credit balance
BEGIN_BALANCE_DR NUMBER

Beginning debit balance
BEGIN_BALANCE_CR NUMBER

Beginning credit balance
Query Text

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


SELECT DELTA_RUN_ID
,      LEDGER_ID
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      PERIOD_NAME
,      ACTUAL_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      BUDGET_VERSION_ID
,      ENCUMBRANCE_TYPE_ID
,      TRANSLATED_FLAG
,      TEMPLATE_ID
,      PERIOD_YEAR
,      PERIOD_NUM
,      PERIOD_NET_DR
,      PERIOD_NET_CR
,      QUARTER_TO_DATE_DR
,      QUARTER_TO_DATE_CR
,      PROJECT_TO_DATE_DR
,      PROJECT_TO_DATE_CR
,      BEGIN_BALANCE_DR
,      BEGIN_BALANCE_CR
FROM GL.GL_BALANCES_DELTA_INTERIM;

Dependencies

[top of page]

GL.GL_BALANCES_DELTA_INTERIM does not reference any database object

GL.GL_BALANCES_DELTA_INTERIM is referenced by following:

SchemaAPPS
SynonymGL_BALANCES_DELTA_INTERIM