VIEW: APPS.EAM_RUNTIME_INTERVAL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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