Search Results jtf_terr_values




Overview
Explore in AI Chat

Overview

JTF_TERR_VALUES is a CRM Foundation (JTF) database view within Oracle E-Business Suite 12.1.1 and 12.2.2. Its metadata explicitly states that it is defined "Same as JTF_TERR_VALUES_ALL." In the Oracle EBS multi-org architecture, the _ALL suffixed table stores records across all operating units, while the unsuffixed view (or synonym) is typically filtered by the current organization context (ORG_ID) via a row-level security (RLS) policy or a secured synonym. This view therefore exposes only the territory qualification value rows visible to the session's active organization.

The object stores the discrete value constraints and comparison parameters that define how a territory qualification rule matches source records. Each row represents a value set entry attached to a territory qualifier (TERR_QUAL_ID), describing the comparison operator, the inclusion flag, and the low/high boundaries for character, numeric, ID-based, or currency comparisons. For reporting, integration, and diagnostics, JTF_TERR_VALUES is the primary access point for extracting territory qualification logic without exposing cross-organization data.

Underlying Base Objects

The documented view text confirms that JTF_TERR_VALUES is a straightforward SELECT projection over JTF_TERR_VALUES_ALL, with no joins, views, or additional base objects referenced in the definition. All 26 columns are passed through unchanged:

  • Source object: JTF_TERR_VALUES_ALL
  • Definition type: single-table projection (no filters in the documented text)
  • Org filtering: applied externally through the standard EBS secured view convention, not in the documented view text
  • ETRM 12.2.2 metadata records no separately documented base tables beyond the _ALL object

Because the definition is a pure projection, any query performance or column semantics derive directly from JTF_TERR_VALUES_ALL.

Key Columns

Common Use Cases and Queries

Typical scenarios include diagnosing why a territory assignment did not match an expected record, listing the value sets used by a territory, auditing qualification boundaries, and extracting qualification logic for integration into external CRM or analytics platforms.

List all value rows for a qualifier:

SELECT terr_value_id, terr_qual_id, comparison_operator,
       include_flag, value_set, low_value_char, high_value_char
FROM   jtf_terr_values
WHERE  terr_qual_id = :p_qual_id;

Find qualifications referencing a specific value set:

SELECT terr_qual_id, terr_value_id, value_set,
       comparison_operator, low_value_char, high_value_char
FROM   jtf_terr_values
WHERE  value_set = :p_value_set
ORDER  BY terr_qual_id;

Inspect numeric and currency boundaries:

SELECT terr_value_id, terr_qual_id, currency_code,
       low_value_number, high_value_number, id_used_flag
FROM   jtf_terr_values
WHERE  currency_code IS NOT NULL;

Join to the qualifier parent to report value sets by territory. Queries against this view inherit the secured organization context, so results reflect only the active operating unit unless the caller queries JTF_TERR_VALUES_ALL directly under appropriate privileges.