[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CSI_COUNTERS_BC_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  CSI.CSI_COUNTERS_BC_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. 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 | |
| STEP_VALUE | NUMBER | Step Value | ||
| TOLERANCE_PLUS | NUMBER | Tolerance Plus % | ||
| TOLERANCE_MINUS | NUMBER | Tolerance Minus % | ||
| UOM_CODE | VARCHAR2 | (3) | Unit of Measure Code | |
| DERIVE_FUNCTION | VARCHAR2 | (30) | Derive Function | |
| DERIVE_COUNTER_ID | NUMBER | Derive Counter ID | ||
| DERIVE_PROPERTY_ID | NUMBER | Derive Property ID | ||
| VALID_FLAG | VARCHAR2 | (1) | Indicator to check if the formula counter and derived filters are valid | |
| 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 | ||
| CREATED_FROM_COUNTER_TMPL_ID | NUMBER | Counter template ID to which this counter is copied | ||
| TYPE | VARCHAR2 | (30) | Counter Type | |
| INITIAL_READING | NUMBER | Counter Initial Reading | ||
| SOURCE_COUNTER_ID | NUMBER | Source counter identifier | ||
| FORMULA_INCOMPLETE_FLAG | VARCHAR2 | (1) | Indicator to check if formula is complete | |
| FORMULA_TEXT | VARCHAR2 | (1996) | Text for the Formula Counter Type | |
| ROLLOVER_LAST_READING | NUMBER | Rollover from value | ||
| ROLLOVER_FIRST_READING | NUMBER | Rollover to value | ||
| COMMENTS | VARCHAR2 | (1996) | Counter additional information | |
| USAGE_ITEM_ID | NUMBER | Usage Item Identifier | ||
| CTR_VAL_MAX_SEQ_NO | NUMBER | Counter value maximum sequence number | ||
| SECURITY_GROUP_ID | NUMBER | Security group identifier | ||
| 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 |
Cut, paste (and edit) the following text to query this object:
SELECT COUNTER_ID
, COUNTER_GROUP_ID
, NAME
, DESCRIPTION
, STEP_VALUE
, TOLERANCE_PLUS
, TOLERANCE_MINUS
, UOM_CODE
, DERIVE_FUNCTION
, DERIVE_COUNTER_ID
, DERIVE_PROPERTY_ID
, VALID_FLAG
, 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
, CREATED_FROM_COUNTER_TMPL_ID
, TYPE
, INITIAL_READING
, SOURCE_COUNTER_ID
, FORMULA_INCOMPLETE_FLAG
, FORMULA_TEXT
, ROLLOVER_LAST_READING
, ROLLOVER_FIRST_READING
, COMMENTS
, USAGE_ITEM_ID
, CTR_VAL_MAX_SEQ_NO
, SECURITY_GROUP_ID
, CUSTOMER_VIEW
, DIRECTION
, FILTER_TYPE
, FILTER_READING_COUNT
, FILTER_TIME_UOM
, ESTIMATION_ID
FROM APPS.CSI_COUNTERS_BC_V;
APPS
CSI_COUNTERS_VL
CSI_COUNTER_TEMPLATE_VL
APPS
CSI_COUNTERS_BCV_V
CSI_COUNTER_READINGS_BCV_V
CSI_COUNTER_TEMPLATE_PVT
- show dependent code
CSI_CTR_GEN_UTILITY_PVT
- show dependent code
CS_COUNTERS
OKS_BILL_REC_PUB
- show dependent code
OKX_COUNTERS_V
|
|
|
|