[Home] [Help] [Dependency Information]
Object Name: | CSI_COUNTERS_BCV_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_COUNTERS_BCV_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
A backward compatible view for CS_COUNTERS_V view. This was created to support the pre R12 releases of Counters.
This backward compatible view contains the attributes of the instantiated and template counters. The view will help user identify what counter type, reading type, UOM and if a rollover is permitted to the counters.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COUNTER_ID | NUMBER | Auto generate internal primary key | ||
COUNTER_GROUP_ID | NUMBER | Group Identifier | ||
NAME | VARCHAR2 | (80) | Counter name | |
DESCRIPTION | VARCHAR2 | (240) | Counter description | |
COUNTER_GROUP_NAME | VARCHAR2 | (100) | Yes | Counter group name |
COUNTER_GROUP_DESCRIPTION | VARCHAR2 | (240) | Counter group description | |
STEP_VALUE | NUMBER | Step Value | ||
TOLERANCE_PLUS | NUMBER | Tolerance Plus % | ||
TOLERANCE_MINUS | NUMBER | Tolerance Minus % | ||
UOM_CODE | VARCHAR2 | (3) | Unit of Measure Code | |
UNIT_OF_MEASURE | VARCHAR2 | (25) | Unit of Measure name | |
INITIAL_READING | NUMBER | Counter Initial Reading | ||
VALID_FLAG | VARCHAR2 | (1) | Indicator to check if the formula counter and derived filters are valid | |
TYPE | VARCHAR2 | (30) | Counter Type | |
FORMULA_TEXT | VARCHAR2 | (1996) | Text for the Formula Counter Type | |
COMMENTS | VARCHAR2 | (1996) | Counter additional information | |
DERIVE_FUNCTION | VARCHAR2 | (30) | Derive Function | |
DERIVE_PROPERTY_ID | NUMBER | Derive Property ID | ||
DERIVE_PROPERTY_NAME | VARCHAR2 | (50) | Derive property name | |
DERIVE_COUNTER_ID | NUMBER | Derive Counter ID | ||
DERIVE_COUNTER_NAME | VARCHAR2 | (80) | Derive counter name | |
SOURCE_COUNTER_ID | NUMBER | Source counter identifier | ||
ROLLOVER_LAST_READING | NUMBER | Rollover from value | ||
ROLLOVER_FIRST_READING | NUMBER | Rollover to value | ||
FORMULA_INCOMPLETE_FLAG | VARCHAR2 | (1) | Indicator to check if formula is complete | |
USAGE_ITEM_ID | NUMBER | Usage Item Identifier | ||
USAGE_ITEM_NAME | VARCHAR2 | (40) | Usage item name | |
CREATED_FROM_COUNTER_TMPL_ID | NUMBER | Counter template ID to which this counter is copied | ||
LAST_UPDATE_DATE | DATE | Standard WHO Column | ||
LAST_UPDATED_BY | NUMBER | (15) | Standard WHO Column | |
CREATION_DATE | DATE | Standard WHO Column | ||
CREATED_BY | NUMBER | (15) | Standard WHO Column | |
LAST_UPDATE_LOGIN | NUMBER | (15) | Standard WHO Column | |
START_DATE_ACTIVE | DATE | Activation Start Date | ||
END_DATE_ACTIVE | DATE | Activation End Date | ||
ATTRIBUTE1 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE2 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE3 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE4 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE5 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE6 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE7 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE8 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE9 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE10 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE11 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE12 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE13 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE14 | VARCHAR2 | (150) | Standard DFF Column | |
ATTRIBUTE15 | VARCHAR2 | (150) | Standard DFF Column | |
CONTEXT | VARCHAR2 | (30) | Standard DFF Column | |
OBJECT_VERSION_NUMBER | NUMBER | Object Version Number | ||
CUSTOMER_VIEW | VARCHAR2 | (1) | Customer view indicator | |
DIRECTION | VARCHAR2 | (1) | Counter direction | |
FILTER_TYPE | VARCHAR2 | (30) | Counter filter type | |
FILTER_READING_COUNT | NUMBER | Filter reading count | ||
FILTER_TIME_UOM | VARCHAR2 | (30) | Filter time UOM code | |
ESTIMATION_ID | NUMBER | Estimation identifier | ||
ESTIMATION_NAME | VARCHAR2 | (50) | Estimation Name |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_ID
, COUNTER_GROUP_ID
, NAME
, DESCRIPTION
, COUNTER_GROUP_NAME
, COUNTER_GROUP_DESCRIPTION
, STEP_VALUE
, TOLERANCE_PLUS
, TOLERANCE_MINUS
, UOM_CODE
, UNIT_OF_MEASURE
, INITIAL_READING
, VALID_FLAG
, TYPE
, FORMULA_TEXT
, COMMENTS
, DERIVE_FUNCTION
, DERIVE_PROPERTY_ID
, DERIVE_PROPERTY_NAME
, DERIVE_COUNTER_ID
, DERIVE_COUNTER_NAME
, SOURCE_COUNTER_ID
, ROLLOVER_LAST_READING
, ROLLOVER_FIRST_READING
, FORMULA_INCOMPLETE_FLAG
, USAGE_ITEM_ID
, USAGE_ITEM_NAME
, CREATED_FROM_COUNTER_TMPL_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, START_DATE_ACTIVE
, END_DATE_ACTIVE
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, OBJECT_VERSION_NUMBER
, CUSTOMER_VIEW
, DIRECTION
, FILTER_TYPE
, FILTER_READING_COUNT
, FILTER_TIME_UOM
, ESTIMATION_ID
, ESTIMATION_NAME
FROM APPS.CSI_COUNTERS_BCV_V;
|
|
|