VIEW: MSC.MSC_RP_KPI#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, KPI_TYPE_ID KPI_TYPE_ID, KPI_VALUE KPI_VALUE, ITEM_ID ITEM_ID, ITEM_CAT_ID ITEM_CAT_ID, ORG_ID ORG_ID, INSTANCE_ID INSTANCE_ID, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID, KPI_TIME KPI_TIME, KPI_VALUE_NUM1 KPI_VALUE_NUM1, KPI_VALUE_NUM2 KPI_VALUE_NUM2, KPI_VALUE_NUM3 KPI_VALUE_NUM3, KPI_VALUE_NUM4 KPI_VALUE_NUM4, KPI_VALUE_NUM5 KPI_VALUE_NUM5, KPI_VALUE_NUM6 KPI_VALUE_NUM6, KPI_VALUE_NUM7 KPI_VALUE_NUM7, KPI_VALUE_NUM8 KPI_VALUE_NUM8, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, END_ITEM_ID END_ITEM_ID from "MSC"."MSC_RP_KPI"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, KPI_TYPE_ID KPI_TYPE_ID
, KPI_VALUE KPI_VALUE
, ITEM_ID ITEM_ID
, ITEM_CAT_ID ITEM_CAT_ID
, ORG_ID ORG_ID
, INSTANCE_ID INSTANCE_ID
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
, KPI_TIME KPI_TIME
, KPI_VALUE_NUM1 KPI_VALUE_NUM1
, KPI_VALUE_NUM2 KPI_VALUE_NUM2
, KPI_VALUE_NUM3 KPI_VALUE_NUM3
, KPI_VALUE_NUM4 KPI_VALUE_NUM4
, KPI_VALUE_NUM5 KPI_VALUE_NUM5
, KPI_VALUE_NUM6 KPI_VALUE_NUM6
, KPI_VALUE_NUM7 KPI_VALUE_NUM7
, KPI_VALUE_NUM8 KPI_VALUE_NUM8
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, END_ITEM_ID END_ITEM_ID
FROM "MSC"."MSC_RP_KPI"