Product: | CSI - Install Base |
---|---|
Description: | Counter property readings view |
Implementation/DBA Data: | APPS.CSI_CTR_PROPERTY_READINGS_V |
SELECT CCPR.COUNTER_PROP_VALUE_ID COUNTER_PROP_VALUE_ID
, CCPR.COUNTER_VALUE_ID COUNTER_VALUE_ID
, CCPR.COUNTER_PROPERTY_ID COUNTER_PROPERTY_ID
, CCP.NAME PROPERTY_NAME
, CCP.DESCRIPTION PROPERTY_DESCRIPTION
, CCPR.PROPERTY_VALUE PROPERTY_VALUE
, CCP.PROPERTY_DATA_TYPE PROPERTY_DATA_TYPE
, CCP.UOM_CODE UOM
, CCPR.VALUE_TIMESTAMP VALUE_TIMESTAMP
, CCPR.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCPR.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCPR.LAST_UPDATED_BY LAST_UPDATED_BY
, CCPR.CREATION_DATE CREATION_DATE
, CCPR.CREATED_BY CREATED_BY
, CCPR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCPR.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCPR.ATTRIBUTE1 ATTRIBUTE1
, CCPR.ATTRIBUTE2 ATTRIBUTE2
, CCPR.ATTRIBUTE3 ATTRIBUTE3
, CCPR.ATTRIBUTE4 ATTRIBUTE4
, CCPR.ATTRIBUTE5 ATTRIBUTE5
, CCPR.ATTRIBUTE6 ATTRIBUTE6
, CCPR.ATTRIBUTE7 ATTRIBUTE7
, CCPR.ATTRIBUTE8 ATTRIBUTE8
, CCPR.ATTRIBUTE9 ATTRIBUTE9
, CCPR.ATTRIBUTE10 ATTRIBUTE10
, CCPR.ATTRIBUTE11 ATTRIBUTE11
, CCPR.ATTRIBUTE12 ATTRIBUTE12
, CCPR.ATTRIBUTE13 ATTRIBUTE13
, CCPR.ATTRIBUTE14 ATTRIBUTE14
, CCPR.ATTRIBUTE15 ATTRIBUTE15
, CCPR.MIGRATED_FLAG MIGRATED_FLAG
, MUM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CCP.START_DATE_ACTIVE START_DATE_ACTIVE
, CCP.END_DATE_ACTIVE END_DATE_ACTIVE
, CCP.DEFAULT_VALUE DEFAULT_VALUE
, CCP.MINIMUM_VALUE MINIMUM_VALUE
, CCP.MAXIMUM_VALUE MAXIMUM_VALUE
FROM CSI_CTR_PROPERTY_READINGS CCPR
, CSI_COUNTER_PROPERTIES_VL CCP
, CSI_COUNTER_READINGS CCR
, MTL_UNITS_OF_MEASURE MUM
WHERE CCPR.COUNTER_PROPERTY_ID = CCP.COUNTER_PROPERTY_ID (+)
AND CCPR.COUNTER_VALUE_ID = CCR.COUNTER_VALUE_ID
AND CCP.UOM_CODE = MUM.UOM_CODE (+)