Product: | CSI - Install Base |
---|---|
Description: | Counter instance view language |
Implementation/DBA Data: | APPS.CSI_COUNTERS_VL |
SELECT CCB.COUNTER_ID COUNTER_ID
, CCB.GROUP_ID GROUP_ID
, CCT.NAME NAME
, CCT.DESCRIPTION DESCRIPTION
, CCB.COUNTER_TYPE COUNTER_TYPE
, CCB.INITIAL_READING INITIAL_READING
, CCB.STEP_VALUE STEP_VALUE
, CCB.TOLERANCE_PLUS TOLERANCE_PLUS
, CCB.TOLERANCE_MINUS TOLERANCE_MINUS
, CCB.UOM_CODE UOM_CODE
, CCB.DERIVE_COUNTER_ID DERIVE_COUNTER_ID
, CCB.DERIVE_FUNCTION DERIVE_FUNCTION
, CCB.DERIVE_PROPERTY_ID DERIVE_PROPERTY_ID
, CCB.VALID_FLAG VALID_FLAG
, CCB.FORMULA_INCOMPLETE_FLAG FORMULA_INCOMPLETE_FLAG
, CCB.FORMULA_TEXT FORMULA_TEXT
, CCB.ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, CCB.ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, CCB.USAGE_ITEM_ID USAGE_ITEM_ID
, CCB.CTR_VAL_MAX_SEQ_NO CTR_VAL_MAX_SEQ_NO
, CCB.START_DATE_ACTIVE START_DATE_ACTIVE
, CCB.END_DATE_ACTIVE END_DATE_ACTIVE
, CCB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCB.CREATION_DATE CREATION_DATE
, CCB.CREATED_BY CREATED_BY
, CCB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCB.ATTRIBUTE1 ATTRIBUTE1
, CCB.ATTRIBUTE2 ATTRIBUTE2
, CCB.ATTRIBUTE3 ATTRIBUTE3
, CCB.ATTRIBUTE4 ATTRIBUTE4
, CCB.ATTRIBUTE5 ATTRIBUTE5
, CCB.ATTRIBUTE6 ATTRIBUTE6
, CCB.ATTRIBUTE7 ATTRIBUTE7
, CCB.ATTRIBUTE8 ATTRIBUTE8
, CCB.ATTRIBUTE9 ATTRIBUTE9
, CCB.ATTRIBUTE10 ATTRIBUTE10
, CCB.ATTRIBUTE11 ATTRIBUTE11
, CCB.ATTRIBUTE12 ATTRIBUTE12
, CCB.ATTRIBUTE13 ATTRIBUTE13
, CCB.ATTRIBUTE14 ATTRIBUTE14
, CCB.ATTRIBUTE15 ATTRIBUTE15
, CCB.ATTRIBUTE16 ATTRIBUTE16
, CCB.ATTRIBUTE17 ATTRIBUTE17
, CCB.ATTRIBUTE18 ATTRIBUTE18
, CCB.ATTRIBUTE19 ATTRIBUTE19
, CCB.ATTRIBUTE20 ATTRIBUTE20
, CCB.ATTRIBUTE21 ATTRIBUTE21
, CCB.ATTRIBUTE22 ATTRIBUTE22
, CCB.ATTRIBUTE23 ATTRIBUTE23
, CCB.ATTRIBUTE24 ATTRIBUTE24
, CCB.ATTRIBUTE25 ATTRIBUTE25
, CCB.ATTRIBUTE26 ATTRIBUTE26
, CCB.ATTRIBUTE27 ATTRIBUTE27
, CCB.ATTRIBUTE28 ATTRIBUTE28
, CCB.ATTRIBUTE29 ATTRIBUTE29
, CCB.ATTRIBUTE30 ATTRIBUTE30
, CCB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCB.MIGRATED_FLAG MIGRATED_FLAG
, CCB.CUSTOMER_VIEW CUSTOMER_VIEW
, CCB.DIRECTION DIRECTION
, CCB.FILTER_TYPE FILTER_TYPE
, CCB.FILTER_READING_COUNT FILTER_READING_COUNT
, CCB.FILTER_TIME_UOM FILTER_TIME_UOM
, CCB.ESTIMATION_ID ESTIMATION_ID
, CCB.READING_TYPE READING_TYPE
, CCB.AUTOMATIC_ROLLOVER AUTOMATIC_ROLLOVER
, CCB.DEFAULT_USAGE_RATE DEFAULT_USAGE_RATE
, CCB.USE_PAST_READING USE_PAST_READING
, CCB.USED_IN_SCHEDULING USED_IN_SCHEDULING
, CCB.DEFAULTED_GROUP_ID DEFAULTED_GROUP_ID
, CCB.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCB.CREATED_FROM_COUNTER_TMPL_ID CREATED_FROM_COUNTER_TMPL_ID
, CCB.COMMENTS COMMENTS
, CCB.INITIAL_READING_DATE INITIAL_READING_DATE
FROM CSI_COUNTERS_B CCB
, CSI_COUNTERS_TL CCT
WHERE CCB.COUNTER_ID = CCT.COUNTER_ID
AND CCT.LANGUAGE = USERENV('LANG')