VIEW: MTH.MTH_ENTITY_SUSTAIN_ASPECT#

Source

View Text - Preformatted

select ESA_PK_KEY ESA_PK_KEY, ENTITY_FK_KEY ENTITY_FK_KEY, ENTITY_TYPE ENTITY_TYPE, SUSTAIN_ASPECT_FK_KEY SUSTAIN_ASPECT_FK_KEY, SUSTAIN_ASPECT SUSTAIN_ASPECT, USAGE_CATEGORY USAGE_CATEGORY, METER_FK_KEY METER_FK_KEY, METER_CATEGORY METER_CATEGORY, SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY, FROM_TIME FROM_TIME, TO_TIME TO_TIME, HOUR_FK_KEY HOUR_FK_KEY, ENTITY_NAME ENTITY_NAME, ENTITY_TYPE_NAME ENTITY_TYPE_NAME, SUSTAIN_ASPECT_NAME SUSTAIN_ASPECT_NAME, USAGE_CATEGORY_NAME USAGE_CATEGORY_NAME, METER_TYPE METER_TYPE, METER_TYPE_NAME METER_TYPE_NAME, METER_CATEGORY_NAME METER_CATEGORY_NAME, SIMULATION_NAME SIMULATION_NAME, USAGE_VALUE USAGE_VALUE, USAGE_UOM USAGE_UOM, USAGE_COST USAGE_COST, CURRENCY CURRENCY, PLANT_FK_KEY PLANT_FK_KEY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE from "MTH"."MTH_ENTITY_SUSTAIN_ASPECT"

View Text - HTML Formatted

SELECT ESA_PK_KEY ESA_PK_KEY
, ENTITY_FK_KEY ENTITY_FK_KEY
, ENTITY_TYPE ENTITY_TYPE
, SUSTAIN_ASPECT_FK_KEY SUSTAIN_ASPECT_FK_KEY
, SUSTAIN_ASPECT SUSTAIN_ASPECT
, USAGE_CATEGORY USAGE_CATEGORY
, METER_FK_KEY METER_FK_KEY
, METER_CATEGORY METER_CATEGORY
, SHIFT_WORKDAY_FK_KEY SHIFT_WORKDAY_FK_KEY
, FROM_TIME FROM_TIME
, TO_TIME TO_TIME
, HOUR_FK_KEY HOUR_FK_KEY
, ENTITY_NAME ENTITY_NAME
, ENTITY_TYPE_NAME ENTITY_TYPE_NAME
, SUSTAIN_ASPECT_NAME SUSTAIN_ASPECT_NAME
, USAGE_CATEGORY_NAME USAGE_CATEGORY_NAME
, METER_TYPE METER_TYPE
, METER_TYPE_NAME METER_TYPE_NAME
, METER_CATEGORY_NAME METER_CATEGORY_NAME
, SIMULATION_NAME SIMULATION_NAME
, USAGE_VALUE USAGE_VALUE
, USAGE_UOM USAGE_UOM
, USAGE_COST USAGE_COST
, CURRENCY CURRENCY
, PLANT_FK_KEY PLANT_FK_KEY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
FROM "MTH"."MTH_ENTITY_SUSTAIN_ASPECT"