DBA Data[Home] [Help]

VIEW: BIM.BIM_R_KPI_BIN_MV#

Source

View Text - Preformatted

select RESOURCE_ID RESOURCE_ID, KPI KPI, PERIOD_TYPE PERIOD_TYPE, AREA1_CODE AREA1_CODE, AREA2_CODE AREA2_CODE, COUNTRY COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, STATUS STATUS, CUR_VALUE CUR_VALUE, PREV_VALUE PREV_VALUE, CHANGE_VALUE CHANGE_VALUE, STATUS_IMAGE STATUS_IMAGE from "BIM"."BIM_R_KPI_BIN_MV"
View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, KPI KPI
, PERIOD_TYPE PERIOD_TYPE
, AREA1_CODE AREA1_CODE
, AREA2_CODE AREA2_CODE
, COUNTRY COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, STATUS STATUS
, CUR_VALUE CUR_VALUE
, PREV_VALUE PREV_VALUE
, CHANGE_VALUE CHANGE_VALUE
, STATUS_IMAGE STATUS_IMAGE
FROM "BIM"."BIM_R_KPI_BIN_MV"