Results for “csi_ctr_item_associations_bc_v”

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

Overview

The CSI_CTR_ITEM_ASSOCIATIONS_BC_V view is a backward-compatibility object in the Oracle E-Business Suite (EBS) Install Base (CSI) module, owned by the APPS schema. Its stated purpose in the ETRM repository is to provide a backward-compatible interface for the older CS_CTR_ASSOCIATIONS structure, insulating custom reports, Concurrent Programs, and integrations from changes in the underlying counter-group data model that were introduced in later releases. In EBS 12.1.1 and 12.2.2, the view is registered as VALID and is available for querying in the APPS schema. It presents the association between an inventory item and a counter group, normalized into a uniform column layout (CTR_ASSOCIATION_ID, COUNTER_GROUP_ID, SOURCE_OBJECT_ID) so that legacy extract logic continues to function without modification.

Underlying Base Objects

The view is defined over CSI_CTR_ITEM_ASSOCIATIONS (referenced in ETRM as a synonym), together with CSI_COUNTER_TEMPLATE_VL. Because the definition uses a UNION ALL, records are sourced from two branches:

• The first branch selects rows where ASSOCIATED_TO_GROUP = 'Y', exposing GROUP_ID directly as COUNTER_GROUP_ID.
• The second branch handles rows where ASSOCIATED_TO_GROUP = 'N', joining CSI_CTR_ITEM_ASSOCIATIONS to CSI_COUNTER_TEMPLATE_VL on COUNTER_ID and substituting CCT.DEFAULTED_GROUP_ID as COUNTER_GROUP_ID.

This duality reconciles two historical ways of associating an item with a counter group — direct group association and association via a counter template — into a single consistent resultset.

Key Columns

• CTR_ASSOCIATION_ID — Primary identifier of the association record, propagated from CSI_CTR_ITEM_ASSOCIATIONS.
• COUNTER_GROUP_ID — The resolved counter group, derived from GROUP_ID or from the template's DEFAULTED_GROUP_ID.
• SOURCE_OBJECT_ID — The source object, mapped from INVENTORY_ITEM_ID; identifies the inventory item in the association.
• OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — Standard EBS WHO columns supporting auditing and concurrency control.
• ATTRIBUTE1..15 and CONTEXT — Descriptive Flexfield segments, with ATTRIBUTE_CATEGORY renamed to CONTEXT.
• SECURITY_GROUP_ID — Multi-org security context, carried through from the base table.

Common Use Cases and Queries

Typical uses include Install Base reporting, migration validation, and integration extracts where legacy CS_CTR_ASSOCIATIONS shape is expected. A representative query lists all item-to-counter-group associations:

SELECT ctr_association_id, counter_group_id, source_object_id
FROM apps.csi_ctr_item_associations_bc_v;

Filtering by a specific item or group supports item-level analysis:

SELECT counter_group_id, source_object_id, creation_date
FROM apps.csi_ctr_item_associations_bc_v
WHERE source_object_id = :item_id;

Because the view performs an internal UNION ALL involving a VL table, joins against it should be minimized and filtered aggressively; DBAs should also note that the synonym resolution and template join may affect performance on large Install Base datasets, making targeted indexes on INVENTORY_ITEM_ID and GROUP_ID advisable.