Product: | EAM - Enterprise Asset Management |
---|---|
Description: | View gives details about meter and meter readings. |
Implementation/DBA Data: | APPS.EAM_METER_READINGS_V |
SELECT EAM.METER_ID
, EM.METER_NAME
, EM.METER_UOM
, EAM.ORGANIZATION_ID
, MSN.INVENTORY_ITEM_ID ASSET_GROUP_ID
, MSN.SERIAL_NUMBER ASSET_NUMBER
, EM.VALUE_CHANGE_DIR
, EMR.METER_READING_ID
, EMR.CURRENT_READING
, EMR.CURRENT_READING_DATE
, TO_CHAR(NULL) RESET_FLAG
, DISABLE_FLAG
, EMR.WIP_ENTITY_ID
, EMR.LIFE_TO_DATE_READING
, TO_CHAR(NULL) DESCRIPTION
, EM.FROM_EFFECTIVE_DATE
, EM.TO_EFFECTIVE_DATE
, EMR.CREATED_BY
, EMR.CREATION_DATE
, EMR.LAST_UPDATE_LOGIN
, EMR.LAST_UPDATE_DATE
, EMR.LAST_UPDATED_BY
, EMR.ATTRIBUTE_CATEGORY
, EMR.ATTRIBUTE1
, EMR.ATTRIBUTE2
, EMR.ATTRIBUTE3
, EMR.ATTRIBUTE4
, EMR.ATTRIBUTE5
, EMR.ATTRIBUTE6
, EMR.ATTRIBUTE7
, EMR.ATTRIBUTE8
, EMR.ATTRIBUTE9
, EMR.ATTRIBUTE10
, EMR.ATTRIBUTE11
, EMR.ATTRIBUTE12
, EMR.ATTRIBUTE13
, EMR.ATTRIBUTE14
, EMR.ATTRIBUTE15
, TO_NUMBER(NULL) CURR_READING_NEW
, TO_DATE(NULL) CURR_READING_DATE
, TO_NUMBER(NULL) CURR_CHANGE
, EMR.DESCRIPTION PREV_DESC
, EMR.ROWID
, EMR.RESET_FLAG
, EAM.MAINTENANCE_OBJECT_TYPE
, EAM.MAINTENANCE_OBJECT_ID
FROM EAM_METERS EM
, EAM_ASSET_METERS EAM
, EAM_METER_READINGS EMR
, MTL_SERIAL_NUMBERS MSN
WHERE EAM.METER_ID = EM.METER_ID
AND EM.METER_ID = EMR.METER_ID (+)
AND MSN.GEN_OBJECT_ID = EAM.MAINTENANCE_OBJECT_ID
AND (NVL(EAM.ORGANIZATION_ID
, MSN.CURRENT_ORGANIZATION_ID) = MSN.CURRENT_ORGANIZATION_ID) UNION SELECT EAM.METER_ID
, EM.METER_NAME
, EM.METER_UOM
, EAM.ORGANIZATION_ID
, MSN.INVENTORY_ITEM_ID ASSET_GROUP_ID
, MSN.SERIAL_NUMBER ASSET_NUMBER
, EM.VALUE_CHANGE_DIR
, TO_NUMBER(NULL) METER_READING_ID
, TO_NUMBER(NULL) CURRENT_READING
, TO_DATE(NULL) CURRENT_READING_DATE
, TO_CHAR(NULL) RESET_FLAG
, 'N' DISABLE_FLAG
, TO_NUMBER(NULL) WIP_ENTITY_ID
, TO_NUMBER(NULL) LIFE_TO_DATE_READING
, TO_CHAR(NULL) DESCRIPTION
, EM.FROM_EFFECTIVE_DATE
, EM.TO_EFFECTIVE_DATE
, TO_NUMBER(NULL) CREATED_BY
, TO_DATE(NULL) CREATION_DATE
, TO_NUMBER(NULL) LAST_UPDATE_LOGIN
, TO_DATE(NULL) LAST_UPDATE_DATE
, TO_NUMBER(NULL) LAST_UPDATED_BY
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
, TO_NUMBER(NULL) CURR_READING_NEW
, TO_DATE(NULL) CURR_READING_DATE
, TO_NUMBER(NULL) CURR_CHANGE
, NULL PREV_DESC
, CHARTOROWID(NULL)
, NULL RESET_FLAG
, EAM.MAINTENANCE_OBJECT_TYPE
, EAM.MAINTENANCE_OBJECT_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 (NVL(EAM.ORGANIZATION_ID
, MSN.CURRENT_ORGANIZATION_ID) = MSN.CURRENT_ORGANIZATION_ID)