[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#;
|
|
|