Search Results prod_item

Overview

The view APPS.CSI_COUNTER_GROUPS_BC_V is a Business Components (BC) style entity view in the Oracle E-Business Suite (EBS) Service (CSI/CS) module, exposing counter group definitions used throughout the Service Contracts and Installed Base (CSI) architecture. It is owned by the APPS schema and is defined over the counter groups table CS_CSI_COUNTER_GROUPS (accessed through a synonym). The suffix _BC_V indicates the view serves the TCA/Business Components programming model, and it is typically consumed by Service Contracts, Installed Base, and counter-reading functionality. Its principal role is to present a unified, flattened representation of counter group headers, including their association type, template status, descriptive flexfield (DFF) attributes, and security/audit columns, so that Oracle Forms, OAF pages, and integration programs can query a single consistent source without joining directly to the base table.

Because counter groups drive the reading and tracking of meter counters (for example, on customer products and service contracts), this view is a common read point for the "svc_item" search context, since the view maps the internal ASSOCIATION_TYPE value 'CONTRACT' to the presentation value 'SVC_ITEM'.

Underlying Base Objects

Per the ETRM metadata, the view references a single documented base object: CS_CSI_COUNTER_GROUPS, presented to the APPS schema via a synonym. The view text is a UNION ALL of two branches over the same underlying table. The first branch returns rows where ccg.template_flag = 'Y' (counter group templates) and hard-codes SOURCE_OBJECT_CODE and SOURCE_OBJECT_ID to NULL. The second branch returns the remaining, non-template counter group records. Both branches project the same ordered list of columns, ensuring a stable union structure. No external joins are documented; all enrichment, including the transformation of ASSOCIATION_TYPE, is performed with an inline DECODE.

Key Columns

• COUNTER_GROUP_ID — Primary identifier of the counter group.
• NAME, DESCRIPTION — Descriptive identity of the counter group.
• TEMPLATE_FLAG — Indicates whether the row is a reusable counter group template ('Y') or an instantiated group.
• ASSOCIATION_TYPE — Derived column. The DECODE maps 'TRACKABLE' to 'PROD_ITEM' and 'CONTRACT' to 'SVC_ITEM', otherwise NULL. This aligns the underlying storage vocabulary with the Business Components presentation vocabulary used by service items.
• SOURCE_OBJECT_CODE, SOURCE_OBJECT_ID — Returned as NULL placeholders for the template branch in this projection.
• SOURCE_COUNTER_GROUP_ID — References the source counter group, supporting template-to-instance lineage.
• CREATED_FROM_CTR_GRP_TMPL_ID — Identifies the template from which the group was instantiated.
• START_DATE_ACTIVE, END_DATE_ACTIVE — Effective dating for the counter group.
• ATTRIBUTE1…ATTRIBUTE15, CONTEXT — Descriptive flexfield columns.
• SECURITY_GROUP_ID — Multi-organization/security context.
• OBJECT_VERSION_NUMBER, plus the standard CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN audit columns.

Common Use Cases and Queries

Typical scenarios include listing all counter groups available for a service item association, or validating which templates exist before instantiating a group for an installed base instance counter.

List counter groups associated with service items:

• SELECT counter_group_id, name, description FROM apps.csi_counter_groups_bc_v WHERE association_type = 'SVC_ITEM';

Retrieve only active, non-template counter groups:

• SELECT counter_group_id, name, start_date_active, end_date_active FROM apps.csi_counter_groups_bc_v WHERE template_flag = 'N' AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);

Trace an instantiated group back to its template:

• SELECT counter_group_id, name, created_from_ctr_grp_tmpl_id FROM apps.csi_counter_groups_bc_v WHERE created_from_ctr_grp_tmpl_id IS NOT NULL;

These queries reflect the documented column set and the DECODE-derived ASSOCIATION_TYPE semantics, making the view a reliable interface for counter group reporting and integration in EBS 12.1.1 and 12.2.2.