View: CSI_CP_COUNTERS_V

Product:	CSI - Install Base
Description:	Backward Compatible : Customer Product Counters.
Implementation/DBA Data:	APPS.CSI_CP_COUNTERS_V

View Text

SELECT CV.ROWID ROW_ID
, C.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CV.TRANSACTION_ID COUNTER_GRP_LOG_ID
, C.COUNTER_ID COUNTER_ID
, CV.COUNTER_VALUE_ID COUNTER_VALUE_ID
, C.DEFAULTED_GROUP_ID COUNTER_GROUP_ID
, C.NAME COUNTER_NAME
, C.DESCRIPTION COUNTER_DESCRIPTION
, CV.VALUE_TIMESTAMP VALUE_TIMESTAMP
, NVL(CV.COUNTER_READING
, C.INITIAL_READING) COUNTER_READING
, CV.NET_READING NET_READING
, DECODE(CV.RESET_MODE
, NULL
, 'N'
, 'Y') RESET_FLAG
, CV.RESET_REASON RESET_REASON
, CV.ADJUSTMENT_TYPE MISC_READING_TYPE
, CV.ADJUSTMENT_READING MISC_READING
, C.INITIAL_READING INITIAL_READING
, C.UOM_CODE UOM_CODE
, C.TOLERANCE_PLUS TOLERANCE_PLUS
, C.TOLERANCE_MINUS TOLERANCE_MINUS
, C.COUNTER_TYPE TYPE
, C.ROLLOVER_LAST_READING ROLLOVER_LAST_READING
, C.ROLLOVER_FIRST_READING ROLLOVER_FIRST_READING
, CII.INSTANCE_ID CUSTOMER_PRODUCT_ID
, CII.INSTANCE_NUMBER REFERENCE_NUMBER
, C.FORMULA_INCOMPLETE_FLAG FORMULA_INCOMPL_FLAG
, MSITEM.CONCATENATED_SEGMENTS PRODUCT_NAME
, MSITEM.DESCRIPTION PRODUCT_DESCRIPTION
, CII.SERIAL_NUMBER SERIAL_NUMBER
, CII.LOT_NUMBER LOT_NUMBER
, C.START_DATE_ACTIVE START_DATE_ACTIVE
, C.END_DATE_ACTIVE END_DATE_ACTIVE
, CV.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CV.LAST_UPDATED_BY LAST_UPDATED_BY
, CV.CREATION_DATE CREATION_DATE
, CV.CREATED_BY CREATED_BY
, CV.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CV.ATTRIBUTE1 ATTRIBUTE1
, CV.ATTRIBUTE2 ATTRIBUTE2
, CV.ATTRIBUTE3 ATTRIBUTE3
, CV.ATTRIBUTE4 ATTRIBUTE4
, CV.ATTRIBUTE5 ATTRIBUTE5
, CV.ATTRIBUTE6 ATTRIBUTE6
, CV.ATTRIBUTE7 ATTRIBUTE7
, CV.ATTRIBUTE8 ATTRIBUTE8
, CV.ATTRIBUTE9 ATTRIBUTE9
, CV.ATTRIBUTE10 ATTRIBUTE10
, CV.ATTRIBUTE11 ATTRIBUTE11
, CV.ATTRIBUTE12 ATTRIBUTE12
, CV.ATTRIBUTE13 ATTRIBUTE13
, CV.ATTRIBUTE14 ATTRIBUTE14
, CV.ATTRIBUTE15 ATTRIBUTE15
, CV.ATTRIBUTE_CATEGORY CONTEXT
FROM CSI_COUNTERS_VL C
, CSI_COUNTER_READINGS CV
, CSI_ITEM_INSTANCES CII
, MTL_SYSTEM_ITEMS_KFV MSITEM
, CSI_COUNTER_ASSOCIATIONS CCA
WHERE C.COUNTER_ID = CV.COUNTER_ID(+) AND C.COUNTER_ID = CCA.COUNTER_ID(+) AND CCA.SOURCE_OBJECT_CODE = 'CP' AND CCA.SOURCE_OBJECT_ID = CII.INSTANCE_ID AND MSITEM.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID AND MSITEM.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID

Columns