Results for “cost_group”

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

Overview

The view APPS.CST_XLA_COST_GROUPS_REF_V is a reference view published in the Oracle E-Business Suite environment under the Bills of Material (BOM) product family, which encompasses the Cost Management (CST) schema objects. Its purpose is to expose cost group reference data in a simplified, denormalized form suitable for consumption by Oracle Subledger Accounting (XLA) and other downstream reporting or integration components. The XLA token embedded in the view name indicates that the object is part of the Subledger Accounting reference data layer used to populate accounting attributes and lookup values.

Within Oracle EBS 12.1.1 and 12.2.2, cost groups are logical partitions of inventory organizations that allow organizations sharing a common cost structure to maintain costing data independently. The view provides a lightweight, read-only projection of this configuration, allowing consumers to resolve cost group identifiers and names without joining to the full base table directly.

Underlying Base Objects

The view is defined over a single base object, CST_COST_GROUPS, which is exposed to the APPS schema through a synonym. The documented view text is:

• SELECT COST_GROUP_ID, ORGANIZATION_ID, COST_GROUP FROM CST_COST_GROUPS

Because the definition is a direct, unfiltered projection of the base table, the view carries no additional predicates, aggregation, or transformation logic. It does not join to HR_OPERATING_UNITS, ORG_ORGANIZATION_DEFINITIONS, or any other descriptive table. As a result, the view is a thin wrapper whose primary value is providing a stable, publicly documented interface while insulating callers from direct dependencies on CST_COST_GROUPS. Note that the ETRM column listing contains the name COST_GROUP_ORGANIZATION_ID, which corresponds to the selected ORGANIZATION_ID column; the underlying base column name is ORGANIZATION_ID.

Key Columns

• COST_GROUP_ID — The unique surrogate primary key identifying a cost group record. It is the value typically stored as a foreign key on costing and inventory transaction tables and is the preferred join key for reference data resolution.
• COST_GROUP_ORGANIZATION_ID (base column ORGANIZATION_ID) — The inventory organization to which the cost group belongs. A cost group is defined within the context of an organization, and this column establishes that owning entity. It joins to ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_ID.
• COST_GROUP — The descriptive name or code assigned to the cost group. It is the human-readable label used in reports, user interfaces, and accounting reference displays.

Common Use Cases and Queries

Typical usage involves resolving cost group identifiers to names for reporting or integrating cost group configuration into external systems. A standard query listing all cost groups with their owning organization is:

• SELECT cost_group_id, cost_group_organization_id, cost_group FROM cst_xla_cost_groups_ref_v ORDER BY cost_group_organization_id, cost_group;

To retrieve the cost group for a single organization, filter on the organization column:

• SELECT cost_group_id, cost_group FROM cst_xla_cost_groups_ref_v WHERE cost_group_organization_id = :org_id;

For reporting enriched with organization names, join to the organization definition view:

• SELECT v.cost_group, o.name organization_name FROM cst_xla_cost_groups_ref_v v, org_organization_definitions o WHERE v.cost_group_organization_id = o.organization_id;

These queries support subledger reconciliation, cost accounting analysis, and cross-system integration where cost group assignments must be validated or translated.