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

TABLE: GL.GL_BUDGET_INTERIM

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

Budget posting interim balances

Temporary Table Details

GL.GL_BUDGET_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_BUDGET_INTERIM_N1 NORMAL NONUNIQUE Tablespace ColumnSTATUS_NUMBER
ColumnCODE_COMBINATION_ID
ColumnBUDGET_VERSION_ID
ColumnCURRENCY_CODE
GL_BUDGET_INTERIM_N2 NORMAL NONUNIQUE Tablespace ColumnTEMPLATE_ID
Columns
Name Datatype Length Mandatory Comments
LEDGER_ID NUMBER (15) Yes
CODE_COMBINATION_ID NUMBER (15) Yes Key flexfield combination defining column
CURRENCY_CODE VARCHAR2 (15) Yes Currency
BUDGET_VERSION_ID NUMBER (15) Yes Budget version defining column
BUDGET_ENTITY_ID NUMBER (15) Yes Budget organization defining column
PERIOD_YEAR NUMBER (15) Yes Accounting period year
PERIOD_TYPE VARCHAR2 (15) Yes Accounting period type
STATUS_NUMBER NUMBER (15) Yes Accounting period number
LAST_UPDATE_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
ACCOUNT_TYPE VARCHAR2 (25)
Account type lookup (Asset, Liability, etc)
DR_FLAG VARCHAR2 (1)
Debit amount flag
TRANSLATED_FLAG VARCHAR2 (1)
Translated balance flag
TEMPLATE_ID NUMBER (15)
Summary template defining column
PERIOD1_AMOUNT NUMBER

Budget period amount
PERIOD2_AMOUNT NUMBER

Budget period amount
PERIOD3_AMOUNT NUMBER

Budget period amount
PERIOD4_AMOUNT NUMBER

Budget period amount
PERIOD5_AMOUNT NUMBER

Budget period amount
PERIOD6_AMOUNT NUMBER

Budget period amount
PERIOD7_AMOUNT NUMBER

Budget period amount
PERIOD8_AMOUNT NUMBER

Budget period amount
PERIOD9_AMOUNT NUMBER

Budget period amount
PERIOD10_AMOUNT NUMBER

Budget period amount
PERIOD11_AMOUNT NUMBER

Budget period amount
PERIOD12_AMOUNT NUMBER

Budget period amount
PERIOD13_AMOUNT NUMBER

Budget period amount
PERIOD14_AMOUNT NUMBER

Budget period amount
PERIOD15_AMOUNT NUMBER

Budget period amount
PERIOD16_AMOUNT NUMBER

Budget period amount
PERIOD17_AMOUNT NUMBER

Budget period amount
PERIOD18_AMOUNT NUMBER

Budget period amount
PERIOD19_AMOUNT NUMBER

Budget period amount
PERIOD20_AMOUNT NUMBER

Budget period amount
PERIOD21_AMOUNT NUMBER

Budget period amount
PERIOD22_AMOUNT NUMBER

Budget period amount
PERIOD23_AMOUNT NUMBER

Budget period amount
PERIOD24_AMOUNT NUMBER

Budget period amount
PERIOD25_AMOUNT NUMBER

Budget period amount
PERIOD26_AMOUNT NUMBER

Budget period amount
PERIOD27_AMOUNT NUMBER

Budget period amount
PERIOD28_AMOUNT NUMBER

Budget period amount
PERIOD29_AMOUNT NUMBER

Budget period amount
PERIOD30_AMOUNT NUMBER

Budget period amount
PERIOD31_AMOUNT NUMBER

Budget period amount
PERIOD32_AMOUNT NUMBER

Budget period amount
PERIOD33_AMOUNT NUMBER

Budget period amount
PERIOD34_AMOUNT NUMBER

Budget period amount
PERIOD35_AMOUNT NUMBER

Budget period amount
PERIOD36_AMOUNT NUMBER

Budget period amount
PERIOD37_AMOUNT NUMBER

Budget period amount
PERIOD38_AMOUNT NUMBER

Budget period amount
PERIOD39_AMOUNT NUMBER

Budget period amount
PERIOD40_AMOUNT NUMBER

Budget period amount
PERIOD41_AMOUNT NUMBER

Budget period amount
PERIOD42_AMOUNT NUMBER

Budget period amount
PERIOD43_AMOUNT NUMBER

Budget period amount
PERIOD44_AMOUNT NUMBER

Budget period amount
PERIOD45_AMOUNT NUMBER

Budget period amount
PERIOD46_AMOUNT NUMBER

