VIEW: GL.GL_BUDGET_RANGE_INTERIM#

Source

View Text - Preformatted

select LEDGER_ID LEDGER_ID, CODE_COMBINATION_ID CODE_COMBINATION_ID, CURRENCY_CODE CURRENCY_CODE, BUDGET_VERSION_ID BUDGET_VERSION_ID, BUDGET_ENTITY_ID BUDGET_ENTITY_ID, PERIOD_YEAR PERIOD_YEAR, PERIOD_TYPE PERIOD_TYPE, START_PERIOD_NAME START_PERIOD_NAME, START_PERIOD_NUM START_PERIOD_NUM, DR_FLAG DR_FLAG, STATUS_NUMBER STATUS_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, 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, OLD_PERIOD1_AMOUNT OLD_PERIOD1_AMOUNT, OLD_PERIOD2_AMOUNT OLD_PERIOD2_AMOUNT, OLD_PERIOD3_AMOUNT OLD_PERIOD3_AMOUNT, OLD_PERIOD4_AMOUNT OLD_PERIOD4_AMOUNT, OLD_PERIOD5_AMOUNT OLD_PERIOD5_AMOUNT, OLD_PERIOD6_AMOUNT OLD_PERIOD6_AMOUNT, OLD_PERIOD7_AMOUNT OLD_PERIOD7_AMOUNT, OLD_PERIOD8_AMOUNT OLD_PERIOD8_AMOUNT, OLD_PERIOD9_AMOUNT OLD_PERIOD9_AMOUNT, OLD_PERIOD10_AMOUNT OLD_PERIOD10_AMOUNT, OLD_PERIOD11_AMOUNT OLD_PERIOD11_AMOUNT, OLD_PERIOD12_AMOUNT OLD_PERIOD12_AMOUNT, OLD_PERIOD13_AMOUNT OLD_PERIOD13_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, ACCOUNT_TYPE ACCOUNT_TYPE, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, JE_DRCR_SIGN_REFERENCE JE_DRCR_SIGN_REFERENCE, JE_LINE_DESCRIPTION1 JE_LINE_DESCRIPTION1, JE_LINE_DESCRIPTION2 JE_LINE_DESCRIPTION2, JE_LINE_DESCRIPTION3 JE_LINE_DESCRIPTION3, JE_LINE_DESCRIPTION4 JE_LINE_DESCRIPTION4, JE_LINE_DESCRIPTION5 JE_LINE_DESCRIPTION5, JE_LINE_DESCRIPTION6 JE_LINE_DESCRIPTION6, JE_LINE_DESCRIPTION7 JE_LINE_DESCRIPTION7, JE_LINE_DESCRIPTION8 JE_LINE_DESCRIPTION8, JE_LINE_DESCRIPTION9 JE_LINE_DESCRIPTION9, JE_LINE_DESCRIPTION10 JE_LINE_DESCRIPTION10, JE_LINE_DESCRIPTION11 JE_LINE_DESCRIPTION11, JE_LINE_DESCRIPTION12 JE_LINE_DESCRIPTION12, JE_LINE_DESCRIPTION13 JE_LINE_DESCRIPTION13, STAT_AMOUNT1 STAT_AMOUNT1, STAT_AMOUNT2 STAT_AMOUNT2, STAT_AMOUNT3 STAT_AMOUNT3, STAT_AMOUNT4 STAT_AMOUNT4, STAT_AMOUNT5 STAT_AMOUNT5, STAT_AMOUNT6 STAT_AMOUNT6, STAT_AMOUNT7 STAT_AMOUNT7, STAT_AMOUNT8 STAT_AMOUNT8, STAT_AMOUNT9 STAT_AMOUNT9, STAT_AMOUNT10 STAT_AMOUNT10, STAT_AMOUNT11 STAT_AMOUNT11, STAT_AMOUNT12 STAT_AMOUNT12, STAT_AMOUNT13 STAT_AMOUNT13 from "GL"."GL_BUDGET_RANGE_INTERIM"

