VIEW: BIM.BIM_R_FUND_WEEKLY_FACTS#

Source

View Text - Preformatted

select FUND_TRANSACTION_ID FUND_TRANSACTION_ID, 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, 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, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, FUND_TYPE FUND_TYPE, REGION REGION, COUNTRY COUNTRY, CATEGORY_ID CATEGORY_ID, STATUS STATUS, ORIGINAL_BUDGET ORIGINAL_BUDGET, TRANSFER_IN TRANSFER_IN, TRANSFER_OUT TRANSFER_OUT, HOLDBACK_AMT HOLDBACK_AMT, CURRENCY_CODE_FC CURRENCY_CODE_FC, DELETE_FLAG DELETE_FLAG, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, LOAD_DATE LOAD_DATE, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, FIS_MONTH FIS_MONTH, FIS_QTR FIS_QTR, FIS_YEAR FIS_YEAR, BUSINESS_UNIT_ID BUSINESS_UNIT_ID from "BIM"."BIM_R_FUND_WEEKLY_FACTS"

View Text - HTML Formatted

SELECT FUND_TRANSACTION_ID FUND_TRANSACTION_ID
, 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
, 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
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, FUND_TYPE FUND_TYPE
, REGION REGION
, COUNTRY COUNTRY
, CATEGORY_ID CATEGORY_ID
, STATUS STATUS
, ORIGINAL_BUDGET ORIGINAL_BUDGET
, TRANSFER_IN TRANSFER_IN
, TRANSFER_OUT TRANSFER_OUT
, HOLDBACK_AMT HOLDBACK_AMT
, CURRENCY_CODE_FC CURRENCY_CODE_FC
, DELETE_FLAG DELETE_FLAG
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, LOAD_DATE LOAD_DATE
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, FIS_MONTH FIS_MONTH
, FIS_QTR FIS_QTR
, FIS_YEAR FIS_YEAR
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
FROM "BIM"."BIM_R_FUND_WEEKLY_FACTS"