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