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_FP_DIM_SUM_MV#

Source

View Text - Preformatted


select FUND_COUNT FUND_COUNT, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, OBJECT_TYPE OBJECT_TYPE, YEAR YEAR, QTR QTR, MONTH MONTH, MONTH_ORDER MONTH_ORDER, AGGREGATE_BY AGGREGATE_BY, UTILIZED UTILIZED, COMMITED_AMT COMMITED_AMT, PLANNED_AMT PLANNED_AMT, PAID_AMT PAID_AMT, DISPLAY_TYPE DISPLAY_TYPE, FUND_TYPE FUND_TYPE, AREA2_CODE AREA2_CODE, COUNTRY_CODE COUNTRY_CODE, FUND_BUSINESS_ID FUND_BUSINESS_ID, CATEGORY_ID CATEGORY_ID, STATUS STATUS, RESOURCE_ID RESOURCE_ID from "BIM"."BIM_R_FP_DIM_SUM_MV"

View Text - HTML Formatted

SELECT FUND_COUNT FUND_COUNT
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, OBJECT_TYPE OBJECT_TYPE
, YEAR YEAR
, QTR QTR
, MONTH MONTH
, MONTH_ORDER MONTH_ORDER
, AGGREGATE_BY AGGREGATE_BY
, UTILIZED UTILIZED
, COMMITED_AMT COMMITED_AMT
, PLANNED_AMT PLANNED_AMT
, PAID_AMT PAID_AMT
, DISPLAY_TYPE DISPLAY_TYPE
, FUND_TYPE FUND_TYPE
, AREA2_CODE AREA2_CODE
, COUNTRY_CODE COUNTRY_CODE
, FUND_BUSINESS_ID FUND_BUSINESS_ID
, CATEGORY_ID CATEGORY_ID
, STATUS STATUS
, RESOURCE_ID RESOURCE_ID
FROM "BIM"."BIM_R_FP_DIM_SUM_MV"