View Text - HTML Formatted

SELECT LEDGER_ID LEDGER_ID
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, CURRENCY_CODE CURRENCY_CODE
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, BUDGET_ENTITY_ID BUDGET_ENTITY_ID
, PERIOD_YEAR PERIOD_YEAR
, PERIOD_TYPE PERIOD_TYPE
, START_PERIOD_NAME START_PERIOD_NAME
, START_PERIOD_NUM START_PERIOD_NUM
, DR_FLAG DR_FLAG
, STATUS_NUMBER STATUS_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, 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
, OLD_PERIOD1_AMOUNT OLD_PERIOD1_AMOUNT
, OLD_PERIOD2_AMOUNT OLD_PERIOD2_AMOUNT
, OLD_PERIOD3_AMOUNT OLD_PERIOD3_AMOUNT
, OLD_PERIOD4_AMOUNT OLD_PERIOD4_AMOUNT
, OLD_PERIOD5_AMOUNT OLD_PERIOD5_AMOUNT
, OLD_PERIOD6_AMOUNT OLD_PERIOD6_AMOUNT
, OLD_PERIOD7_AMOUNT OLD_PERIOD7_AMOUNT
, OLD_PERIOD8_AMOUNT OLD_PERIOD8_AMOUNT
, OLD_PERIOD9_AMOUNT OLD_PERIOD9_AMOUNT
, OLD_PERIOD10_AMOUNT OLD_PERIOD10_AMOUNT
, OLD_PERIOD11_AMOUNT OLD_PERIOD11_AMOUNT
, OLD_PERIOD12_AMOUNT OLD_PERIOD12_AMOUNT
, OLD_PERIOD13_AMOUNT OLD_PERIOD13_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
, ACCOUNT_TYPE ACCOUNT_TYPE
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, JE_DRCR_SIGN_REFERENCE JE_DRCR_SIGN_REFERENCE
, JE_LINE_DESCRIPTION1 JE_LINE_DESCRIPTION1
, JE_LINE_DESCRIPTION2 JE_LINE_DESCRIPTION2
, JE_LINE_DESCRIPTION3 JE_LINE_DESCRIPTION3
, JE_LINE_DESCRIPTION4 JE_LINE_DESCRIPTION4
, JE_LINE_DESCRIPTION5 JE_LINE_DESCRIPTION5
, JE_LINE_DESCRIPTION6 JE_LINE_DESCRIPTION6
, JE_LINE_DESCRIPTION7 JE_LINE_DESCRIPTION7
, JE_LINE_DESCRIPTION8 JE_LINE_DESCRIPTION8
, JE_LINE_DESCRIPTION9 JE_LINE_DESCRIPTION9
, JE_LINE_DESCRIPTION10 JE_LINE_DESCRIPTION10
, JE_LINE_DESCRIPTION11 JE_LINE_DESCRIPTION11
, JE_LINE_DESCRIPTION12 JE_LINE_DESCRIPTION12
, JE_LINE_DESCRIPTION13 JE_LINE_DESCRIPTION13
, STAT_AMOUNT1 STAT_AMOUNT1
, STAT_AMOUNT2 STAT_AMOUNT2
, STAT_AMOUNT3 STAT_AMOUNT3
, STAT_AMOUNT4 STAT_AMOUNT4
, STAT_AMOUNT5 STAT_AMOUNT5
, STAT_AMOUNT6 STAT_AMOUNT6
, STAT_AMOUNT7 STAT_AMOUNT7
, STAT_AMOUNT8 STAT_AMOUNT8
, STAT_AMOUNT9 STAT_AMOUNT9
, STAT_AMOUNT10 STAT_AMOUNT10
, STAT_AMOUNT11 STAT_AMOUNT11
, STAT_AMOUNT12 STAT_AMOUNT12
, STAT_AMOUNT13 STAT_AMOUNT13
FROM "GL"."GL_BUDGET_RANGE_INTERIM"