[Home] [Help]
[Dependency Information]
[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;
APPS
CSI_COUNTERS_BC_V
CSI_CTR_ESTIMATE_METHODS_VL
CSI_CTR_PROPERTIES_BC_V
CS_CSI_COUNTER_GROUPS
CS_STD
- show dependent code
MTL_SYSTEM_ITEMS_KFV
MTL_UNITS_OF_MEASURE
APPS
CS_COUNTERS_V
|
|
|
|