[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BUDGET_RANGE_INTERIM# |
|---|---|
| Object Type: | VIEW |
| Owner: | GL |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| LEDGER_ID | NUMBER | (15) | Yes | |
| CODE_COMBINATION_ID | NUMBER | (15) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| BUDGET_VERSION_ID | NUMBER | (15) | Yes | |
| BUDGET_ENTITY_ID | NUMBER | (15) | Yes | |
| PERIOD_YEAR | NUMBER | (15) | Yes | |
| PERIOD_TYPE | VARCHAR2 | (15) | Yes | |
| START_PERIOD_NAME | VARCHAR2 | (25) | Yes | |
| START_PERIOD_NUM | NUMBER | (15) | Yes | |
| DR_FLAG | VARCHAR2 | (1) | Yes | |
| STATUS_NUMBER | NUMBER | (15) | Yes | |
| LAST_UPDATE_DATE | DATE | Yes | ||
| LAST_UPDATED_BY | NUMBER | (15) | Yes | |
| PERIOD1_AMOUNT | NUMBER | |||
| PERIOD2_AMOUNT | NUMBER | |||
| PERIOD3_AMOUNT | NUMBER | |||
| PERIOD4_AMOUNT | NUMBER | |||
| PERIOD5_AMOUNT | NUMBER | |||
| PERIOD6_AMOUNT | NUMBER | |||
| PERIOD7_AMOUNT | NUMBER | |||
| PERIOD8_AMOUNT | NUMBER | |||
| PERIOD9_AMOUNT | NUMBER | |||
| PERIOD10_AMOUNT | NUMBER | |||
| PERIOD11_AMOUNT | NUMBER | |||
| PERIOD12_AMOUNT | NUMBER | |||
| PERIOD13_AMOUNT | NUMBER | |||
| OLD_PERIOD1_AMOUNT | NUMBER | |||
| OLD_PERIOD2_AMOUNT | NUMBER | |||
| OLD_PERIOD3_AMOUNT | NUMBER | |||
| OLD_PERIOD4_AMOUNT | NUMBER | |||
| OLD_PERIOD5_AMOUNT | NUMBER | |||
| OLD_PERIOD6_AMOUNT | NUMBER | |||
| OLD_PERIOD7_AMOUNT | NUMBER | |||
| OLD_PERIOD8_AMOUNT | NUMBER | |||
| OLD_PERIOD9_AMOUNT | NUMBER | |||
| OLD_PERIOD10_AMOUNT | NUMBER | |||
| OLD_PERIOD11_AMOUNT | NUMBER | |||
| OLD_PERIOD12_AMOUNT | NUMBER | |||
| OLD_PERIOD13_AMOUNT | 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) | ||
| ACCOUNT_TYPE | VARCHAR2 | (25) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| JE_DRCR_SIGN_REFERENCE | VARCHAR2 | (15) | ||
| JE_LINE_DESCRIPTION1 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION2 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION3 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION4 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION5 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION6 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION7 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION8 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION9 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION10 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION11 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION12 | VARCHAR2 | (240) | ||
| JE_LINE_DESCRIPTION13 | VARCHAR2 | (240) | ||
| STAT_AMOUNT1 | NUMBER | |||
| STAT_AMOUNT2 | NUMBER | |||
| STAT_AMOUNT3 | NUMBER | |||
| STAT_AMOUNT4 | NUMBER | |||
| STAT_AMOUNT5 | NUMBER | |||
| STAT_AMOUNT6 | NUMBER | |||
| STAT_AMOUNT7 | NUMBER | |||
| STAT_AMOUNT8 | NUMBER | |||
| STAT_AMOUNT9 | NUMBER | |||
| STAT_AMOUNT10 | NUMBER | |||
| STAT_AMOUNT11 | NUMBER | |||
| STAT_AMOUNT12 | NUMBER | |||
| STAT_AMOUNT13 | NUMBER |
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
APPS
GL_BUDGET_RANGE_INTERIM
|
|
|
|