Product: | EAM - Enterprise Asset Management |
---|---|
Description: | View used to get runtime rule information and meter details. |
Implementation/DBA Data: | APPS.EAM_RUNTIME_INTERVAL_V |
SELECT PSR.RULE_ID
, EPLS.ACTIVITY_ASSOCIATION_ID
, PSR.PM_SCHEDULE_ID
, PSR.RULE_TYPE
, EM.METER_ID
, EM.METER_NAME
, EM.METER_UOM
, EM.VALUE_CHANGE_DIR
, EM.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
, EM.USER_DEFINED_RATE
FROM EAM_PM_SCHEDULING_RULES PSR
, EAM_METERS EM
, EAM.EAM_PM_LAST_SERVICE EPLS
, EAM_PM_SCHEDULINGS EPS
WHERE PSR.PM_SCHEDULE_ID = EPS.PM_SCHEDULE_ID
AND EPS.ACTIVITY_ASSOCIATION_ID = EPLS.ACTIVITY_ASSOCIATION_ID
AND EPLS.METER_ID = EM.METER_ID
AND PSR.METER_ID = EM.METER_ID
AND NVL(EM.FROM_EFFECTIVE_DATE
, SYSDATE-1) < SYSDATE
AND NVL(EM.TO_EFFECTIVE_DATE
, SYSDATE+1) > SYSDATE UNION SELECT PSR.RULE_ID
, EPS.ACTIVITY_ASSOCIATION_ID
, PSR.PM_SCHEDULE_ID
, PSR.RULE_TYPE
, EM.METER_ID
, EM.METER_NAME
, EM.METER_UOM
, EM.VALUE_CHANGE_DIR
, EM.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
, EM.USER_DEFINED_RATE
FROM EAM_PM_SCHEDULING_RULES PSR
, EAM_METERS EM
, EAM_PM_SCHEDULINGS EPS
WHERE EPS.TMPL_FLAG='Y'
AND PSR.PM_SCHEDULE_ID = EPS.PM_SCHEDULE_ID
AND PSR.METER_ID = EM.METER_ID
AND NVL(EM.FROM_EFFECTIVE_DATE
, SYSDATE-1) < SYSDATE
AND NVL(EM.TO_EFFECTIVE_DATE
, SYSDATE+1) > SYSDATE