VIEW: APPS.EAM_COUNTERS_V

Source

View Text - Preformatted

SELECT ccb.counter_id meter_id, cct.name meter_name, ccb.uom_code meter_uom, ccb.direction value_change_dir, ccb.reading_type meter_type, ccr.source_counter_id source_meter_id, (select cct2.name from csi_counters_tl cct2 where cct2.counter_id = ccr.source_counter_id and cct2.language = userenv('LANG')) as source_meter_name, ccr.factor, ccr.active_start_date relationship_start_date, ccb.eam_required_flag, ccb.used_in_scheduling, ccb.initial_reading, ccb.default_usage_rate user_defined_rate, ccb.use_past_reading, cct.description, ccb.start_date_active from_effective_date, ccb.end_date_active to_effective_date, ccb.created_by, ccb.creation_date, ccb.last_update_login, ccb.last_update_date, ccb.last_updated_by, ccb.attribute_category, ccb.attribute1, ccb.attribute2, ccb.attribute3, ccb.attribute4, ccb.attribute5, ccb.attribute6, ccb.attribute7, ccb.attribute8, ccb.attribute9, ccb.attribute10, ccb.attribute11, ccb.attribute12, ccb.attribute13, ccb.attribute14, ccb.attribute15, ccb.attribute16, ccb.attribute17, ccb.attribute18, ccb.attribute19, ccb.attribute20, ccb.attribute21, ccb.attribute22, ccb.attribute23, ccb.attribute24, ccb.attribute25, ccb.attribute26, ccb.attribute27, ccb.attribute28, ccb.attribute29, ccb.attribute30, 'N' tmpl_flag, ccb.created_from_counter_tmpl_id source_tmpl_id, ccb.INITIAL_READING_DATE FROM csi_counters_b ccb, csi_counters_tl cct, csi_counter_relationships ccr WHERE ccb.counter_id = cct.counter_id and ccb.counter_id = ccr.object_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 SYSDATE BETWEEN NVL(ccr.active_start_date(+), sysdate-1) and NVL(ccr.active_end_date(+), sysdate+1) and ccb.counter_type = 'REGULAR' and ccr.relationship_type_code(+) = 'CONFIGURATION' UNION ALL select cctb.counter_id, cctt.name, cctb.uom_code, cctb.direction, cctb.reading_type, TO_NUMBER(NULL) as source_meter_id, TO_CHAR(NULL) as source_meter_name, TO_NUMBER(NULL) as factor, TO_DATE(NULL) relationship_start_date, cctb.eam_required_flag, cctb.used_in_scheduling, cctb.initial_reading, cctb.default_usage_rate, cctb.use_past_reading, cctt.description, cctb.start_date_active, cctb.end_date_active, cctb.created_by, cctb.creation_date, cctb.last_update_login, cctb.last_update_date, cctb.last_updated_by, cctb.attribute_category, cctb.attribute1, cctb.attribute2, cctb.attribute3, cctb.attribute4, cctb.attribute5, cctb.attribute6, cctb.attribute7, cctb.attribute8, cctb.attribute9, cctb.attribute10, cctb.attribute11, cctb.attribute12, cctb.attribute13, cctb.attribute14, cctb.attribute15, cctb.attribute16, cctb.attribute17, cctb.attribute18, cctb.attribute19, cctb.attribute20, cctb.attribute21, cctb.attribute22, cctb.attribute23, cctb.attribute24, cctb.attribute25, cctb.attribute26, cctb.attribute27, cctb.attribute28, cctb.attribute29, cctb.attribute30, 'Y' tmpl_flag, TO_NUMBER(NULL) as source_tmpl_id, cctb.INITIAL_READING_DATE FROM csi_counter_template_b cctb, csi_counter_template_tl cctt WHERE 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'

View Text - HTML Formatted