Budget period amount
PERIOD47_AMOUNT NUMBER

Budget period amount
PERIOD48_AMOUNT NUMBER

Budget period amount
PERIOD49_AMOUNT NUMBER

Budget period amount
PERIOD50_AMOUNT NUMBER

Budget period amount
PERIOD51_AMOUNT NUMBER

Budget period amount
PERIOD52_AMOUNT NUMBER

Budget period amount
PERIOD53_AMOUNT NUMBER

Budget period amount
PERIOD54_AMOUNT NUMBER

Budget period amount
PERIOD55_AMOUNT NUMBER

Budget period amount
PERIOD56_AMOUNT NUMBER

Budget period amount
PERIOD57_AMOUNT NUMBER

Budget period amount
PERIOD58_AMOUNT NUMBER

Budget period amount
PERIOD59_AMOUNT NUMBER

Budget period amount
PERIOD60_AMOUNT NUMBER

Budget period amount
SUM10 NUMBER

Period (1 - 10) budget sum
SUM20 NUMBER

Period (11 - 20) budget sum
SUM30 NUMBER

Period (21 - 30) budget sum
SUM40 NUMBER

Period (31 - 40) budget sum
SUM50 NUMBER

Period (41 - 50) budget sum
SUM60 NUMBER

Period (51 - 60) budget sum
YEAR_TO_DATE NUMBER

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

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


SELECT LEDGER_ID
,      CODE_COMBINATION_ID
,      CURRENCY_CODE
,      BUDGET_VERSION_ID
,      BUDGET_ENTITY_ID
,      PERIOD_YEAR
,      PERIOD_TYPE
,      STATUS_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      ACCOUNT_TYPE
,      DR_FLAG
,      TRANSLATED_FLAG
,      TEMPLATE_ID
,      PERIOD1_AMOUNT
,      PERIOD2_AMOUNT
,      PERIOD3_AMOUNT
,      PERIOD4_AMOUNT
,      PERIOD5_AMOUNT
,      PERIOD6_AMOUNT
,      PERIOD7_AMOUNT
,      PERIOD8_AMOUNT
,      PERIOD9_AMOUNT
,      PERIOD10_AMOUNT
,      PERIOD11_AMOUNT
,      PERIOD12_AMOUNT
,      PERIOD13_AMOUNT
,      PERIOD14_AMOUNT
,      PERIOD15_AMOUNT
,      PERIOD16_AMOUNT
,      PERIOD17_AMOUNT
,      PERIOD18_AMOUNT
,      PERIOD19_AMOUNT
,      PERIOD20_AMOUNT
,      PERIOD21_AMOUNT
,      PERIOD22_AMOUNT
,      PERIOD23_AMOUNT
,      PERIOD24_AMOUNT
,      PERIOD25_AMOUNT
,      PERIOD26_AMOUNT
,      PERIOD27_AMOUNT
,      PERIOD28_AMOUNT
,      PERIOD29_AMOUNT
,      PERIOD30_AMOUNT
,      PERIOD31_AMOUNT
,      PERIOD32_AMOUNT
,      PERIOD33_AMOUNT
,      PERIOD34_AMOUNT
,      PERIOD35_AMOUNT
,      PERIOD36_AMOUNT
,      PERIOD37_AMOUNT
,      PERIOD38_AMOUNT
,      PERIOD39_AMOUNT
,      PERIOD40_AMOUNT
,      PERIOD41_AMOUNT
,      PERIOD42_AMOUNT
,      PERIOD43_AMOUNT
,      PERIOD44_AMOUNT
,      PERIOD45_AMOUNT
,      PERIOD46_AMOUNT
,      PERIOD47_AMOUNT
,      PERIOD48_AMOUNT
,      PERIOD49_AMOUNT
,      PERIOD50_AMOUNT
,      PERIOD51_AMOUNT
,      PERIOD52_AMOUNT
,      PERIOD53_AMOUNT
,      PERIOD54_AMOUNT
,      PERIOD55_AMOUNT
,      PERIOD56_AMOUNT
,      PERIOD57_AMOUNT
,      PERIOD58_AMOUNT
,      PERIOD59_AMOUNT
,      PERIOD60_AMOUNT
,      SUM10
,      SUM20
,      SUM30
,      SUM40
,      SUM50
,      SUM60
,      YEAR_TO_DATE
,      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_BUDGET_INTERIM;

Dependencies

[top of page]

GL.GL_BUDGET_INTERIM does not reference any database object

GL.GL_BUDGET_INTERIM is referenced by following:

SchemaAPPS
SynonymGL_BUDGET_INTERIM