Product: | CSI - Install Base |
---|---|
Description: | Counter item associations view |
Implementation/DBA Data: | APPS.CSI_CTR_ITEM_ASSOCIATIONS_V |
SELECT CCI.CTR_ASSOCIATION_ID CTR_ASSOCIATION_ID
, CCI.GROUP_ID GROUP_ID
, CCI.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, MSI.CONCATENATED_SEGMENTS ITEM_NAME
, MSI.DESCRIPTION ITEM_DESCRIPTION
, CCI.COUNTER_ID COUNTER_ID
, CCI.USAGE_RATE USAGE_RATE
, CCI.USE_PAST_READING USE_PAST_READING
, CCI.ASSOCIATED_TO_GROUP ASSOCIATED_TO_GROUP
, CCI.START_DATE_ACTIVE START_DATE_ACTIVE
, CCI.END_DATE_ACTIVE END_DATE_ACTIVE
, CCI.SECURITY_GROUP_ID SECURITY_GROUP_ID
, CCI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCI.LAST_UPDATED_BY LAST_UPDATED_BY
, CCI.CREATION_DATE CREATION_DATE
, CCI.CREATED_BY CREATED_BY
, CCI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCI.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CCI.ATTRIBUTE1 ATTRIBUTE1
, CCI.ATTRIBUTE2 ATTRIBUTE2
, CCI.ATTRIBUTE3 ATTRIBUTE3
, CCI.ATTRIBUTE4 ATTRIBUTE4
, CCI.ATTRIBUTE5 ATTRIBUTE5
, CCI.ATTRIBUTE6 ATTRIBUTE6
, CCI.ATTRIBUTE7 ATTRIBUTE7
, CCI.ATTRIBUTE8 ATTRIBUTE8
, CCI.ATTRIBUTE9 ATTRIBUTE9
, CCI.ATTRIBUTE10 ATTRIBUTE10
, CCI.ATTRIBUTE11 ATTRIBUTE11
, CCI.ATTRIBUTE12 ATTRIBUTE12
, CCI.ATTRIBUTE13 ATTRIBUTE13
, CCI.ATTRIBUTE14 ATTRIBUTE14
, CCI.ATTRIBUTE15 ATTRIBUTE15
, CCI.MIGRATED_FLAG MIGRATED_FLAG
FROM CSI_CTR_ITEM_ASSOCIATIONS CCI
, MTL_SYSTEM_ITEMS_KFV MSI
WHERE CCI.INVENTORY_ITEM_ID = MSI.INVENTORY_ITEM_ID (+)
AND MSI.ORGANIZATION_ID (+) = FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG')