Product: | EAM - Enterprise Asset Management |
---|---|
Description: | Last service information view |
Implementation/DBA Data: | APPS.EAM_PM_LAST_SERVICE_V |
SELECT EPAAV.ACTIVITY_ASSOCIATION_ID
, EPLS.LAST_SERVICE_READING
, EPAAV.ASSET_NUMBER
, EPAAV.METER_ID
, EPAAV.METER_NAME
, EPAAV.METER_UOM
, EPAAV.VALUE_CHANGE_DIR
, EPAAV.DESCRIPTION
, EPAAV.USAGE_RATE
, EPAAV.CREATED_BY
, EPAAV.CREATION_DATE
, EPAAV.LAST_UPDATE_LOGIN
, EPAAV.LAST_UPDATE_DATE
, EPAAV.LAST_UPDATED_BY
FROM EAM_PM_ASSET_ACTIVITY_V EPAAV
, EAM_PM_LAST_SERVICE EPLS
WHERE EPAAV.METER_ID = EPLS.METER_ID(+)
AND EPAAV.ACTIVITY_ASSOCIATION_ID = EPLS.ACTIVITY_ASSOCIATION_ID(+)