eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: GL.GL_BUDGET_INTERFACE#

Source

View Text - Preformatted


select BUDGET_NAME BUDGET_NAME, BUDGET_ENTITY_NAME BUDGET_ENTITY_NAME, CURRENCY_CODE CURRENCY_CODE, FISCAL_YEAR FISCAL_YEAR, UPDATE_LOGIC_TYPE UPDATE_LOGIC_TYPE, BUDGET_ENTITY_ID BUDGET_ENTITY_ID, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, PERIOD_TYPE PERIOD_TYPE, DR_FLAG DR_FLAG, STATUS STATUS, ACCOUNT_TYPE ACCOUNT_TYPE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PERIOD1_AMOUNT PERIOD1_AMOUNT, PERIOD2_AMOUNT PERIOD2_AMOUNT, PERIOD3_AMOUNT PERIOD3_AMOUNT, PERIOD4_AMOUNT PERIOD4_AMOUNT, PERIOD5_AMOUNT PERIOD5_AMOUNT, PERIOD6_AMOUNT PERIOD6_AMOUNT, PERIOD7_AMOUNT PERIOD7_AMOUNT, PERIOD8_AMOUNT PERIOD8_AMOUNT, PERIOD9_AMOUNT PERIOD9_AMOUNT, PERIOD10_AMOUNT PERIOD10_AMOUNT, PERIOD11_AMOUNT PERIOD11_AMOUNT, PERIOD12_AMOUNT PERIOD12_AMOUNT, PERIOD13_AMOUNT PERIOD13_AMOUNT, PERIOD14_AMOUNT PERIOD14_AMOUNT, PERIOD15_AMOUNT PERIOD15_AMOUNT, PERIOD16_AMOUNT PERIOD16_AMOUNT, PERIOD17_AMOUNT PERIOD17_AMOUNT, PERIOD18_AMOUNT PERIOD18_AMOUNT, PERIOD19_AMOUNT PERIOD19_AMOUNT, PERIOD20_AMOUNT PERIOD20_AMOUNT, PERIOD21_AMOUNT PERIOD21_AMOUNT, PERIOD22_AMOUNT PERIOD22_AMOUNT, PERIOD23_AMOUNT PERIOD23_AMOUNT, PERIOD24_AMOUNT PERIOD24_AMOUNT, PERIOD25_AMOUNT PERIOD25_AMOUNT, PERIOD26_AMOUNT PERIOD26_AMOUNT, PERIOD27_AMOUNT PERIOD27_AMOUNT, PERIOD28_AMOUNT PERIOD28_AMOUNT, PERIOD29_AMOUNT PERIOD29_AMOUNT, PERIOD30_AMOUNT PERIOD30_AMOUNT, PERIOD31_AMOUNT PERIOD31_AMOUNT, PERIOD32_AMOUNT PERIOD32_AMOUNT, PERIOD33_AMOUNT PERIOD33_AMOUNT, PERIOD34_AMOUNT PERIOD34_AMOUNT, PERIOD35_AMOUNT PERIOD35_AMOUNT, PERIOD36_AMOUNT PERIOD36_AMOUNT, PERIOD37_AMOUNT PERIOD37_AMOUNT, PERIOD38_AMOUNT PERIOD38_AMOUNT, PERIOD39_AMOUNT PERIOD39_AMOUNT, PERIOD40_AMOUNT PERIOD40_AMOUNT, PERIOD41_AMOUNT PERIOD41_AMOUNT, PERIOD42_AMOUNT PERIOD42_AMOUNT, PERIOD43_AMOUNT PERIOD43_AMOUNT, PERIOD44_AMOUNT PERIOD44_AMOUNT, PERIOD45_AMOUNT PERIOD45_AMOUNT, PERIOD46_AMOUNT PERIOD46_AMOUNT, PERIOD47_AMOUNT PERIOD47_AMOUNT, PERIOD48_AMOUNT PERIOD48_AMOUNT, PERIOD49_AMOUNT PERIOD49_AMOUNT, PERIOD50_AMOUNT PERIOD50_AMOUNT, PERIOD51_AMOUNT PERIOD51_AMOUNT, PERIOD52_AMOUNT PERIOD52_AMOUNT, PERIOD53_AMOUNT PERIOD53_AMOUNT, PERIOD54_AMOUNT PERIOD54_AMOUNT, PERIOD55_AMOUNT PERIOD55_AMOUNT, PERIOD56_AMOUNT PERIOD56_AMOUNT, PERIOD57_AMOUNT PERIOD57_AMOUNT, PERIOD58_AMOUNT PERIOD58_AMOUNT, PERIOD59_AMOUNT PERIOD59_AMOUNT, PERIOD60_AMOUNT PERIOD60_AMOUNT, SEGMENT1 SEGMENT1, SEGMENT2 SEGMENT2, SEGMENT3 SEGMENT3, SEGMENT4 SEGMENT4, SEGMENT5 SEGMENT5, SEGMENT6 SEGMENT6, SEGMENT7 SEGMENT7, SEGMENT8 SEGMENT8, SEGMENT9 SEGMENT9, SEGMENT10 SEGMENT10, SEGMENT11 SEGMENT11, SEGMENT12 SEGMENT12, SEGMENT13 SEGMENT13, SEGMENT14 SEGMENT14, SEGMENT15 SEGMENT15, SEGMENT16 SEGMENT16, SEGMENT17 SEGMENT17, SEGMENT18 SEGMENT18, SEGMENT19 SEGMENT19, SEGMENT20 SEGMENT20, SEGMENT21 SEGMENT21, SEGMENT22 SEGMENT22, SEGMENT23 SEGMENT23, SEGMENT24 SEGMENT24, SEGMENT25 SEGMENT25, SEGMENT26 SEGMENT26, SEGMENT27 SEGMENT27, SEGMENT28 SEGMENT28, SEGMENT29 SEGMENT29, SEGMENT30 SEGMENT30, LEDGER_ID LEDGER_ID from "GL"."GL_BUDGET_INTERFACE"

