Search Results logical_operator




Overview
Explore in AI Chat

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

Overview

OKC_CNL_GENERAL_EXPR_V is an Oracle E-Business Suite 12.1.1 / 12.2.2 reporting view owned by the APPS schema and defined within the OKC – Contracts Core product. It exposes the general expression lines of the contract conditions model, specifically the rows stored in OKC_CONDITION_LINES_B where CNL_TYPE equals 'GEX'. The view is documented in ETRM as a "View for table OKC_EVENT_DEF_LINES_B," reflecting that the general expression lines it surfaces are referenced by event definition logic for contract condition evaluation.

The view is a Joined view rather than a simple column projection: it combines the base condition-lines table with its translation table so that the end-user-facing description is returned in the session language. In effect, it presents a flattened, language-resolved representation of general expression rules — including operators, operands, sequencing, and parentheses — suitable for query, reporting, and integration without requiring callers to join the TL table themselves. Status is VALID.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, OKC_CNL_GENERAL_EXPR_V is defined over two referenced base objects, both exposed as synonyms:

  • OKC_CONDITION_LINES_B — aliased CNLB in the view text. Holds the general expression header/lines record, including operators, operands, sequencing, descriptive flexfield attributes, and standard WHO audit columns.
  • OKC_CONDITION_LINES_TL — aliased CNLT in the view text. Holds the translatable description of the condition line, joined on ID with LANGUAGE = USERENV('LANG').

The join condition is CNLB.ID = CNLT.ID AND CNLT.LANGUAGE = USERENV('LANG'), filtered by CNLB.CNL_TYPE = 'GEX'. The view also exposes the ROWID of the base B table row as ROW_ID for row-level addressing.

Key Columns

Common Use Cases and Queries

Typical uses include auditing how contract condition expressions are composed, reporting the relational and logical operators that drive rule evaluation, and feeding expression lines into integration or BI extracts. A representative query filtering the operators is:

SELECT row_id, id, cnh_id, sortseq,
       left_parenthesis, left_operand,
       relational_operator, right_operand,
       right_parenthesis, logical_operator, description
  FROM apps.okc_cnl_general_expr_v
 WHERE cnh_id = :p_condition_header_id
 ORDER BY sortseq;

To inspect only expression lines that use a specific relational operator:

SELECT id, cnh_id, relational_operator, logical_operator, description
  FROM apps.okc_cnl_general_expr_v
 WHERE relational_operator = :p_relational_operator;

Because the view already joins the TL table, description values are returned in the session language, which simplifies multilingual reporting. Callers should remember the fixed filter CNL_TYPE = 'GEX' is embedded in the view, so only general expression lines are returned.