Results for “cs_ctr_formula_bvars_v”

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

Overview

The view CS_CTR_FORMULA_BVARS_V belongs to the Oracle E-Business Suite Service (CS) module and is documented as the "Counter formula reference variable's view." It exposes the bind variables that a counter formula references, resolving those bind variables into human-readable counter, counter group, and inventory item names. In the Oracle ETRM 12.2.2 metadata, the object is annotated as "Not implemented in this database," indicating that the view is defined within the application dictionary but may be absent or non-functional in a given environment until the corresponding Service/TeleService product schema is deployed.

This view is primarily an inquiry and reporting construct. Rather than storing transactional formulas, it presents the formula-to-bind-variable relationship in denormalized form, joining the underlying bind variable table to the counters, counter groups, and inventory items that the variables map to. It also exposes the READING_TYPE attribute, which is relevant to users searching on that term: reading type distinguishes the measurement nature of the associated counter (for example, the type of reading captured by a meter or counter).

Underlying Base Objects

The documented view text shows that CS_CTR_FORMULA_BVARS_V is defined over four sources:

• CS_CTR_FORMULA_BVARS (aliased A) — the primary base table holding the counter formula bind variable records, including CTR_FORMULA_BVAR_ID, BIND_VAR_NAME, MAPPED_COUNTER_ID, MAPPED_INV_ITEM_ID, and READING_TYPE.
• CS_COUNTERS (aliased B) — provides the mapped counter's NAME and its parent COUNTER_GROUP_ID, joined on B.COUNTER_ID = A.MAPPED_COUNTER_ID.
• CS_COUNTER_GROUPS (aliased C) — supplies the counter group name, joined on C.COUNTER_GROUP_ID = B.COUNTER_GROUP_ID.
• MTL_SYSTEM_ITEMS_KFV (aliased E) — an outer-joined key flexfield view supplying the concatenated inventory item segment, joined on E.INVENTORY_ITEM_ID(+) = A.MAPPED_INV_ITEM_ID and E.ORGANIZATION_ID(+) = CS_STD.GET_ITEM_VALDN_ORGZN_ID.

The outer join on the item flexfield view means rows are retained even when no inventory item is mapped. The organization filter uses the standard helper function CS_STD.GET_ITEM_VALDN_ORGZN_ID.

Key Columns

• CTR_FORMULA_BVAR_ID — primary identifier for the bind variable record.
• BIND_VAR_NAME — the variable name referenced within the counter formula.
• COUNTER_ID — the counter that owns the formula bind variable.
• MAPPED_INV_ITEM_ID / MAPPED_INV_ITEM_NAME — the mapped inventory item identifier and its concatenated flexfield name.
• MAPPED_COUNTER_ID / MAPPED_COUNTER_NAME — the counter to which the variable is bound and its descriptive name.
• MAPPED_COUNTER_GROUP_ID / MAPPED_COUNTER_GROUP_NAME — the parent counter group and its name.
• READING_TYPE — the reading type associated with the bind variable mapping.
• Standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), plus OBJECT_VERSION_NUMBER and CONTEXT.
• Descriptive flexfield columns ATTRIBUTE1 through ATTRIBUTE15.

Common Use Cases and Queries

Typical uses include auditing counter formula definitions, verifying variable-to-counter mappings, and filtering by reading type. A representative query retrieving variable mappings for a given counter is:

SELECT bind_var_name, mapped_counter_name, mapped_counter_group_name, mapped_inv_item_name, reading_type FROM cs_ctr_formula_bvars_v WHERE counter_id = :p_counter_id;

To isolate mappings by reading type, a user searching on "reading_type" might run:

SELECT ctr_formula_bvar_id, bind_var_name, mapped_counter_name, reading_type FROM cs_ctr_formula_bvars_v WHERE reading_type = :p_reading_type ORDER BY bind_var_name;

Because the view already resolves names and joins the item flexfield, it reduces the need for custom joins across CS_COUNTERS, CS_COUNTER_GROUPS, and MTL_SYSTEM_ITEMS_KFV, making it suitable for concurrent programs, Oracle Reports, and OAF-based inquiry pages.