VIEW: BIM.BIM_R_FD_SUMMARY_MV#

Source

View Text - Preformatted

select FUND_ID FUND_ID, FUND_NAME FUND_NAME, PARENT_FUND_ID PARENT_FUND_ID, FUND_NUMBER FUND_NUMBER, START_DATE START_DATE, END_DATE END_DATE, START_PERIOD START_PERIOD, END_PERIOD END_PERIOD, FUND_TYPE FUND_TYPE, AREA1_CODE AREA1_CODE, AREA2_CODE AREA2_CODE, COUNTRY_CODE COUNTRY_CODE, CATEGORY_ID CATEGORY_ID, STATUS STATUS, MONTH MONTH, QTR QTR, YEAR YEAR, AGGREGATE_BY AGGREGATE_BY, ORIGINAL_BUDGET ORIGINAL_BUDGET, HOLDBACK_AMT HOLDBACK_AMT, CURRENCY_CODE_FC CURRENCY_CODE_FC, TOTAL_BUDGET TOTAL_BUDGET, AVAILABLE_BUDGET AVAILABLE_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_SUMMARY_MV"

View Text - HTML Formatted

SELECT FUND_ID FUND_ID
, FUND_NAME FUND_NAME
, PARENT_FUND_ID PARENT_FUND_ID
, FUND_NUMBER FUND_NUMBER
, START_DATE START_DATE
, END_DATE END_DATE
, START_PERIOD START_PERIOD
, END_PERIOD END_PERIOD
, FUND_TYPE FUND_TYPE
, AREA1_CODE AREA1_CODE
, AREA2_CODE AREA2_CODE
, COUNTRY_CODE COUNTRY_CODE
, CATEGORY_ID CATEGORY_ID
, STATUS STATUS
, MONTH MONTH
, QTR QTR
, YEAR YEAR
, AGGREGATE_BY AGGREGATE_BY
, ORIGINAL_BUDGET ORIGINAL_BUDGET
, HOLDBACK_AMT HOLDBACK_AMT
, CURRENCY_CODE_FC CURRENCY_CODE_FC
, TOTAL_BUDGET TOTAL_BUDGET
, AVAILABLE_BUDGET AVAILABLE_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_SUMMARY_MV"