View: EAM_RUNTIME_INTERVAL_V

Product:	EAM - Enterprise Asset Management
Description:	View used to get runtime rule information and meter details.
Implementation/DBA Data:	APPS.EAM_RUNTIME_INTERVAL_V

View Text

SELECT PSR.RULE_ID
, EPLS.ACTIVITY_ASSOCIATION_ID AS ACTIVITY_ASSOCIATION_ID
, PSR.PM_SCHEDULE_ID
, PSR.RULE_TYPE
, CCB.COUNTER_ID AS METER_ID
, CCT.NAME AS METER_NAME
, CCB.UOM_CODE AS METER_UOM
, CCB.DIRECTION AS VALUE_CHANGE_DIR
, CCT.DESCRIPTION AS METER_DESCRIPTION
, PSR.RUNTIME_INTERVAL
, EPLS.LAST_SERVICE_READING
, PSR.CREATED_BY
, PSR.CREATION_DATE
, PSR.LAST_UPDATE_LOGIN
, PSR.LAST_UPDATE_DATE
, PSR.LAST_UPDATED_BY
, PSR.EFFECTIVE_READING_FROM
, PSR.EFFECTIVE_READING_TO
, PSR.EFFECTIVE_DATE_FROM
, PSR.EFFECTIVE_DATE_TO
, EAM_METERS_UTIL.GET_METER_USAGE_RATE(CCB.COUNTER_ID) AS USER_DEFINED_RATE FROM EAM_PM_SCHEDULING_RULES PSR
, CSI_COUNTERS_B CCB
, CSI_COUNTERS_TL CCT
, EAM_PM_LAST_SERVICE EPLS
, EAM_PM_SCHEDULINGS EPS
WHERE PSR.PM_SCHEDULE_ID = EPS.PM_SCHEDULE_ID AND EPS.EAM_LAST_CYCLIC_ACT = EPLS.ACTIVITY_ASSOCIATION_ID AND CCB.COUNTER_ID = CCT.COUNTER_ID AND SYSDATE BETWEEN NVL(CCB.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(CCB.END_DATE_ACTIVE
, SYSDATE+1) AND CCT.LANGUAGE = USERENV('LANG') AND CCB.COUNTER_TYPE = 'REGULAR' AND EPLS.METER_ID = CCB.COUNTER_ID AND PSR.METER_ID = CCB.COUNTER_ID UNION SELECT PSR.RULE_ID
, EPS.EAM_LAST_CYCLIC_ACT AS ACTIVITY_ASSOCIATION_ID
, PSR.PM_SCHEDULE_ID
, PSR.RULE_TYPE
, CCTB.COUNTER_ID AS METER_ID
, CCTT.NAME AS METER_NAME
, CCTB.UOM_CODE AS METER_UOM
, CCTB.DIRECTION AS VALUE_CHANGE_DIR
, CCTT.DESCRIPTION AS METER_DESCRIPTION
, PSR.RUNTIME_INTERVAL
, TO_NUMBER(NULL)
, PSR.CREATED_BY
, PSR.CREATION_DATE
, PSR.LAST_UPDATE_LOGIN
, PSR.LAST_UPDATE_DATE
, PSR.LAST_UPDATED_BY
, PSR.EFFECTIVE_READING_FROM
, PSR.EFFECTIVE_READING_TO
, PSR.EFFECTIVE_DATE_FROM
, PSR.EFFECTIVE_DATE_TO
, CCTB.DEFAULT_USAGE_RATE FROM EAM_PM_SCHEDULING_RULES PSR
, CSI_COUNTER_TEMPLATE_B CCTB
, CSI_COUNTER_TEMPLATE_TL CCTT
, EAM_PM_SCHEDULINGS EPS WHERE EPS.TMPL_FLAG='Y'
AND PSR.PM_SCHEDULE_ID = EPS.PM_SCHEDULE_ID AND CCTB.COUNTER_ID = CCTT.COUNTER_ID AND CCTT.LANGUAGE = USERENV('LANG') AND SYSDATE BETWEEN NVL(CCTB.START_DATE_ACTIVE
, SYSDATE)
AND NVL(CCTB.END_DATE_ACTIVE
, SYSDATE) AND CCTB.COUNTER_TYPE = 'REGULAR' AND PSR.METER_ID = CCTB.COUNTER_ID

Columns