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: BIM.BIM_R_FD_DIM_SUM_MV#

Source

View Text - Preformatted


select FUND_COUNT FUND_COUNT, FUND_TYPE FUND_TYPE, AREA1_CODE AREA1_CODE, AREA2_CODE AREA2_CODE, COUNTRY_CODE COUNTRY_CODE, CATEGORY_ID CATEGORY_ID, STATUS STATUS, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, AVAILABLE_BUDGET AVAILABLE_BUDGET, HOLDBACK_AMT HOLDBACK_AMT, ORIGINAL_BUDGET ORIGINAL_BUDGET, TOTAL_BUDGET TOTAL_BUDGET, PRE_BALANCE PRE_BALANCE, BALANCE BALANCE, PRE_COMMITED PRE_COMMITED, COMMITED COMMITED, PRE_UTILIZED PRE_UTILIZED, UTILIZED UTILIZED, PLANNED PLANNED, PAID PAID, DISPLAY_TYPE DISPLAY_TYPE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, RESOURCE_ID RESOURCE_ID from "BIM"."BIM_R_FD_DIM_SUM_MV"

View Text - HTML Formatted

SELECT FUND_COUNT FUND_COUNT
, FUND_TYPE FUND_TYPE
, AREA1_CODE AREA1_CODE
, AREA2_CODE AREA2_CODE
, COUNTRY_CODE COUNTRY_CODE
, CATEGORY_ID CATEGORY_ID
, STATUS STATUS
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, AVAILABLE_BUDGET AVAILABLE_BUDGET
, HOLDBACK_AMT HOLDBACK_AMT
, ORIGINAL_BUDGET ORIGINAL_BUDGET
, TOTAL_BUDGET TOTAL_BUDGET
, PRE_BALANCE PRE_BALANCE
, BALANCE BALANCE
, PRE_COMMITED PRE_COMMITED
, COMMITED COMMITED
, PRE_UTILIZED PRE_UTILIZED
, UTILIZED UTILIZED
, PLANNED PLANNED
, PAID PAID
, DISPLAY_TYPE DISPLAY_TYPE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, RESOURCE_ID RESOURCE_ID
FROM "BIM"."BIM_R_FD_DIM_SUM_MV"