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.

DBA Data [Home] [Help] [Dependency Information]

TABLE: MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR

Object Details

Object Name:	MTH_ENTITY_SUSTAIN_ASPECT_HOUR
Object Type:	TABLE
Owner:	MTH
FND Design Data:	MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR
Subobject Name:
Status:	VALID

MTH_ENTITY_SUSTAIN_ASPECT_HOUR aggregates data from MTH_ENTITY_SUSTAIN_ASPECT by hour.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
MTH_ENTITY_SUSTAIN_ASPECT_H_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ESA_HR_PK_KEY
MTH_ENTITY_SUSTAIN_ASPECT_H_U2	NORMAL	UNIQUE	APPS_TS_TX_IDX	ENTITY_FK_KEY ENTITY_TYPE SUSTAIN_ASPECT METER_CATEGORY USAGE_CATEGORY HOUR_FK_KEY SHIFT_WORKDAY_FK_KEY METER_FK_KEY

Columns

Name	Datatype	Length	Mandatory	Comments
ESA_HR_PK_KEY	NUMBER		Yes	System generated surrogate key for entity sustainability aspect hourly identifier
ENTITY_FK_KEY	NUMBER		Yes	Reference to entity
ENTITY_TYPE	VARCHAR2	(30)	Yes	Entity type code
SUSTAIN_ASPECT_FK_KEY	VARCHAR2	(240)	Yes	Reference to suntainability aspect
SUSTAIN_ASPECT	VARCHAR2	(30)	Yes	Suntainability aspect code
USAGE_CATEGORY	VARCHAR2	(30)	Yes	Energy usage category code
METER_FK_KEY	NUMBER		Yes	Reference to meter
METER_CATEGORY	VARCHAR2	(30)	Yes	Meter category
SHIFT_WORKDAY_FK_KEY	NUMBER		Yes	Reference to workday shift
HOUR_FK_KEY	NUMBER		Yes	Reference to hour
FROM_TIME	DATE		Yes	From time
TO_TIME	DATE		Yes	To time
ENTITY_NAME	VARCHAR2	(100)		Entity name
ENTITY_TYPE_NAME	VARCHAR2	(80)		Entity type name
SUSTAIN_ASPECT_NAME	VARCHAR2	(80)		Suntainability aspect name
USAGE_CATEGORY_NAME	VARCHAR2	(80)		Energy usage category name
METER_TYPE	VARCHAR2	(30)		Meter type code
METER_TYPE_NAME	VARCHAR2	(80)		Meter type name
METER_CATEGORY_NAME	VARCHAR2	(80)		Meter category name
SIMULATION_NAME	VARCHAR2	(80)		Simulation name
USAGE_VALUE	NUMBER		Yes	Usage value
USAGE_UOM	VARCHAR2	(80)		Usage UOM
USAGE_COST	NUMBER			Usage cost
CURRENCY	VARCHAR2	(3)		Currency
PLANT_FK_KEY	NUMBER			Reference to plant
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR does not reference any database object

MTH.MTH_ENTITY_SUSTAIN_ASPECT_HOUR is referenced by following:

APPS: MTH_SHIFT_REFERENCE_MV
MTH: MTH_ENTITY_SUSTAIN_ASPECT_HOU#