VIEW: BIM.BIM_I_BUDGET_FACTS_STG#

Source

View Text - Preformatted

select 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, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, DELETE_FLAG DELETE_FLAG, METRIC_TYPE METRIC_TYPE, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, ORIGINAL_BUDGET ORIGINAL_BUDGET, TRANSFER_IN TRANSFER_IN, TRANSFER_OUT TRANSFER_OUT, HOLDBACK_AMT HOLDBACK_AMT, PLANNED PLANNED, COMMITTED COMMITTED, UTILIZED UTILIZED, ACCRUAL ACCRUAL, PAID PAID, FROM_CURRENCY FROM_CURRENCY, CONVERSION_RATE CONVERSION_RATE, CURRENCY_CODE_FC CURRENCY_CODE_FC, ORG_ID ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_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, ORIGINAL_BUDGET_S ORIGINAL_BUDGET_S, TRANSFER_IN_S TRANSFER_IN_S, TRANSFER_OUT_S TRANSFER_OUT_S, HOLDBACK_AMT_S HOLDBACK_AMT_S, PLANNED_S PLANNED_S, COMMITTED_S COMMITTED_S, UTILIZED_S UTILIZED_S, ACCRUAL_S ACCRUAL_S, PAID_S PAID_S, CONVERSION_RATE_S CONVERSION_RATE_S from "BIM"."BIM_I_BUDGET_FACTS_STG"

View Text - HTML Formatted

SELECT 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
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, DELETE_FLAG DELETE_FLAG
, METRIC_TYPE METRIC_TYPE
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, ORIGINAL_BUDGET ORIGINAL_BUDGET
, TRANSFER_IN TRANSFER_IN
, TRANSFER_OUT TRANSFER_OUT
, HOLDBACK_AMT HOLDBACK_AMT
, PLANNED PLANNED
, COMMITTED COMMITTED
, UTILIZED UTILIZED
, ACCRUAL ACCRUAL
, PAID PAID
, FROM_CURRENCY FROM_CURRENCY
, CONVERSION_RATE CONVERSION_RATE
, CURRENCY_CODE_FC CURRENCY_CODE_FC
, ORG_ID ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_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
, ORIGINAL_BUDGET_S ORIGINAL_BUDGET_S
, TRANSFER_IN_S TRANSFER_IN_S
, TRANSFER_OUT_S TRANSFER_OUT_S
, HOLDBACK_AMT_S HOLDBACK_AMT_S
, PLANNED_S PLANNED_S
, COMMITTED_S COMMITTED_S
, UTILIZED_S UTILIZED_S
, ACCRUAL_S ACCRUAL_S
, PAID_S PAID_S
, CONVERSION_RATE_S CONVERSION_RATE_S
FROM "BIM"."BIM_I_BUDGET_FACTS_STG"