View: CSI_INST_CATG_EXT_ATTR_V

Product:	CSI - Install Base
Description:	Internal View : Used in CSI_INST_EXT_ATTR_ALL_V
Implementation/DBA Data:	APPS.CSI_INST_CATG_EXT_ATTR_V

View Text

SELECT CEA.ATTRIBUTE_ID ATTRIBUTE_ID
, CEA.ATTRIBUTE_LEVEL ATTRIBUTE_LEVEL
, CEA.MASTER_ORGANIZATION_ID MASTER_ORGANIZATION_ID
, CEA.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CEA.ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, CEA.INSTANCE_ID INSTANCE_ID
, CEA.ATTRIBUTE_CODE ATTRIBUTE_CODE
, CEA.ATTRIBUTE_NAME ATTRIBUTE_NAME
, CEA.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CEA.DESCRIPTION DESCRIPTION
, CEA.ACTIVE_START_DATE ACTIVE_START_DATE
, CEA.ACTIVE_END_DATE ACTIVE_END_DATE
, CEA.CONTEXT CONTEXT
, CEA.ATTRIBUTE1 ATTRIBUTE1
, CEA.ATTRIBUTE2 ATTRIBUTE2
, CEA.ATTRIBUTE3 ATTRIBUTE3
, CEA.ATTRIBUTE4 ATTRIBUTE4
, CEA.ATTRIBUTE5 ATTRIBUTE5
, CEA.ATTRIBUTE6 ATTRIBUTE6
, CEA.ATTRIBUTE7 ATTRIBUTE7
, CEA.ATTRIBUTE8 ATTRIBUTE8
, CEA.ATTRIBUTE9 ATTRIBUTE9
, CEA.ATTRIBUTE10 ATTRIBUTE10
, CEA.ATTRIBUTE11 ATTRIBUTE11
, CEA.ATTRIBUTE12 ATTRIBUTE12
, CEA.ATTRIBUTE13 ATTRIBUTE13
, CEA.ATTRIBUTE14 ATTRIBUTE14
, CEA.ATTRIBUTE15 ATTRIBUTE15
, CEA.CREATED_BY CREATED_BY
, CEA.CREATION_DATE CREATION_DATE
, CEA.LAST_UPDATED_BY LAST_UPDATED_BY
, CEA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CEA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CEA.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CII.INSTANCE_ID SRC_INSTANCE_ID
FROM CSI_I_EXTENDED_ATTRIBS CEA
, CSI_ITEM_INSTANCES CII
, MTL_ITEM_CATEGORIES MIC
WHERE MIC.ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID
AND MIC.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID
AND MIC.CATEGORY_SET_ID = ( SELECT CATEGORY_SET_ID
FROM CSI_INSTALL_PARAMETERS )
AND CEA.ATTRIBUTE_LEVEL = 'CATEGORY'
AND CEA.ITEM_CATEGORY_ID = MIC.CATEGORY_ID

Columns