Search Results usage_item_name




Overview
Explore in AI Chat

Overview

CS_COUNTERS_QF_V is a Service (CS) module view in Oracle E-Business Suite 12.1.1 and 12.2.2 that supports the Find window of the Counter Setup form. It is a "quick find" (QF) style view whose purpose is to present counter configuration data in a denormalized, human-readable form so that users can search, identify, and select counters from the Counter Setup interface without navigating to the underlying transactional tables. The view flattens the relationships among counter groups, individual counters, counter properties, item associations, and derived-counter definitions into a single rectangular result set, exposing both numeric IDs and descriptive names side by side. Because it joins to Key Flexfield (KFF) views for inventory items, it also resolves item identifiers into concatenated segment values, which is essential for presenting recognizable item numbers in the form's search results. Note that the ETRM metadata records this object as "Not implemented in this database" in the source environment, meaning the view exists in the application data model definition but may not have been deployed in the captured instance; the view text and column list are nevertheless documented and authoritative.

Underlying Base Objects

The view is defined over several Service and Inventory tables. The primary drivers are CS_COUNTERS (aliased CTR for the base counter and DCTR for the counter referenced by DERIVE_COUNTER_ID), CS_COUNTER_GROUPS (CGR), CS_COUNTER_PROPERTIES (CPROP for the counter's own property and DPROP for the source property of a derived property), and CS_CTR_ASSOCIATIONS (CASS), which links counter groups to associated items. Two instances of MTL_SYSTEM_ITEMS_KFV (USITM and ASITM) resolve usage items and associated items into concatenated flexfield segments. The joins are predominantly outer joins, with the (+) operator applied to CPROP, CGR, CASS, DCTR, DPROP, USITM, and ASITM, so counters and groups are retained even when properties, associations, or derived definitions are absent. Both item KFF joins are further constrained by ORGANIZATION_ID equal to CS_STD.GET_ITEM_VALDN_ORGZN_ID, the standard Service API that returns the item validation organization. The ETRM metadata documents no referenced base objects explicitly, but the view text provides the complete join topology.

Key Columns

Common Use Cases and Queries

Typical use is to populate the Counter Setup Find window and to report on derived counter relationships, where DERIVE_COUNTER_ID links a counter to the counter supplying its source value.

  • Locate counters that derive from another counter:
    SELECT counter_id, counter_name, derive_counter_id, derived_counter_name FROM cs_counters_qf_v WHERE derive_counter_id IS NOT NULL;
  • List counters for a group with their associated and usage items:
    SELECT counter_group_name, counter_name, associated_item_name, usage_item_name FROM cs_counters_qf_v WHERE counter_group_id = :group_id;
  • Trace property derivation chains:
    SELECT counter_name, counter_property_name, derived_counter_prop_name FROM cs_counters_qf_v WHERE derive_property_id IS NOT NULL;

Because the view is intended for display and quick find, it is best used for read-only lookup and reporting rather than as a high-volume transactional source.