VIEW: APPS.CSI_CP_COUNTERS_V

Source

View Text - Preformatted

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, C.CREATED_FROM_COUNTER_TMPL_ID CREATED_FROM_COUNTER_TMPL_ID, decode(instr(c.name,'-'||to_char(c.counter_id)),0,c.name,substr(c.name,1,instr(c.name,'-'||to_char(c.counter_id))-1)) COUNTER_TEMPLATE_NAME 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

View Text - HTML Formatted

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
, C.CREATED_FROM_COUNTER_TMPL_ID CREATED_FROM_COUNTER_TMPL_ID
, DECODE(INSTR(C.NAME
, '-'||TO_CHAR(C.COUNTER_ID))
, 0
, C.NAME
, SUBSTR(C.NAME
, 1
, INSTR(C.NAME
, '-'||TO_CHAR(C.COUNTER_ID))-1)) COUNTER_TEMPLATE_NAME
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