eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BIM.BIM_R_KPI_SUMMARY_MV#

Source

View Text - Preformatted


select RESOURCE_ID RESOURCE_ID, OBJECT_ID OBJECT_ID, OBJECT_NAME OBJECT_NAME, OBJECT_TYPE OBJECT_TYPE, ONE_OFF_FLAG ONE_OFF_FLAG, PERIOD_TYPE PERIOD_TYPE, AREA1_CODE AREA1_CODE, AREA2_CODE AREA2_CODE, COUNTRY COUNTRY, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, STATUS STATUS, 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, RES_CUR_PERIOD RES_CUR_PERIOD, RES_PRE_PERIOD RES_PRE_PERIOD, ORDERS_CUR_PERIOD ORDERS_CUR_PERIOD, ORDERS_PRE_PERIOD ORDERS_PRE_PERIOD, ALEADS_CUR_PERIOD ALEADS_CUR_PERIOD, ALEADS_PRE_PERIOD ALEADS_PRE_PERIOD from "BIM"."BIM_R_KPI_SUMMARY_MV"

View Text - HTML Formatted

SELECT RESOURCE_ID RESOURCE_ID
, OBJECT_ID OBJECT_ID
, OBJECT_NAME OBJECT_NAME
, OBJECT_TYPE OBJECT_TYPE
, ONE_OFF_FLAG ONE_OFF_FLAG
, PERIOD_TYPE PERIOD_TYPE
, AREA1_CODE AREA1_CODE
, AREA2_CODE AREA2_CODE
, COUNTRY COUNTRY
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, STATUS STATUS
, 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
, RES_CUR_PERIOD RES_CUR_PERIOD
, RES_PRE_PERIOD RES_PRE_PERIOD
, ORDERS_CUR_PERIOD ORDERS_CUR_PERIOD
, ORDERS_PRE_PERIOD ORDERS_PRE_PERIOD
, ALEADS_CUR_PERIOD ALEADS_CUR_PERIOD
, ALEADS_PRE_PERIOD ALEADS_PRE_PERIOD
FROM "BIM"."BIM_R_KPI_SUMMARY_MV"