View: CSI_COUNTERS_BCV_V

Product:	CSI - Install Base
Description:	Backward compatible view for CS_COUNTERS_V
Implementation/DBA Data:	APPS.CSI_COUNTERS_BCV_V

View Text

SELECT CCTB.COUNTER_ID COUNTER_ID
, CCTB.COUNTER_GROUP_ID COUNTER_GROUP_ID
, CCTB.NAME NAME
, CCTB.DESCRIPTION DESCRIPTION
, CCG.NAME COUNTER_GROUP_NAME
, CCG.DESCRIPTION COUNTER_GROUP_DESCRIPTION
, CCTB.STEP_VALUE STEP_VALUE
, CCTB.TOLERANCE_PLUS TOLERANCE_PLUS
, CCTB.TOLERANCE_MINUS TOLERANCE_MINUS
, CCTB.UOM_CODE UOM_CODE
, MUM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CCTB.INITIAL_READING INITIAL_READING
, CCTB.VALID_FLAG VALID_FLAG
, CCTB.TYPE TYPE
, CCTB.FORMULA_TEXT FORMULA_TEXT
, CCTB.COMMENTS COMMENTS
, CCTB.DERIVE_FUNCTION DERIVE_FUNCTION
, CCTB.DERIVE_PROPERTY_ID DERIVE_PROPERTY_ID
, CCPB.NAME DERIVE_PROPERTY_NAME
, CCTB.DERIVE_COUNTER_ID DERIVE_COUNTER_ID
, CCPT.NAME DERIVE_COUNTER_NAME
, CCTB.SOURCE_COUNTER_ID SOURCE_COUNTER_ID
, CCTB.ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, CCTB.ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, CCTB.FORMULA_INCOMPLETE_FLAG FORMULA_INCOMPL_FLAG
, CCTB.USAGE_ITEM_ID USAGE_ITEM_ID
, MSI.CONCATENATED_SEGMENTS USAGE_ITEM_NAME
, CCTB.CREATED_FROM_COUNTER_TMPL_ID CREATED_FROM_COUNTER_TMPL_ID
, CCTB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCTB.LAST_UPDATED_BY LAST_UPDATED_BY
, CCTB.CREATION_DATE CREATION_DATE
, CCTB.CREATED_BY CREATED_BY
, CCTB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCTB.START_DATE_ACTIVE START_DATE_ACTIVE
, CCTB.END_DATE_ACTIVE END_DATE_ACTIVE
, CCTB.ATTRIBUTE1 ATTRIBUTE1
, CCTB.ATTRIBUTE2 ATTRIBUTE2
, CCTB.ATTRIBUTE3 ATTRIBUTE3
, CCTB.ATTRIBUTE4 ATTRIBUTE4
, CCTB.ATTRIBUTE5 ATTRIBUTE5
, CCTB.ATTRIBUTE6 ATTRIBUTE6
, CCTB.ATTRIBUTE7 ATTRIBUTE7
, CCTB.ATTRIBUTE8 ATTRIBUTE8
, CCTB.ATTRIBUTE9 ATTRIBUTE9
, CCTB.ATTRIBUTE10 ATTRIBUTE10
, CCTB.ATTRIBUTE11 ATTRIBUTE11
, CCTB.ATTRIBUTE12 ATTRIBUTE12
, CCTB.ATTRIBUTE13 ATTRIBUTE13
, CCTB.ATTRIBUTE14 ATTRIBUTE14
, CCTB.ATTRIBUTE15 ATTRIBUTE15
, CCTB.CONTEXT CONTEXT
, CCTB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCTB.CUSTOMER_VIEW CUSTOMER_VIEW
, CCTB.DIRECTION DIRECTION
, CCTB.FILTER_TYPE FILTER_TYPE
, CCTB.FILTER_READING_COUNT FILTER_READING_COUNT
, CCTB.FILTER_TIME_UOM FILTER_TIME_UOM
, CCTB.ESTIMATION_ID ESTIMATION_ID
, CCEB.NAME ESTIMATION_NAME
FROM CSI_COUNTERS_BC_V CCTB
, MTL_UNITS_OF_MEASURE MUM
, MTL_SYSTEM_ITEMS_KFV MSI
, CSI_CTR_ESTIMATE_METHODS_VL CCEB
, CSI_CTR_PROPERTIES_BC_V CCPB
, CS_COUNTER_GROUPS CCG
, CSI_COUNTERS_BC_V CCPT
WHERE CCG.COUNTER_GROUP_ID = CCTB.COUNTER_GROUP_ID
AND CCTB.ESTIMATION_ID = CCEB.ESTIMATION_ID (+)
AND CCTB.DERIVE_PROPERTY_ID = CCPB.COUNTER_PROPERTY_ID(+)
AND CCTB.USAGE_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND MSI.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND CCTB.UOM_CODE = MUM.UOM_CODE (+)
AND CCPT.COUNTER_ID (+) = CCTB.DERIVE_COUNTER_ID

Columns