Product: | CSI - Install Base |
---|---|
Description: | Backward compatible view for CS_CTR_ASSOCIATIONS |
Implementation/DBA Data: | APPS.CSI_CTR_ITEM_ASSOCIATIONS_BC_V |
SELECT CTR_ASSOCIATION_ID CTR_ASSOCIATION_ID
, GROUP_ID COUNTER_GROUP_ID
, INVENTORY_ITEM_ID SOURCE_OBJECT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, ATTRIBUTE_CATEGORY CONTEXT
, SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM CSI_CTR_ITEM_ASSOCIATIONS CCI
WHERE ASSOCIATED_TO_GROUP = 'Y' UNION ALL SELECT CCI.CTR_ASSOCIATION_ID CTR_ASSOCIATION_ID
, CCT.DEFAULTED_GROUP_ID COUNTER_GROUP_ID
, CCI.INVENTORY_ITEM_ID SOURCE_OBJECT_ID
, CCI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CCI.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CCI.LAST_UPDATED_BY LAST_UPDATED_BY
, CCI.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CCI.CREATION_DATE CREATION_DATE
, CCI.CREATED_BY CREATED_BY
, 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.ATTRIBUTE_CATEGORY CONTEXT
, CCI.SECURITY_GROUP_ID SECURITY_GROUP_ID
FROM CSI_CTR_ITEM_ASSOCIATIONS CCI
, CSI_COUNTER_TEMPLATE_VL CCT
WHERE CCI.COUNTER_ID = CCT.COUNTER_ID
AND CCI.ASSOCIATED_TO_GROUP = 'N'