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

Source

View Text - Preformatted


select CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, 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, BALANCE BALANCE, PRE_BALANCE PRE_BALANCE, COMMITTED COMMITTED, PRE_COMMITTED PRE_COMMITTED, UTILIZED UTILIZED, PRE_UTILIZED PRE_UTILIZED, DISPLAY_TYPE DISPLAY_TYPE, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, PLANNED PLANNED, PAID PAID from "BIM"."BIM_R_FUND_DIMSUM"

View Text - HTML Formatted

SELECT CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, 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
, BALANCE BALANCE
, PRE_BALANCE PRE_BALANCE
, COMMITTED COMMITTED
, PRE_COMMITTED PRE_COMMITTED
, UTILIZED UTILIZED
, PRE_UTILIZED PRE_UTILIZED
, DISPLAY_TYPE DISPLAY_TYPE
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, PLANNED PLANNED
, PAID PAID
FROM "BIM"."BIM_R_FUND_DIMSUM"