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.

[Home] [Help]

VIEW: FA.FA_BUDGET_INTERFACE#

Source

View Text - Preformatted


select BOOK_TYPE_CODE BOOK_TYPE_CODE, 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, ACCT_SEGMENT1 ACCT_SEGMENT1, ACCT_SEGMENT2 ACCT_SEGMENT2, ACCT_SEGMENT3 ACCT_SEGMENT3, ACCT_SEGMENT4 ACCT_SEGMENT4, ACCT_SEGMENT5 ACCT_SEGMENT5, ACCT_SEGMENT6 ACCT_SEGMENT6, ACCT_SEGMENT7 ACCT_SEGMENT7, ACCT_SEGMENT8 ACCT_SEGMENT8, ACCT_SEGMENT9 ACCT_SEGMENT9, ACCT_SEGMENT10 ACCT_SEGMENT10, ACCT_SEGMENT11 ACCT_SEGMENT11, ACCT_SEGMENT12 ACCT_SEGMENT12, ACCT_SEGMENT13 ACCT_SEGMENT13, ACCT_SEGMENT14 ACCT_SEGMENT14, ACCT_SEGMENT15 ACCT_SEGMENT15, ACCT_SEGMENT16 ACCT_SEGMENT16, ACCT_SEGMENT17 ACCT_SEGMENT17, ACCT_SEGMENT18 ACCT_SEGMENT18, ACCT_SEGMENT19 ACCT_SEGMENT19, ACCT_SEGMENT20 ACCT_SEGMENT20, ACCT_SEGMENT21 ACCT_SEGMENT21, ACCT_SEGMENT22 ACCT_SEGMENT22, ACCT_SEGMENT23 ACCT_SEGMENT23, ACCT_SEGMENT24 ACCT_SEGMENT24, ACCT_SEGMENT25 ACCT_SEGMENT25, ACCT_SEGMENT26 ACCT_SEGMENT26, ACCT_SEGMENT27 ACCT_SEGMENT27, ACCT_SEGMENT28 ACCT_SEGMENT28, ACCT_SEGMENT29 ACCT_SEGMENT29, ACCT_SEGMENT30 ACCT_SEGMENT30, CAT_SEGMENT1 CAT_SEGMENT1, CAT_SEGMENT2 CAT_SEGMENT2, CAT_SEGMENT3 CAT_SEGMENT3, CAT_SEGMENT4 CAT_SEGMENT4, CAT_SEGMENT5 CAT_SEGMENT5, CAT_SEGMENT6 CAT_SEGMENT6, CAT_SEGMENT7 CAT_SEGMENT7 from "FA"."FA_BUDGET_INTERFACE"

View Text - HTML Formatted

SELECT BOOK_TYPE_CODE BOOK_TYPE_CODE
, 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
, ACCT_SEGMENT1 ACCT_SEGMENT1
, ACCT_SEGMENT2 ACCT_SEGMENT2
, ACCT_SEGMENT3 ACCT_SEGMENT3
, ACCT_SEGMENT4 ACCT_SEGMENT4
, ACCT_SEGMENT5 ACCT_SEGMENT5
, ACCT_SEGMENT6 ACCT_SEGMENT6
, ACCT_SEGMENT7 ACCT_SEGMENT7
, ACCT_SEGMENT8 ACCT_SEGMENT8
, ACCT_SEGMENT9 ACCT_SEGMENT9
, ACCT_SEGMENT10 ACCT_SEGMENT10
, ACCT_SEGMENT11 ACCT_SEGMENT11
, ACCT_SEGMENT12 ACCT_SEGMENT12
, ACCT_SEGMENT13 ACCT_SEGMENT13
, ACCT_SEGMENT14 ACCT_SEGMENT14
, ACCT_SEGMENT15 ACCT_SEGMENT15
, ACCT_SEGMENT16 ACCT_SEGMENT16
, ACCT_SEGMENT17 ACCT_SEGMENT17
, ACCT_SEGMENT18 ACCT_SEGMENT18
, ACCT_SEGMENT19 ACCT_SEGMENT19
, ACCT_SEGMENT20 ACCT_SEGMENT20
, ACCT_SEGMENT21 ACCT_SEGMENT21
, ACCT_SEGMENT22 ACCT_SEGMENT22
, ACCT_SEGMENT23 ACCT_SEGMENT23
, ACCT_SEGMENT24 ACCT_SEGMENT24
, ACCT_SEGMENT25 ACCT_SEGMENT25
, ACCT_SEGMENT26 ACCT_SEGMENT26
, ACCT_SEGMENT27 ACCT_SEGMENT27
, ACCT_SEGMENT28 ACCT_SEGMENT28
, ACCT_SEGMENT29 ACCT_SEGMENT29
, ACCT_SEGMENT30 ACCT_SEGMENT30
, CAT_SEGMENT1 CAT_SEGMENT1
, CAT_SEGMENT2 CAT_SEGMENT2
, CAT_SEGMENT3 CAT_SEGMENT3
, CAT_SEGMENT4 CAT_SEGMENT4
, CAT_SEGMENT5 CAT_SEGMENT5
, CAT_SEGMENT6 CAT_SEGMENT6
, CAT_SEGMENT7 CAT_SEGMENT7
FROM "FA"."FA_BUDGET_INTERFACE"