5 queries found for "Meter"

Get all from Meter

select * 
from CI_MTR

uploaded by Nuno Rodrigues

Get specific Meter

select * 
from CI_MTR
where 
MTR_ID = 'XXXX'

uploaded by Nuno Rodrigues

Retrieve Meter Type and Service Type for Meter

SELECT 
   MTRTYPE.MTR_TYPE_CD, MTRTYPE.SVC_TYPE_CD
FROM 
CI_MTR MTR, CI_MTR_TYPE MTRTYPE 
WHERE MTR.MTR_ID = 'INSERT_METER_ID'
AND MTR.MTR_TYPE_CD = MTRTYPE.MTR_TYPE_CD

uploaded by Nuno Rodrigues

Get Meter for Badge Number

SELECT
  MTR.*
FROM
  CI_MTR MTR
WHERE
  MTR.BADGE_NBR = 'INSERT_BADGE_NUMBER'

      

uploaded by Nuno Rodrigues

Get Meter Information at SP

SELECT
  CFG.MTR_ID MTR, 
  MTR.BADGE_NBR BADGE, 
  CFG.MTR_CONFIG_TY_CD  CONFIGTYPE
FROM
  CI_SP_MTR_HIST HIST, 
  CI_MTR_CONFIG CFG, 
  CI_MTR MTR
WHERE
  HIST.SP_ID = 'INSERT_SERVICE_POINT_ID'
AND(HIST.REMOVAL_DTTM IS NULL
  OR HIST.REMOVAL_DTTM >= 'INSERT_MINIMUM_REMOVAL_DATE')
  AND CFG.MTR_CONFIG_ID = HIST.MTR_CONFIG_ID
  AND MTR.MTR_ID = CFG.MTR_ID
  

uploaded by Nuno Rodrigues