1 query found for "SP Meter Installation History View"
Get latest SP where Meter is installed
SELECT CV.SP_ID SPID
FROM
CI_MTR_CONFIG MC,
CI_CFG_SPMR_VW CV
WHERE
MC.MTR_ID = 'INSERT_METER_ID'
AND CV.MTR_CONFIG_ID = MC.MTR_CONFIG_ID
ORDER BY CV.INSTALL_DTTM DESC, CV.SP_MTR_HIST_ID ASC