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

TABLE: GL.GL_POSTING_INTERIM

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

Temporary Table Details

GL.GL_POSTING_INTERIM 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: Tablespace
PCT Free: 10
PCT Used: 40
Indexes
Index Type Uniqueness Tablespace Column
GL_POSTING_INTERIM_N1 NORMAL NONUNIQUE Tablespace ColumnCODE_COMBINATION_ID
ColumnPERIOD_NAME
ColumnLEDGER_ID
ColumnCURRENCY_CODE
GL_POSTING_INTERIM_N2 NORMAL NONUNIQUE Tablespace ColumnTEMPLATE_ID
GL_POSTING_INTERIM_N3 NORMAL NONUNIQUE Tablespace ColumnBAL_SEG_VALUE
ColumnCURRENCY_CODE
ColumnLEDGER_ID
Columns
Name Datatype Length Mandatory Comments
CODE_COMBINATION_ID NUMBER (15)
PERIOD_NAME VARCHAR2 (15) Yes
LEDGER_ID NUMBER (15) Yes
CURRENCY_CODE VARCHAR2 (15) Yes
PERIOD_NET_DR NUMBER
Yes
PERIOD_NET_CR NUMBER
Yes
QUARTER_TO_DATE_DR NUMBER
Yes
QUARTER_TO_DATE_CR NUMBER
Yes
PROJECT_TO_DATE_DR NUMBER
Yes
PROJECT_TO_DATE_CR NUMBER
Yes
BEGIN_BALANCE_DR NUMBER
Yes
BEGIN_BALANCE_CR NUMBER
Yes
PERIOD_YEAR NUMBER (15)
PERIOD_NUM NUMBER (15)
PERIOD_TYPE VARCHAR2 (15)
ACCOUNT_TYPE VARCHAR2 (1)
BAL_SEG_VALUE VARCHAR2 (60)
ACTUAL_FLAG VARCHAR2 (1)
ENCUMBRANCE_TYPE_ID NUMBER (15)
BUDGET_VERSION_ID NUMBER (15)
TEMPLATE_ID NUMBER (15)
TRANSLATED_FLAG VARCHAR2 (1)
INCREMENTAL_FLAG VARCHAR2 (1)
PERIOD_NET_DR_BEQ NUMBER

PERIOD_NET_CR_BEQ NUMBER

QUARTER_TO_DATE_DR_BEQ NUMBER

QUARTER_TO_DATE_CR_BEQ NUMBER

BEGIN_BALANCE_DR_BEQ NUMBER

BEGIN_BALANCE_CR_BEQ NUMBER

PROJECT_TO_DATE_DR_BEQ NUMBER

PROJECT_TO_DATE_CR_BEQ NUMBER

SEGMENT1 VARCHAR2 (25)
SEGMENT2 VARCHAR2 (25)
SEGMENT3 VARCHAR2 (25)
SEGMENT4 VARCHAR2 (25)
SEGMENT5 VARCHAR2 (25)
SEGMENT6 VARCHAR2 (25)
SEGMENT7 VARCHAR2 (25)
SEGMENT8 VARCHAR2 (25)
SEGMENT9 VARCHAR2 (25)
SEGMENT10 VARCHAR2 (25)
SEGMENT11 VARCHAR2 (25)
SEGMENT12 VARCHAR2 (25)
SEGMENT13 VARCHAR2 (25)
SEGMENT14 VARCHAR2 (25)
SEGMENT15 VARCHAR2 (25)
SEGMENT16 VARCHAR2 (25)
SEGMENT17 VARCHAR2 (25)
SEGMENT18 VARCHAR2 (25)
SEGMENT19 VARCHAR2 (25)
SEGMENT20 VARCHAR2 (25)
SEGMENT21 VARCHAR2 (25)
SEGMENT22 VARCHAR2 (25)
SEGMENT23 VARCHAR2 (25)
SEGMENT24 VARCHAR2 (25)
SEGMENT25 VARCHAR2 (25)
SEGMENT26 VARCHAR2 (25)
SEGMENT27 VARCHAR2 (25)
SEGMENT28 VARCHAR2 (25)
SEGMENT29 VARCHAR2 (25)
SEGMENT30 VARCHAR2 (25)
Query Text

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


SELECT CODE_COMBINATION_ID
,      PERIOD_NAME
,      LEDGER_ID
,      CURRENCY_CODE
,      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
,      PERIOD_YEAR
,      PERIOD_NUM
,      PERIOD_TYPE
,      ACCOUNT_TYPE
,      BAL_SEG_VALUE
,      ACTUAL_FLAG
,      ENCUMBRANCE_TYPE_ID
,      BUDGET_VERSION_ID
,      TEMPLATE_ID
,      TRANSLATED_FLAG
,      INCREMENTAL_FLAG
,      PERIOD_NET_DR_BEQ
,      PERIOD_NET_CR_BEQ
,      QUARTER_TO_DATE_DR_BEQ
,      QUARTER_TO_DATE_CR_BEQ
,      BEGIN_BALANCE_DR_BEQ
,      BEGIN_BALANCE_CR_BEQ
,      PROJECT_TO_DATE_DR_BEQ
,      PROJECT_TO_DATE_CR_BEQ
,      SEGMENT1
,      SEGMENT2
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT20
,      SEGMENT21
,      SEGMENT22
,      SEGMENT23
,      SEGMENT24
,      SEGMENT25
,      SEGMENT26
,      SEGMENT27
,      SEGMENT28
,      SEGMENT29
,      SEGMENT30
FROM GL.GL_POSTING_INTERIM;

Dependencies

[top of page]

GL.GL_POSTING_INTERIM does not reference any database object

GL.GL_POSTING_INTERIM is referenced by following:

SchemaAPPS
SynonymGL_POSTING_INTERIM