Search Results okx_counter_groups_v




Overview
Explore in AI Chat

Overview

The OKX_COUNTER_GROUPS_V view is an APPS-owned database object within the Oracle E-Business Suite OKX – Contracts Integration product. It exposes counter group definitions, which represent logical groupings of business entities (such as customers, suppliers, or trading partners) used by the Contracts Integration module to drive contract generation, pricing, and fulfillment logic. The view consolidates three related concepts documented in its description: counter groups, counter group instances, and counter group templates. The TEMPLATE_FLAG column is the key discriminator among these, allowing a single query to distinguish reusable templates from concrete, operational counter group instances. Because the view resides in the APPS schema and is marked VALID in ETRM 12.2.2 (and is compatible with the 12.1.1 code line), it is a stable, supported read-only interface suitable for reporting, extracts, and downstream integrations without requiring direct access to the base table.

Underlying Base Objects

The view is defined over a single documented base object: CS_COUNTER_GROUPS, which is exposed as a SYNONYM within the environment. The defining query selects directly from this table (aliased CG), projecting the columns listed in the ETRM metadata. No joins or aggregations are performed, so the view is effectively a controlled, denormalized projection of CS_COUNTER_GROUPS. This design provides a curated column set for integration consumers while insulating them from physical table changes. Key relationships implied by the columns include self-referencing links via SOURCE_COUNTER_GROUP_ID (an instance derived from a source group) and CREATED_FROM_CTR_GRP_TMPL_ID (a group instantiated from a template).

Key Columns

  • COUNTER_GROUP_ID – Surrogate primary identifier for the counter group.
  • NAME – Descriptive name of the group or template.
  • DESCRIPTION – Free-text detail describing the group's purpose.
  • TEMPLATE_FLAG – Indicator distinguishing a reusable template from an active counter group instance.
  • START_DATE_ACTIVE / END_DATE_ACTIVE – Effective-dating window controlling when the group is active.
  • ASSOCIATION_TYPE – Classifies how the group is associated with its source entity.
  • SOURCE_OBJECT_CODE / SOURCE_OBJECT_ID – Reference to the originating business object that the group is associated with.
  • CREATED_FROM_CTR_GRP_TMPL_ID – Points to the template from which the group was created, where applicable.
  • SOURCE_COUNTER_GROUP_ID – Self-referencing link to a parent or originating counter group.

Common Use Cases and Queries

Typical uses include identifying all live counter groups versus templates, tracing template-to-instance lineage, and reporting on effective-dated group membership for integration audits.

List operational (non-template) groups:

SELECT counter_group_id, name, start_date_active, end_date_active
FROM apps.okx_counter_groups_v
WHERE template_flag = 'N';

List available templates:

SELECT counter_group_id, name, description
FROM apps.okx_counter_groups_v
WHERE template_flag = 'Y';

Trace groups instantiated from a template:

SELECT name, created_from_ctr_grp_tmpl_id, source_counter_group_id
FROM apps.okx_counter_groups_v
WHERE created_from_ctr_grp_tmpl_id IS NOT NULL;

Filter by active window:

SELECT counter_group_id, name
FROM apps.okx_counter_groups_v
WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);