[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | GL_BUDGET_INTERFACE# |
|---|---|
| Object Type: | VIEW |
| Owner: | GL |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BUDGET_NAME | VARCHAR2 | (15) | Yes | |
| BUDGET_ENTITY_NAME | VARCHAR2 | (25) | Yes | |
| CURRENCY_CODE | VARCHAR2 | (15) | Yes | |
| FISCAL_YEAR | NUMBER | (15) | Yes | |
| UPDATE_LOGIC_TYPE | VARCHAR2 | (1) | Yes | |
| BUDGET_ENTITY_ID | NUMBER | (15) | ||
| SET_OF_BOOKS_ID | NUMBER | (15) | ||
| CODE_COMBINATION_ID | NUMBER | (15) | ||
| BUDGET_VERSION_ID | NUMBER | (15) | ||
| PERIOD_TYPE | VARCHAR2 | (15) | ||
| DR_FLAG | VARCHAR2 | (1) | ||
| STATUS | VARCHAR2 | (1) | ||
| ACCOUNT_TYPE | VARCHAR2 | (25) | ||
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| REQUEST_ID | NUMBER | (15) | ||
| 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 | |||
| PERIOD14_AMOUNT | NUMBER | |||
| PERIOD15_AMOUNT | NUMBER | |||
| PERIOD16_AMOUNT | NUMBER | |||
| PERIOD17_AMOUNT | NUMBER | |||
| PERIOD18_AMOUNT | NUMBER | |||
| PERIOD19_AMOUNT | NUMBER | |||
| PERIOD20_AMOUNT | NUMBER | |||
| PERIOD21_AMOUNT | NUMBER | |||
| PERIOD22_AMOUNT | NUMBER | |||
| PERIOD23_AMOUNT | NUMBER | |||
| PERIOD24_AMOUNT | NUMBER | |||
| PERIOD25_AMOUNT | NUMBER | |||
| PERIOD26_AMOUNT | NUMBER | |||
| PERIOD27_AMOUNT | NUMBER | |||
| PERIOD28_AMOUNT | NUMBER | |||
| PERIOD29_AMOUNT | NUMBER | |||
| PERIOD30_AMOUNT | NUMBER | |||
| PERIOD31_AMOUNT | NUMBER | |||
| PERIOD32_AMOUNT | NUMBER | |||
| PERIOD33_AMOUNT | NUMBER | |||
| PERIOD34_AMOUNT | NUMBER | |||
| PERIOD35_AMOUNT | NUMBER | |||
| PERIOD36_AMOUNT | NUMBER | |||
| PERIOD37_AMOUNT | NUMBER | |||
| PERIOD38_AMOUNT | NUMBER | |||
| PERIOD39_AMOUNT | NUMBER | |||
| PERIOD40_AMOUNT | NUMBER | |||
| PERIOD41_AMOUNT | NUMBER | |||
| PERIOD42_AMOUNT | NUMBER | |||
| PERIOD43_AMOUNT | NUMBER | |||
| PERIOD44_AMOUNT | NUMBER | |||
| PERIOD45_AMOUNT | NUMBER | |||
| PERIOD46_AMOUNT | NUMBER | |||
| PERIOD47_AMOUNT | NUMBER | |||
| PERIOD48_AMOUNT | NUMBER | |||
| PERIOD49_AMOUNT | NUMBER | |||
| PERIOD50_AMOUNT | NUMBER | |||
| PERIOD51_AMOUNT | NUMBER | |||
| PERIOD52_AMOUNT | NUMBER | |||
| PERIOD53_AMOUNT | NUMBER | |||
| PERIOD54_AMOUNT | NUMBER | |||
| PERIOD55_AMOUNT | NUMBER | |||
| PERIOD56_AMOUNT | NUMBER | |||
| PERIOD57_AMOUNT | NUMBER | |||
| PERIOD58_AMOUNT | NUMBER | |||
| PERIOD59_AMOUNT | NUMBER | |||
| PERIOD60_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) | ||
| LEDGER_ID | VARCHAR2 | (15) |
Cut, paste (and edit) the following text to query this object:
SELECT BUDGET_NAME
, BUDGET_ENTITY_NAME
, CURRENCY_CODE
, FISCAL_YEAR
, UPDATE_LOGIC_TYPE
, BUDGET_ENTITY_ID
, SET_OF_BOOKS_ID
, CODE_COMBINATION_ID
, BUDGET_VERSION_ID
, PERIOD_TYPE
, DR_FLAG
, STATUS
, ACCOUNT_TYPE
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, REQUEST_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
, 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
, LEDGER_ID
FROM GL.GL_BUDGET_INTERFACE#;
GL
GL_BUDGET_INTERFACE
APPS
GL_BUDGET_INTERFACE
|
|
|
|