SELECT CCB.COUNTER_ID METER_ID
, CCT.NAME METER_NAME
, CCB.UOM_CODE METER_UOM
, CCB.DIRECTION VALUE_CHANGE_DIR
, CCB.READING_TYPE METER_TYPE
, CCR.SOURCE_COUNTER_ID SOURCE_METER_ID
, (SELECT CCT2.NAME
FROM CSI_COUNTERS_TL CCT2
WHERE CCT2.COUNTER_ID = CCR.SOURCE_COUNTER_ID
AND CCT2.LANGUAGE = USERENV('LANG')) AS SOURCE_METER_NAME
, CCR.FACTOR
, CCR.ACTIVE_START_DATE RELATIONSHIP_START_DATE
, CCB.EAM_REQUIRED_FLAG
, CCB.USED_IN_SCHEDULING
, CCB.INITIAL_READING
, CCB.DEFAULT_USAGE_RATE USER_DEFINED_RATE
, CCB.USE_PAST_READING
, CCT.DESCRIPTION
, CCB.START_DATE_ACTIVE FROM_EFFECTIVE_DATE
, CCB.END_DATE_ACTIVE TO_EFFECTIVE_DATE
, CCB.CREATED_BY
, CCB.CREATION_DATE
, CCB.LAST_UPDATE_LOGIN
, CCB.LAST_UPDATE_DATE
, CCB.LAST_UPDATED_BY
, CCB.ATTRIBUTE_CATEGORY
, CCB.ATTRIBUTE1
, CCB.ATTRIBUTE2
, CCB.ATTRIBUTE3
, CCB.ATTRIBUTE4
, CCB.ATTRIBUTE5
, CCB.ATTRIBUTE6
, CCB.ATTRIBUTE7
, CCB.ATTRIBUTE8
, CCB.ATTRIBUTE9
, CCB.ATTRIBUTE10
, CCB.ATTRIBUTE11
, CCB.ATTRIBUTE12
, CCB.ATTRIBUTE13
, CCB.ATTRIBUTE14
, CCB.ATTRIBUTE15
, CCB.ATTRIBUTE16
, CCB.ATTRIBUTE17
, CCB.ATTRIBUTE18
, CCB.ATTRIBUTE19
, CCB.ATTRIBUTE20
, CCB.ATTRIBUTE21
, CCB.ATTRIBUTE22
, CCB.ATTRIBUTE23
, CCB.ATTRIBUTE24
, CCB.ATTRIBUTE25
, CCB.ATTRIBUTE26
, CCB.ATTRIBUTE27
, CCB.ATTRIBUTE28
, CCB.ATTRIBUTE29
, CCB.ATTRIBUTE30
, 'N' TMPL_FLAG
, CCB.CREATED_FROM_COUNTER_TMPL_ID SOURCE_TMPL_ID
, CCB.INITIAL_READING_DATE
FROM CSI_COUNTERS_B CCB
, CSI_COUNTERS_TL CCT
, CSI_COUNTER_RELATIONSHIPS CCR
WHERE CCB.COUNTER_ID = CCT.COUNTER_ID
AND CCB.COUNTER_ID = CCR.OBJECT_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 SYSDATE BETWEEN NVL(CCR.ACTIVE_START_DATE(+)
, SYSDATE-1)
AND NVL(CCR.ACTIVE_END_DATE(+)
, SYSDATE+1)
AND CCB.COUNTER_TYPE = 'REGULAR'
AND CCR.RELATIONSHIP_TYPE_CODE(+) = 'CONFIGURATION' UNION ALL SELECT CCTB.COUNTER_ID
, CCTT.NAME
, CCTB.UOM_CODE
, CCTB.DIRECTION
, CCTB.READING_TYPE
, TO_NUMBER(NULL) AS SOURCE_METER_ID
, TO_CHAR(NULL) AS SOURCE_METER_NAME
, TO_NUMBER(NULL) AS FACTOR
, TO_DATE(NULL) RELATIONSHIP_START_DATE
, CCTB.EAM_REQUIRED_FLAG
, CCTB.USED_IN_SCHEDULING
, CCTB.INITIAL_READING
, CCTB.DEFAULT_USAGE_RATE
, CCTB.USE_PAST_READING
, CCTT.DESCRIPTION
, CCTB.START_DATE_ACTIVE
, CCTB.END_DATE_ACTIVE
, CCTB.CREATED_BY
, CCTB.CREATION_DATE
, CCTB.LAST_UPDATE_LOGIN
, CCTB.LAST_UPDATE_DATE
, CCTB.LAST_UPDATED_BY
, CCTB.ATTRIBUTE_CATEGORY
, CCTB.ATTRIBUTE1
, CCTB.ATTRIBUTE2
, CCTB.ATTRIBUTE3
, CCTB.ATTRIBUTE4
, CCTB.ATTRIBUTE5
, CCTB.ATTRIBUTE6
, CCTB.ATTRIBUTE7
, CCTB.ATTRIBUTE8
, CCTB.ATTRIBUTE9
, CCTB.ATTRIBUTE10
, CCTB.ATTRIBUTE11
, CCTB.ATTRIBUTE12
, CCTB.ATTRIBUTE13
, CCTB.ATTRIBUTE14
, CCTB.ATTRIBUTE15
, CCTB.ATTRIBUTE16
, CCTB.ATTRIBUTE17
, CCTB.ATTRIBUTE18
, CCTB.ATTRIBUTE19
, CCTB.ATTRIBUTE20
, CCTB.ATTRIBUTE21
, CCTB.ATTRIBUTE22
, CCTB.ATTRIBUTE23
, CCTB.ATTRIBUTE24
, CCTB.ATTRIBUTE25
, CCTB.ATTRIBUTE26
, CCTB.ATTRIBUTE27
, CCTB.ATTRIBUTE28
, CCTB.ATTRIBUTE29
, CCTB.ATTRIBUTE30
, 'Y' TMPL_FLAG
, TO_NUMBER(NULL) AS SOURCE_TMPL_ID
, CCTB.INITIAL_READING_DATE
FROM CSI_COUNTER_TEMPLATE_B CCTB
, CSI_COUNTER_TEMPLATE_TL CCTT
WHERE 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'