VIEW: BIM.BIM_R_KPI_FACTS#

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, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, REGION REGION, COUNTRY COUNTRY, BUSINESS_UNIT BUSINESS_UNIT, START_DATE START_DATE, END_DATE END_DATE, STATUS STATUS, PERIOD_TYPE PERIOD_TYPE, CALCULATION_TYPE CALCULATION_TYPE, COST_CUR_PERIOD COST_CUR_PERIOD, COST_PRE_PERIOD COST_PRE_PERIOD, LEADS_CUR_PERIOD LEADS_CUR_PERIOD, LEADS_PRE_PERIOD LEADS_PRE_PERIOD, REG_CUR_PERIOD REG_CUR_PERIOD, REG_PRE_PERIOD REG_PRE_PERIOD, REV_CUR_PERIOD REV_CUR_PERIOD, REV_PRE_PERIOD REV_PRE_PERIOD, ORDERS_CUR_PERIOD ORDERS_CUR_PERIOD, ORDERS_PRE_PERIOD ORDERS_PRE_PERIOD, RES_CUR_PERIOD RES_CUR_PERIOD, RES_PRE_PERIOD RES_PRE_PERIOD, ALEADS_CUR_PERIOD ALEADS_CUR_PERIOD, ALEADS_PRE_PERIOD ALEADS_PRE_PERIOD from "BIM"."BIM_R_KPI_FACTS"

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
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, REGION REGION
, COUNTRY COUNTRY
, BUSINESS_UNIT BUSINESS_UNIT
, START_DATE START_DATE
, END_DATE END_DATE
, STATUS STATUS
, PERIOD_TYPE PERIOD_TYPE
, CALCULATION_TYPE CALCULATION_TYPE
, COST_CUR_PERIOD COST_CUR_PERIOD
, COST_PRE_PERIOD COST_PRE_PERIOD
, LEADS_CUR_PERIOD LEADS_CUR_PERIOD
, LEADS_PRE_PERIOD LEADS_PRE_PERIOD
, REG_CUR_PERIOD REG_CUR_PERIOD
, REG_PRE_PERIOD REG_PRE_PERIOD
, REV_CUR_PERIOD REV_CUR_PERIOD
, REV_PRE_PERIOD REV_PRE_PERIOD
, ORDERS_CUR_PERIOD ORDERS_CUR_PERIOD
, ORDERS_PRE_PERIOD ORDERS_PRE_PERIOD
, RES_CUR_PERIOD RES_CUR_PERIOD
, RES_PRE_PERIOD RES_PRE_PERIOD
, ALEADS_CUR_PERIOD ALEADS_CUR_PERIOD
, ALEADS_PRE_PERIOD ALEADS_PRE_PERIOD
FROM "BIM"."BIM_R_KPI_FACTS"