[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BUDGET_RANGE_INTERIM |
|---|---|
| Object Type: | TABLE |
| Owner: | GL |
| FND Design Data: |  SQLGL.GL_BUDGET_RANGE_INTERIM
|
| Subobject Name: | |
| Status: | VALID |
GL_BUDGET_RANGE_INTERIM is used internally by Oracle General Ledger applications to post budget balances that you enter using the Enter Budget Amounts form. When you enter budget amounts using the Enter Budget Amounts form, you add rows to this table. The budget posting program deletes those rows when it posts your budget amounts.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| GL_BUDGET_RANGE_INTERIM_N1 | NORMAL | NONUNIQUE |
APPS_TS_INTERFACE
|
 CODE_COMBINATION_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| 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 |
| 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 |
| START_PERIOD_NAME | VARCHAR2 | (25) | Yes | Beginning accounting period |
| START_PERIOD_NUM | NUMBER | (15) | Yes | Beginning accounting period number |
| DR_FLAG | VARCHAR2 | (1) | Yes | Debit/Credit flag |
| STATUS_NUMBER | NUMBER | (15) | Yes | 0 for new budget records, request id when Budget Posting starts |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard Who 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 | ||
| OLD_PERIOD1_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD2_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD3_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD4_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD5_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD6_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD7_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD8_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD9_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD10_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD11_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD12_AMOUNT | NUMBER | Old budget period amount | ||
| OLD_PERIOD13_AMOUNT | NUMBER | Old budget period 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 | |
| ACCOUNT_TYPE | VARCHAR2 | (25) | Key flexfield combination type (Asset, Liability, etc.) | |
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | (15) | Standard Who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard Who column | |
| JE_DRCR_SIGN_REFERENCE | VARCHAR2 | (15) | Signs of amounts for budget journals | |
| JE_LINE_DESCRIPTION1 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION2 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION3 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION4 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION5 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION6 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION7 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION8 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION9 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION10 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION11 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION12 | VARCHAR2 | (240) | Line description for budget journals | |
| JE_LINE_DESCRIPTION13 | VARCHAR2 | (240) | Line description for budget journals | |
| STAT_AMOUNT1 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT2 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT3 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT4 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT5 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT6 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT7 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT8 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT9 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT10 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT11 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT12 | NUMBER | Statistical amount for budget journals | ||
| STAT_AMOUNT13 | NUMBER | Statistical amount for budget journals |
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
, START_PERIOD_NAME
, START_PERIOD_NUM
, DR_FLAG
, STATUS_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, 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
, OLD_PERIOD1_AMOUNT
, OLD_PERIOD2_AMOUNT
, OLD_PERIOD3_AMOUNT
, OLD_PERIOD4_AMOUNT
, OLD_PERIOD5_AMOUNT
, OLD_PERIOD6_AMOUNT
, OLD_PERIOD7_AMOUNT
, OLD_PERIOD8_AMOUNT
, OLD_PERIOD9_AMOUNT
, OLD_PERIOD10_AMOUNT
, OLD_PERIOD11_AMOUNT
, OLD_PERIOD12_AMOUNT
, OLD_PERIOD13_AMOUNT
, 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
, ACCOUNT_TYPE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, JE_DRCR_SIGN_REFERENCE
, JE_LINE_DESCRIPTION1
, JE_LINE_DESCRIPTION2
, JE_LINE_DESCRIPTION3
, JE_LINE_DESCRIPTION4
, JE_LINE_DESCRIPTION5
, JE_LINE_DESCRIPTION6
, JE_LINE_DESCRIPTION7
, JE_LINE_DESCRIPTION8
, JE_LINE_DESCRIPTION9
, JE_LINE_DESCRIPTION10
, JE_LINE_DESCRIPTION11
, JE_LINE_DESCRIPTION12
, JE_LINE_DESCRIPTION13
, STAT_AMOUNT1
, STAT_AMOUNT2
, STAT_AMOUNT3
, STAT_AMOUNT4
, STAT_AMOUNT5
, STAT_AMOUNT6
, STAT_AMOUNT7
, STAT_AMOUNT8
, STAT_AMOUNT9
, STAT_AMOUNT10
, STAT_AMOUNT11
, STAT_AMOUNT12
, STAT_AMOUNT13
FROM GL.GL_BUDGET_RANGE_INTERIM;
GL.GL_BUDGET_RANGE_INTERIM does not reference any database object
GL.GL_BUDGET_RANGE_INTERIM is referenced by following:
APPS
GL_BUDGET_RANGE_INTERIM
|
|
|
|