View: EAM_ASSET_METERS_V

Product:	EAM - Enterprise Asset Management
Description:	This view gives all the information about a meter associated with an asset.
Implementation/DBA Data:	APPS.EAM_ASSET_METERS_V

View Text

SELECT EAM.ROWID
, EM.INITIAL_READING
, EAM.METER_ID
, EAM.ORGANIZATION_ID
, MSN.INVENTORY_ITEM_ID ASSET_GROUP_ID
, MSN.SERIAL_NUMBER ASSET_NUMBER
, EM.METER_NAME
, EM.METER_UOM
, EM.VALUE_CHANGE_DIR
, EM.USED_IN_SCHEDULING
, EM.USER_DEFINED_RATE
, EM.USE_PAST_READING
, EM.DESCRIPTION
, EM.FROM_EFFECTIVE_DATE
, EM.TO_EFFECTIVE_DATE
, EAM.CREATED_BY
, EAM.CREATION_DATE
, EAM.LAST_UPDATE_LOGIN
, EAM.LAST_UPDATE_DATE
, EAM.LAST_UPDATED_BY
, EM.ATTRIBUTE_CATEGORY
, EM.ATTRIBUTE1
, EM.ATTRIBUTE2
, EM.ATTRIBUTE3
, EM.ATTRIBUTE4
, EM.ATTRIBUTE5
, EM.ATTRIBUTE6
, EM.ATTRIBUTE7
, EM.ATTRIBUTE8
, EM.ATTRIBUTE9
, EM.ATTRIBUTE10
, EM.ATTRIBUTE11
, EM.ATTRIBUTE12
, EM.ATTRIBUTE13
, EM.ATTRIBUTE14
, EM.ATTRIBUTE15
, EAM.MAINTENANCE_OBJECT_TYPE
, EAM.MAINTENANCE_OBJECT_ID
, EAM.CREATION_ORGANIZATION_ID
, EM.TMPL_FLAG
, EM.SOURCE_TMPL_ID
FROM EAM_METERS EM
, EAM_ASSET_METERS EAM
, MTL_SERIAL_NUMBERS MSN
WHERE EAM.METER_ID = EM.METER_ID
AND (MSN.GEN_OBJECT_ID = EAM.MAINTENANCE_OBJECT_ID)
AND (EAM.ORGANIZATION_ID IS NULL OR EAM.ORGANIZATION_ID = MSN.CURRENT_ORGANIZATION_ID) UNION SELECT EAM.ROWID
, EM.INITIAL_READING
, EAM.METER_ID
, EAM.ORGANIZATION_ID
, MSI.INVENTORY_ITEM_ID ASSET_GROUP_ID
, NULL ASSET_NUMBER
, EM.METER_NAME
, EM.METER_UOM
, EM.VALUE_CHANGE_DIR
, EM.USED_IN_SCHEDULING
, EM.USER_DEFINED_RATE
, EM.USE_PAST_READING
, EM.DESCRIPTION
, EM.FROM_EFFECTIVE_DATE
, EM.TO_EFFECTIVE_DATE
, EAM.CREATED_BY
, EAM.CREATION_DATE
, EAM.LAST_UPDATE_LOGIN
, EAM.LAST_UPDATE_DATE
, EAM.LAST_UPDATED_BY
, EM.ATTRIBUTE_CATEGORY
, EM.ATTRIBUTE1
, EM.ATTRIBUTE2
, EM.ATTRIBUTE3
, EM.ATTRIBUTE4
, EM.ATTRIBUTE5
, EM.ATTRIBUTE6
, EM.ATTRIBUTE7
, EM.ATTRIBUTE8
, EM.ATTRIBUTE9
, EM.ATTRIBUTE10
, EM.ATTRIBUTE11
, EM.ATTRIBUTE12
, EM.ATTRIBUTE13
, EM.ATTRIBUTE14
, EM.ATTRIBUTE15
, EAM.MAINTENANCE_OBJECT_TYPE
, EAM.MAINTENANCE_OBJECT_ID
, EAM.CREATION_ORGANIZATION_ID
, EM.TMPL_FLAG
, EM.SOURCE_TMPL_ID
FROM EAM_METERS EM
, EAM_ASSET_METERS EAM
, MTL_SYSTEM_ITEMS MSI
WHERE EAM.METER_ID = EM.METER_ID
AND (EAM.MAINTENANCE_OBJECT_ID=MSI.INVENTORY_ITEM_ID)
AND (EAM.ORGANIZATION_ID IS NULL OR EAM.ORGANIZATION_ID = MSI.ORGANIZATION_ID)
AND EM.TMPL_FLAG='Y'

Columns