View: EAM_ASSET_METERS_V

Product:	EAM - Enterprise Asset Management
Description:	This view gives all the information about a meter associated with an asset.
Implementation/DBA Data:	APPS.EAM_ASSET_METERS_V

View Text

SELECT CCA.ROWID
, CCA.INSTANCE_ASSOCIATION_ID AS ASSOCIATION_ID
, EC.INITIAL_READING
, CCA.COUNTER_ID METER_ID
, CII.LAST_VLD_ORGANIZATION_ID ORGANIZATION_ID
, CII.INVENTORY_ITEM_ID ASSET_GROUP_ID
, CII.INSTANCE_NUMBER ASSET_NUMBER
, CCT.NAME METER_NAME
, EC.READING_TYPE METER_TYPE
, EC.UOM_CODE METER_UOM
, EC.DIRECTION VALUE_CHANGE_DIR
, EC.EAM_REQUIRED_FLAG
, CCA.PRIMARY_FAILURE_FLAG
, EC.USED_IN_SCHEDULING
, EC.DEFAULT_USAGE_RATE USER_DEFINED_RATE
, EC.USE_PAST_READING
, CCT.DESCRIPTION DESCRIPTION
, EC.START_DATE_ACTIVE FROM_EFFECTIVE_DATE
, EC.END_DATE_ACTIVE TO_EFFECTIVE_DATE
, CCA.CREATED_BY
, CCA.CREATION_DATE
, CCA.LAST_UPDATE_LOGIN
, CCA.LAST_UPDATE_DATE
, CCA.LAST_UPDATED_BY
, CCA.ATTRIBUTE_CATEGORY
, CCA.ATTRIBUTE1 ATTRIBUTE1
, CCA.ATTRIBUTE2 ATTRIBUTE2
, CCA.ATTRIBUTE3 ATTRIBUTE3
, CCA.ATTRIBUTE4 ATTRIBUTE4
, CCA.ATTRIBUTE5 ATTRIBUTE5
, CCA.ATTRIBUTE6 ATTRIBUTE6
, CCA.ATTRIBUTE7 ATTRIBUTE7
, CCA.ATTRIBUTE8 ATTRIBUTE8
, CCA.ATTRIBUTE9 ATTRIBUTE9
, CCA.ATTRIBUTE10 ATTRIBUTE10
, CCA.ATTRIBUTE11 ATTRIBUTE11
, CCA.ATTRIBUTE12 ATTRIBUTE12
, CCA.ATTRIBUTE13 ATTRIBUTE13
, CCA.ATTRIBUTE14 ATTRIBUTE14
, CCA.ATTRIBUTE15 ATTRIBUTE15
, TO_NUMBER(3) MAINTENANCE_OBJECT_TYPE
, CCA.SOURCE_OBJECT_ID MAINTENANCE_OBJECT_ID
, TO_NUMBER(NULL) CREATION_ORGANIZATION_ID
, TO_CHAR('N') TMPL_FLAG
, EC.CREATED_FROM_COUNTER_TMPL_ID SOURCE_TMPL_ID
, MSIK.EAM_ITEM_TYPE EAM_ITEM_TYPE
, MSIK.CONCATENATED_SEGMENTS ASSET_GROUP
, MP.ORGANIZATION_CODE
, CII.INSTANCE_DESCRIPTION AS ASSET_DESCRIPTION
, CCT1.NAME SOURCE_METER_NAME
, CCR.FACTOR
, CCR.ACTIVE_START_DATE RELATIONSHIP_START_DATE
, EC.INITIAL_READING_DATE
, CCA.MAINT_ORGANIZATION_ID
FROM CSI_COUNTERS_B EC
, CSI_COUNTERS_TL CCT
, CSI_COUNTER_ASSOCIATIONS CCA
, CSI_ITEM_INSTANCES CII
, MTL_PARAMETERS MP
, CSI_COUNTER_RELATIONSHIPS CCR
, CSI_COUNTERS_TL CCT1
, MTL_SYSTEM_ITEMS_B_KFV MSIK
WHERE CCA.COUNTER_ID = EC.COUNTER_ID
AND EC.COUNTER_ID = CCT.COUNTER_ID
AND CCT.LANGUAGE = USERENV('LANG')
AND EC.COUNTER_ID = CCR.OBJECT_COUNTER_ID (+)
AND CCR.RELATIONSHIP_TYPE_CODE(+) = 'CONFIGURATION'
AND CCA.SOURCE_OBJECT_ID = CII.INSTANCE_ID
AND MP.ORGANIZATION_ID = CII.LAST_VLD_ORGANIZATION_ID
AND SYSDATE BETWEEN NVL(CCA.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(CCA.END_DATE_ACTIVE
, SYSDATE+1)
AND SYSDATE BETWEEN NVL(EC.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(EC.END_DATE_ACTIVE
, SYSDATE+1)
AND SYSDATE BETWEEN NVL(CCR.ACTIVE_START_DATE(+)
, SYSDATE-1)
AND NVL(CCR.ACTIVE_END_DATE(+)
, SYSDATE+1)
AND CCT1.COUNTER_ID (+) = CCR.SOURCE_COUNTER_ID
AND CCT1.LANGUAGE (+) = USERENV('LANG')
AND EC.COUNTER_TYPE = 'REGULAR'
AND MSIK.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSIK.EAM_ITEM_TYPE IN (1
, 3)
AND MP.MAINT_ORGANIZATION_ID = CCA.MAINT_ORGANIZATION_ID UNION ALL SELECT DISTINCT CCIA.ROWID
, CCIA.CTR_ASSOCIATION_ID AS ASSOCIATION_ID
, EC.INITIAL_READING
, CCIA.COUNTER_ID METER_ID
, TO_NUMBER(NULL)
, CCIA.INVENTORY_ITEM_ID ASSET_GROUP_ID
, TO_CHAR(NULL) ASSET_NUMBER
, CCTT.NAME METER_NAME
, EC.READING_TYPE METER_TYPE
, EC.UOM_CODE METER_UOM
, EC.DIRECTION VALUE_CHANGE_DIR
, EC.EAM_REQUIRED_FLAG
, CCIA.PRIMARY_FAILURE_FLAG
, EC.USED_IN_SCHEDULING
, EC.DEFAULT_USAGE_RATE USER_DEFINED_RATE
, EC.USE_PAST_READING
, CCTT.DESCRIPTION
, EC.START_DATE_ACTIVE FROM_EFFECTIVE_DATE
, EC.END_DATE_ACTIVE TO_EFFECTIVE_DATE
, CCIA.CREATED_BY
, CCIA.CREATION_DATE
, CCIA.LAST_UPDATE_LOGIN
, CCIA.LAST_UPDATE_DATE
, CCIA.LAST_UPDATED_BY
, CCIA.ATTRIBUTE_CATEGORY
, CCIA.ATTRIBUTE1 ATTRIBUTE1
, CCIA.ATTRIBUTE2 ATTRIBUTE2
, CCIA.ATTRIBUTE3 ATTRIBUTE3
, CCIA.ATTRIBUTE4 ATTRIBUTE4
, CCIA.ATTRIBUTE5 ATTRIBUTE5
, CCIA.ATTRIBUTE6 ATTRIBUTE6
, CCIA.ATTRIBUTE7 ATTRIBUTE7
, CCIA.ATTRIBUTE8 ATTRIBUTE8
, CCIA.ATTRIBUTE9 ATTRIBUTE9
, CCIA.ATTRIBUTE10 ATTRIBUTE10
, CCIA.ATTRIBUTE11 ATTRIBUTE11
, CCIA.ATTRIBUTE12 ATTRIBUTE12
, CCIA.ATTRIBUTE13 ATTRIBUTE13
, CCIA.ATTRIBUTE14 ATTRIBUTE14
, CCIA.ATTRIBUTE15 ATTRIBUTE15
, TO_NUMBER(2) MAINTENANCE_OBJECT_TYPE
, CCIA.INVENTORY_ITEM_ID MAINTENANCE_OBJECT_ID
, TO_NUMBER(NULL) CREATION_ORGANIZATION_ID
, TO_CHAR('Y') TMPL_FLAG
, NULL SOURCE_TMPL_ID
, MSIK.EAM_ITEM_TYPE EAM_ITEM_TYPE
, MSIK.CONCATENATED_SEGMENTS ASSET_GROUP
, TO_CHAR(NULL)
, MSIK.DESCRIPTION ASSET_DESCRIPTION
, NULL SOURCE_METER_NAME
, NULL FACTOR
, NULL RELATIONSHIP_START_DATE
, EC.INITIAL_READING_DATE
, MP.MAINT_ORGANIZATION_ID
FROM CSI_COUNTER_TEMPLATE_B EC
, CSI_COUNTER_TEMPLATE_TL CCTT
, CSI_CTR_ITEM_ASSOCIATIONS CCIA
, MTL_SYSTEM_ITEMS_B_KFV MSIK
, MTL_PARAMETERS MP
WHERE CCIA.COUNTER_ID = EC.COUNTER_ID
AND EC.COUNTER_ID = CCTT.COUNTER_ID
AND CCTT.LANGUAGE = USERENV('LANG')
AND SYSDATE BETWEEN NVL(CCIA.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(CCIA.END_DATE_ACTIVE
, SYSDATE+1)
AND SYSDATE BETWEEN NVL(EC.START_DATE_ACTIVE
, SYSDATE-1)
AND NVL(EC.END_DATE_ACTIVE
, SYSDATE+1)
AND EC.COUNTER_TYPE = 'REGULAR'
AND MSIK.INVENTORY_ITEM_ID = CCIA.INVENTORY_ITEM_ID
AND MSIK.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSIK.EAM_ITEM_TYPE IN (1
, 3)

Columns