Search Results jtf_seeded_qual




Overview
Explore in AI Chat

Overview

APPS.JTF_TERR_QUALIFIERS_V is a reporting view in the Oracle E-Business Suite Territory Management (also branded as Oracle Trade Management / ETRM) module. It presents the qualifier configuration that is attached to territories, resolving the numeric foreign-key relationships held in the transactional territory-qualifier table into business-readable descriptions. The view joins the territory qualifier assignment (JTF_TERR_QUAL) to the qualifier usage definitions (JTF_QUAL_USGS), the seeded qualifier registry (JTF_SEEDED_QUAL), the qualifier type usages (JTF_QUAL_TYPE_USGS) and the qualifier types (JTF_QUAL_TYPES). Because it exposes names, display types, LOV SQL fragments and formatting metadata rather than raw IDs, it is the standard surface for reporting, diagnostics and integration extracts that must describe what a territory is qualified by rather than merely which usage row is referenced.

The view is defined as a UNION ALL of two branches. The first branch selects rows where QUALIFIER_MODE IS NULL, treating them as the unqualified (default) case; the second branch carries rows with a non-null qualifier mode. Both branches return the identical column list so the union remains type-consistent. The owner is APPS and the view is subject to standard multi-org security through the ORG_ID column.

Underlying Base Objects

Joins are driven on QUAL_USG_ID, SEEDED_QUAL_ID and QUAL_TYPE_USG_ID / QUAL_TYPE_ID respectively, producing one row per territory-qualifier usage assignment.

Key Columns

Common Use Cases and Queries

The view supports territory setup verification, migration comparisons between 12.1.1 and 12.2.2, and extracts feeding downstream analytics. A typical listing joins it to the territory name for readability:

  • List all qualifiers for a territory: SELECT qualifier_name, qualifier_type_name, qualifier_mode, overlap_allowed_flag FROM jtf_terr_qualifiers_v WHERE terr_id = :p_terr_id;
  • Find territories using a specific seeded qualifier: SELECT terr_id, qualifier_name FROM jtf_terr_qualifiers_v WHERE qualifier_name = :p_name;
  • Audit LOV configuration: SELECT qualifier_name, display_type, column_count, enable_lov_validation FROM jtf_terr_qualifiers_v ORDER BY qualifier_name;
  • Multi-org scoped report: SELECT org_id, qualifier_name, use_to_name_flag FROM jtf_terr_qualifiers_v WHERE org_id = :p_org_id;

Because QUALIFIER_MODE_DESC is not populated by the view text, reports requiring a decoded mode should join to the appropriate lookup or apply a local decode.