VIEW: BIM.BIM_R_FP_SUMMARY_MV#

Source

View Text - Preformatted

select FUND_ID FUND_ID, FUND_NAME FUND_NAME, MONTH MONTH, QTR QTR, YEAR YEAR, AGGREGATE_BY AGGREGATE_BY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, UTILIZED UTILIZED, COMMITED_AMT COMMITED_AMT, PLANNED_AMT PLANNED_AMT, PAID_AMT PAID_AMT, UTIL_ORG_ID UTIL_ORG_ID, DISPLAY_TYPE DISPLAY_TYPE, FUND_TYPE FUND_TYPE, AREA1_CODE AREA1_CODE, 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_SUMMARY_MV"

View Text - HTML Formatted

SELECT FUND_ID FUND_ID
, FUND_NAME FUND_NAME
, MONTH MONTH
, QTR QTR
, YEAR YEAR
, AGGREGATE_BY AGGREGATE_BY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, UTILIZED UTILIZED
, COMMITED_AMT COMMITED_AMT
, PLANNED_AMT PLANNED_AMT
, PAID_AMT PAID_AMT
, UTIL_ORG_ID UTIL_ORG_ID
, DISPLAY_TYPE DISPLAY_TYPE
, FUND_TYPE FUND_TYPE
, AREA1_CODE AREA1_CODE
, 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_SUMMARY_MV"