DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.CSI_COUNTERS_BCV_V

Object Details
Object Name: CSI_COUNTERS_BCV_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_COUNTERS_BCV_V
Subobject Name:
Status: VALID

View Type

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.


[View Source]

Columns
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
Query Text

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;

Dependencies

[top of page]

APPS.CSI_COUNTERS_BCV_V references the following:

SchemaAPPS
ViewCSI_COUNTERS_BC_V
ViewCSI_CTR_ESTIMATE_METHODS_VL
ViewCSI_CTR_PROPERTIES_BC_V
SynonymCS_CSI_COUNTER_GROUPS
PL/SQL PackageCS_STD - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymMTL_UNITS_OF_MEASURE
APPS.CSI_COUNTERS_BCV_V is referenced by following:

SchemaAPPS
SynonymCS_COUNTERS_V