Results for “csi_inst_item_ext_attr_v”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CSI_INST_ITEM_EXT_ATTR_V is a seeded, read-only view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the CSI – Install Base product family and is classified in ETRM documentation as an internal view, with the documented description: "Internal View : Used in CSI_INST_EXT_ATTR_ALL_V." Its status is VALID.

The view presents item-level extended attribute definitions and values held against inventory items that participate in the Install Base. Specifically, it filters the extended attribute repository to records whose ATTRIBUTE_LEVEL equals ITEM and joins those records to the item instances they describe. Because it is an internal view, it is not intended as a public API surface; rather, it functions as a building block for the higher-level, consumer-facing view CSI_INST_EXT_ATTR_ALL_V, which consolidates instance-level and item-level extended attributes for reporting and integration purposes.

Underlying Base Objects

The view is defined over two documented base objects, exposed through APPS synonyms:

• CSI_I_EXTENDED_ATTRIBS (aliased CEA) – the extended attribute repository that stores attribute definitions, level indicators, validity dates, context, and the descriptive flexfield segment columns (ATTRIBUTE1 through ATTRIBUTE15).
• CSI_ITEM_INSTANCES (aliased CII) – the Install Base item instance table, which supplies the item's instance identity and master organization context.

The join predicate restricts the result set to item-level attributes only and correlates them to item instances on two keys: CEA.INVENTORY_ITEM_ID = CII.INVENTORY_ITEM_ID and CEA.MASTER_ORGANIZATION_ID = CII.INV_MASTER_ORGANIZATION_ID. The view therefore returns one extended attribute row for each matching item instance, carrying the source instance identifier as SRC_INSTANCE_ID.

Key Columns

• ATTRIBUTE_ID – Primary surrogate key of the extended attribute record.
• ATTRIBUTE_LEVEL – Qualification of the attribute scope; hard-coded to ITEM by the view filter.
• INVENTORY_ITEM_ID and MASTER_ORGANIZATION_ID – The item and its master organization, forming the correlation to CSI_ITEM_INSTANCES.
• ITEM_CATEGORY_ID and INSTANCE_ID – Category and instance context carried from the attribute record.
• ATTRIBUTE_CODE, ATTRIBUTE_NAME, ATTRIBUTE_CATEGORY, DESCRIPTION – Identification and descriptive metadata for the attribute.
• ACTIVE_START_DATE / ACTIVE_END_DATE – Effective dating of the attribute definition.
• CONTEXT and ATTRIBUTE1 through ATTRIBUTE15 – The descriptive flexfield context and segment values.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER – Standard WHO audit and optimistic locking columns.
• SRC_INSTANCE_ID – The source instance identifier from CSI_ITEM_INSTANCES, distinguishing it from the attribute's own INSTANCE_ID.

Common Use Cases and Queries

Because the view is internal, it is most commonly consumed indirectly through CSI_INST_EXT_ATTR_ALL_V. Nonetheless, it is useful for diagnostics, reconciliation, and extension development where item-level attribute context must be isolated. A typical query returning active item-level attributes for a given item is:

• SELECT attribute_code, attribute_name, attribute1, attribute2, src_instance_id FROM csi_inst_item_ext_attr_v WHERE inventory_item_id = :item_id AND master_organization_id = :org_id AND (active_end_date IS NULL OR active_end_date > SYSDATE);
• SELECT attribute_category, COUNT(*) FROM csi_inst_item_ext_attr_v GROUP BY attribute_category ORDER BY 2 DESC;

Join this view back to CSI_ITEM_INSTANCES on SRC_INSTANCE_ID when both instance and item-level attribute context are required in a single report.