[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;
|
|
|