Product: | EAM - Enterprise Asset Management |
---|---|
Description: | This View gives all active Meter/Meter Templates. Basically the view refers to counters tables for the information. TMPL_FLAG is Y for Meter Templates. |
Implementation/DBA Data: | APPS.EAM_COUNTERS_V |
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'