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

TABLE: MTH.MTH_METER_READINGS

Object Details
Object Name: MTH_METER_READINGS
Object Type: TABLE
Owner: MTH
FND Design Data: TableMTH.MTH_METER_READINGS
Subobject Name:
Status: VALID


This table stores actual meter values based on the tag readings from MTH_METER_READINGS_RAW or laded from CSV file and calculated values for virtual meters


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Indexes
Index Type Uniqueness Tablespace Column
MTH_METER_READINGS_U1 NORMAL UNIQUE TablespaceAPPS_TS_TX_IDX ColumnMETER_FK_KEY
ColumnFROM_TIME
Columns
Name Datatype Length Mandatory Comments
METER_FK_KEY NUMBER
Yes Reference to meter
FROM_TIME DATE
Yes From time
TO_TIME DATE
Yes To time
USAGE_VALUE NUMBER
Yes Usage value
PROCESSED_FLAG VARCHAR2 (1)
Processed flag with value Y or N to indicate whether the data in this row has been populated into the Entity Sustainability Aspect or not.
CREATION_DATE DATE
Yes Standard who column
LAST_UPDATE_DATE DATE
Yes Standard who column
CREATION_SYSTEM_ID NUMBER

Standard who column
LAST_UPDATE_SYSTEM_ID NUMBER

Standard who column
CREATED_BY NUMBER (15)
Standard who column
LAST_UPDATED_BY NUMBER (15)
Standard who column
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column
Query Text

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


SELECT METER_FK_KEY
,      FROM_TIME
,      TO_TIME
,      USAGE_VALUE
,      PROCESSED_FLAG
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      CREATION_SYSTEM_ID
,      LAST_UPDATE_SYSTEM_ID
,      CREATED_BY
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
FROM MTH.MTH_METER_READINGS;

Dependencies

[top of page]

MTH.MTH_METER_READINGS does not reference any database object

MTH.MTH_METER_READINGS is referenced by following:

SchemaMTH
ViewMTH_METER_READINGS#