Product: | CSI - Install Base |
---|---|
Description: | Backward compatible view for CS_COUNTERS |
Implementation/DBA Data: | APPS.CSI_COUNTERS_BC_V |
SELECT COUNTER_ID COUNTER_ID
, DEFAULTED_GROUP_ID COUNTER_GROUP_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, STEP_VALUE STEP_VALUE
, TOLERANCE_PLUS TOLERANCE_PLUS
, TOLERANCE_MINUS TOLERANCE_MINUS
, UOM_CODE UOM_CODE
, DERIVE_FUNCTION DERIVE_FUNCTION
, DERIVE_COUNTER_ID DERIVE_COUNTER_ID
, DERIVE_PROPERTY_ID DERIVE_PROPERTY_ID
, VALID_FLAG VALID_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY CONTEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, NULL CREATED_FROM_COUNTER_TMPL_ID
, COUNTER_TYPE TYPE
, INITIAL_READING INITIAL_READING
, NULL SOURCE_COUNTER_ID
, FORMULA_INCOMPLETE_FLAG FORMULA_INCOMPL_FLAG
, FORMULA_TEXT FORMULA_TEXT
, ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, COMMENTS COMMENTS
, USAGE_ITEM_ID USAGE_ITEM_ID
, CTR_VAL_MAX_SEQ_NO CTR_VAL_MAX_SEQ_NO
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CUSTOMER_VIEW CUSTOMER_VIEW
, DIRECTION DIRECTION
, FILTER_TYPE FILTER_TYPE
, FILTER_READING_COUNT FILTER_READING_COUNT
, FILTER_TIME_UOM FILTER_TIME_UOM
, ESTIMATION_ID ESTIMATION_ID
FROM CSI_COUNTER_TEMPLATE_VL UNION ALL SELECT COUNTER_ID COUNTER_ID
, DEFAULTED_GROUP_ID COUNTER_GROUP_ID
, NAME NAME
, DESCRIPTION DESCRIPTION
, STEP_VALUE STEP_VALUE
, TOLERANCE_PLUS TOLERANCE_PLUS
, TOLERANCE_MINUS TOLERANCE_MINUS
, UOM_CODE UOM_CODE
, DERIVE_FUNCTION DERIVE_FUNCTION
, DERIVE_COUNTER_ID DERIVE_COUNTER_ID
, DERIVE_PROPERTY_ID DERIVE_PROPERTY_ID
, VALID_FLAG VALID_FLAG
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, START_DATE_ACTIVE START_DATE_ACTIVE
, END_DATE_ACTIVE END_DATE_ACTIVE
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY CONTEXT
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CREATED_FROM_COUNTER_TMPL_ID CREATED_FROM_COUNTER_TMPL_ID
, COUNTER_TYPE TYPE
, INITIAL_READING INITIAL_READING
, CREATED_FROM_COUNTER_TMPL_ID SOURCE_COUNTER_ID
, FORMULA_INCOMPLETE_FLAG FORMULA_INCOMPL_FLAG
, FORMULA_TEXT FORMULA_TEXT
, ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, COMMENTS COMMENTS
, USAGE_ITEM_ID USAGE_ITEM_ID
, CTR_VAL_MAX_SEQ_NO CTR_VAL_MAX_SEQ_NO
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, CUSTOMER_VIEW CUSTOMER_VIEW
, DIRECTION DIRECTION
, FILTER_TYPE FILTER_TYPE
, FILTER_READING_COUNT FILTER_READING_COUNT
, FILTER_TIME_UOM FILTER_TIME_UOM
, ESTIMATION_ID ESTIMATION_ID
FROM CSI_COUNTERS_VL