Search Results right_value

Overview

CS_COUNTER_DER_FILTERS_V is a Service (CS) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented title, "Derive counter filters view," describes its purpose: it exposes the filter conditions used by Oracle's counter and meter derivation engine to evaluate whether a counter reading should be derived from a source reading. Counters in Service and Enterprise Asset Management are frequently not entered directly but computed from other meters according to user-defined formulas and conditional expressions; CS_COUNTER_DER_FILTERS_V surfaces those conditions in a query-friendly form. Because the view joins the filter definition to the counter property name, it presents readable filter rows rather than opaque foreign keys, making it suitable for reporting, diagnostics, and integration extracts. The object is documented as VALID in the ETRM repository, and the underlying view text references the base objects CS_COUNTER_DER_FILTERS and CS_COUNTER_PROPERTIES.

Underlying Base Objects

The view is defined as an outer join between two base objects in the APPS schema:

• CS_COUNTER_DER_FILTERS (aliased A) — the driving table, holding one row per filter condition belonging to a counter derivation. This is the primary base object for the view.
• CS_COUNTER_PROPERTIES (aliased B) — the property definition table, joined as A.COUNTER_PROPERTY_ID = B.COUNTER_PROPERTY_ID(+). The outer join operator ensures that filter rows survive even when no matching property definition exists, which protects the derivation definition from being silently dropped by an orphaned or disabled property.

All columns from the filter table are projected, with B.NAME from the property table surfaced through the view column PROPERTY_NAME. The view also exposes the filter table's ROWID as ROW_ID, its descriptive flexfield columns ATTRIBUTE1 through ATTRIBUTE15 and CONTEXT, and the OBJECT_VERSION_NUMBER used for optimistic locking in the 12.2.2 Online Patching and editioning model.

Key Columns

• COUNTER_DER_FILTER_ID — primary identifier of the filter condition row.
• COUNTER_ID — the counter or meter to which the derivation filter applies.
• SEQ_NO — ordering sequence for evaluating conditions within a derivation.
• LEFT_PAREN / RIGHT_PAREN — literal parenthesis markers that let the stored expression reproduce the exact grouping intended by the user.
• COUNTER_PROPERTY_ID / PROPERTY_NAME — the counter property tested by the condition, with NAME resolved through the outer join to CS_COUNTER_PROPERTIES.
• RELATIONAL_OPERATOR — the comparison operator (for example =, <, >, BETWEEN) applied to the operands, separated here as an orthogonal column rather than embedded in free text.
• RIGHT_VALUE — the value against which the property is compared. This is the column most commonly searched for when auditing which derivations reference a particular threshold or literal, and it is the object of the query right_value.
• LOGICAL_OPERATOR — the connector (AND, OR) that chains the row's condition to the following row in sequence.
• WHO columns and ATTRIBUTE1–15, CONTEXT, OBJECT_VERSION_NUMBER — standard audit, descriptive flexfield, and concurrency columns.

Common Use Cases and Queries

The view is typically used to audit or reuse counter derivation logic — for instance, to find every derivation whose condition compares against a given literal, or to reconstruct a filter expression as readable text by ordering rows on SEQ_NO and concatenating the parenthesis, property, relational operator, right value, and logical operator columns.

Sample query listing filters for a specific counter, including the resolved property name:

• SELECT counter_der_filter_id, seq_no, left_paren, property_name, relational_operator, right_value, right_paren, logical_operator FROM cs_counter_der_filters_v WHERE counter_id = :counter_id ORDER BY seq_no;

Sample query locating every derivation that references a specific threshold in RIGHT_VALUE:

• SELECT counter_id, seq_no, property_name, relational_operator, right_value FROM cs_counter_der_filters_v WHERE right_value = :value ORDER BY counter_id, seq_no;

Because the view is read-only and defined over the base filter table, it can be queried directly in reports, ad hoc SQL, and integration extracts without write access to the underlying derivation definitions.