View Text - HTML Formatted

SELECT BUDGET_NAME BUDGET_NAME
, BUDGET_ENTITY_NAME BUDGET_ENTITY_NAME
, CURRENCY_CODE CURRENCY_CODE
, FISCAL_YEAR FISCAL_YEAR
, UPDATE_LOGIC_TYPE UPDATE_LOGIC_TYPE
, BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, PERIOD_TYPE PERIOD_TYPE
, DR_FLAG DR_FLAG
, STATUS STATUS
, ACCOUNT_TYPE ACCOUNT_TYPE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PERIOD1_AMOUNT PERIOD1_AMOUNT
, PERIOD2_AMOUNT PERIOD2_AMOUNT
, PERIOD3_AMOUNT PERIOD3_AMOUNT
, PERIOD4_AMOUNT PERIOD4_AMOUNT
, PERIOD5_AMOUNT PERIOD5_AMOUNT
, PERIOD6_AMOUNT PERIOD6_AMOUNT
, PERIOD7_AMOUNT PERIOD7_AMOUNT
, PERIOD8_AMOUNT PERIOD8_AMOUNT
, PERIOD9_AMOUNT PERIOD9_AMOUNT
, PERIOD10_AMOUNT PERIOD10_AMOUNT
, PERIOD11_AMOUNT PERIOD11_AMOUNT
, PERIOD12_AMOUNT PERIOD12_AMOUNT
, PERIOD13_AMOUNT PERIOD13_AMOUNT
, PERIOD14_AMOUNT PERIOD14_AMOUNT
, PERIOD15_AMOUNT PERIOD15_AMOUNT
, PERIOD16_AMOUNT PERIOD16_AMOUNT
, PERIOD17_AMOUNT PERIOD17_AMOUNT
, PERIOD18_AMOUNT PERIOD18_AMOUNT
, PERIOD19_AMOUNT PERIOD19_AMOUNT
, PERIOD20_AMOUNT PERIOD20_AMOUNT
, PERIOD21_AMOUNT PERIOD21_AMOUNT
, PERIOD22_AMOUNT PERIOD22_AMOUNT
, PERIOD23_AMOUNT PERIOD23_AMOUNT
, PERIOD24_AMOUNT PERIOD24_AMOUNT
, PERIOD25_AMOUNT PERIOD25_AMOUNT
, PERIOD26_AMOUNT PERIOD26_AMOUNT
, PERIOD27_AMOUNT PERIOD27_AMOUNT
, PERIOD28_AMOUNT PERIOD28_AMOUNT
, PERIOD29_AMOUNT PERIOD29_AMOUNT
, PERIOD30_AMOUNT PERIOD30_AMOUNT
, PERIOD31_AMOUNT PERIOD31_AMOUNT
, PERIOD32_AMOUNT PERIOD32_AMOUNT
, PERIOD33_AMOUNT PERIOD33_AMOUNT
, PERIOD34_AMOUNT PERIOD34_AMOUNT
, PERIOD35_AMOUNT PERIOD35_AMOUNT
, PERIOD36_AMOUNT PERIOD36_AMOUNT
, PERIOD37_AMOUNT PERIOD37_AMOUNT
, PERIOD38_AMOUNT PERIOD38_AMOUNT
, PERIOD39_AMOUNT PERIOD39_AMOUNT
, PERIOD40_AMOUNT PERIOD40_AMOUNT
, PERIOD41_AMOUNT PERIOD41_AMOUNT
, PERIOD42_AMOUNT PERIOD42_AMOUNT
, PERIOD43_AMOUNT PERIOD43_AMOUNT
, PERIOD44_AMOUNT PERIOD44_AMOUNT
, PERIOD45_AMOUNT PERIOD45_AMOUNT
, PERIOD46_AMOUNT PERIOD46_AMOUNT
, PERIOD47_AMOUNT PERIOD47_AMOUNT
, PERIOD48_AMOUNT PERIOD48_AMOUNT
, PERIOD49_AMOUNT PERIOD49_AMOUNT
, PERIOD50_AMOUNT PERIOD50_AMOUNT
, PERIOD51_AMOUNT PERIOD51_AMOUNT
, PERIOD52_AMOUNT PERIOD52_AMOUNT
, PERIOD53_AMOUNT PERIOD53_AMOUNT
, PERIOD54_AMOUNT PERIOD54_AMOUNT
, PERIOD55_AMOUNT PERIOD55_AMOUNT
, PERIOD56_AMOUNT PERIOD56_AMOUNT
, PERIOD57_AMOUNT PERIOD57_AMOUNT
, PERIOD58_AMOUNT PERIOD58_AMOUNT
, PERIOD59_AMOUNT PERIOD59_AMOUNT
, PERIOD60_AMOUNT PERIOD60_AMOUNT
, SEGMENT1 SEGMENT1
, SEGMENT2 SEGMENT2
, SEGMENT3 SEGMENT3
, SEGMENT4 SEGMENT4
, SEGMENT5 SEGMENT5
, SEGMENT6 SEGMENT6
, SEGMENT7 SEGMENT7
, SEGMENT8 SEGMENT8
, SEGMENT9 SEGMENT9
, SEGMENT10 SEGMENT10
, SEGMENT11 SEGMENT11
, SEGMENT12 SEGMENT12
, SEGMENT13 SEGMENT13
, SEGMENT14 SEGMENT14
, SEGMENT15 SEGMENT15
, SEGMENT16 SEGMENT16
, SEGMENT17 SEGMENT17
, SEGMENT18 SEGMENT18
, SEGMENT19 SEGMENT19
, SEGMENT20 SEGMENT20
, SEGMENT21 SEGMENT21
, SEGMENT22 SEGMENT22
, SEGMENT23 SEGMENT23
, SEGMENT24 SEGMENT24
, SEGMENT25 SEGMENT25
, SEGMENT26 SEGMENT26
, SEGMENT27 SEGMENT27
, SEGMENT28 SEGMENT28
, SEGMENT29 SEGMENT29
, SEGMENT30 SEGMENT30
, LEDGER_ID LEDGER_ID
FROM "GL"."GL_BUDGET_INTERFACE"