Results for “csi_ctr_item_associations_v”

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

Overview

CSI_CTR_ITEM_ASSOCIATIONS_V is an APPS-owned reporting view within the Oracle E-Business Suite Install Base (CSI) product. It exposes the counter item association data maintained in the base table CSI_CTR_ITEM_ASSOCIATIONS, joined to the concatenated item key flexfield view MTL_SYSTEM_ITEMS_KFV so that the resulting rows carry human-readable item names and descriptions. In EBS 12.1.1 and 12.2.2 the object is registered as a VALID view under the APPS schema and is a standard component of the Install Base data model used by counters and meter-based service contracts.

The view is primarily a query and integration surface. Because it denormalizes the item identifier into the concatenated segments and item description, it removes the need for external reports, BI Publisher datasets, and outbound interfaces to re-resolve the inventory item each time a counter reading is processed. The presence of the USE_PAST_READING column makes the view particularly relevant when implementing counter-reading validation rules that must determine whether a prior reading should be reused rather than a new value captured.

Underlying Base Objects

The documented view definition references three objects:

• CSI_CTR_ITEM_ASSOCIATIONS (SYNONYM) — the driving table, aliased CCI, which stores the association of a counter to an inventory item, along with usage rate, past-reading behavior, and effective dates.
• MTL_SYSTEM_ITEMS_KFV (SYNONYM) — the concatenated item flexfield view, aliased MSI, joined with an outer join on INVENTORY_ITEM_ID and on ORGANIZATION_ID set to FND_PROFILE.VALUE('CS_INV_VALIDATION_ORG').
• FND_PROFILE (PACKAGE) — invoked only to resolve the CS_INV_VALIDATION_ORG profile option value used to constrain the item join to the Install Base validation organization.

Because the item join is an outer join, counter item associations are returned even when the referenced item is not defined in the validation organization; in that case ITEM_NAME and ITEM_DESCRIPTION return null. The profile option dependency means the view is organization-context sensitive and can return different item descriptions if CS_INV_VALIDATION_ORG is changed.

Key Columns

• CTR_ASSOCIATION_ID — primary identifier of the counter-to-item association record.
• GROUP_ID and ASSOCIATED_TO_GROUP — identify the counter group and whether the association applies at group level.
• INVENTORY_ITEM_ID — foreign key to the inventory item; resolved into ITEM_NAME (concatenated segments) and ITEM_DESCRIPTION.
• COUNTER_ID — the counter to which the item is associated.
• USAGE_RATE — the consumption rate applied when the counter advances.
• USE_PAST_READING — flag controlling whether the previous reading is reused when a new reading is not supplied, central to counter-reading validation logic.
• START_DATE_ACTIVE / END_DATE_ACTIVE — effective dating of the association.
• SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Multi-Org and audit columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — descriptive flexfield columns.
• MIGRATED_FLAG — indicates records migrated into the current data model.

Common Use Cases and Queries

Typical scenarios include auditing which items are associated with a counter, verifying the USE_PAST_READING setting before validating a reading, and building an item-level extract for integrations. A basic query is:

• SELECT ctr_association_id, counter_id, group_id, inventory_item_id, item_name, usage_rate, use_past_reading FROM csi_ctr_item_associations_v WHERE use_past_reading = 'Y';
• SELECT counter_id, item_name, item_description, start_date_active, end_date_active FROM csi_ctr_item_associations_v WHERE counter_id = :counter_id AND TRUNC(SYSDATE) BETWEEN start_date_active AND NVL(end_date_active, TRUNC(SYSDATE) + 1);
• SELECT inventory_item_id, item_name, COUNT(*) FROM csi_ctr_item_associations_v GROUP BY inventory_item_id, item_name ORDER BY 3 DESC;

These queries illustrate the view's principal value: direct, item-resolved access to counter association configuration, including the USE_PAST_READING attribute, without joining to Install Base base tables or the item flexfield manually.