Results for “num_qual”

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

Overview

JTF_TERR_WINNERS_V is a read-only database view owned by the APPS schema in Oracle E-Business Suite releases 12.1.1 and 12.2.2. It is shipped as part of the JTF – CRM Foundation product family, which supplies the shared infrastructure for Oracle's CRM applications, including territory management, resource management, and assignment rules. The view exposes a filtered and ranked subset of territory assignment results, specifically those denormalized rule rows in which a territory is related to itself. In practical terms, JTF_TERR_WINNERS_V presents the "winning" territory assignments together with their absolute rank, qualification counts, top-level territory identifiers, qualification type, and source identifiers.

Because the view is defined with an embedded ORDER BY clause (ABSOLUTE_RANK DESC), it delivers rows in rank order without requiring the caller to sort explicitly. This makes it convenient for consumers that must resolve the highest-ranked qualifying territory for a given source record. The view carries a VALID status in the ETRM data dictionary and is treated as a documented, supported object for reporting and integration purposes.

Underlying Base Objects

The view is defined over a single documented base object: JTF_TERR_DENORM_RULES, which is itself a view in the APPS schema. JTF_TERR_DENORM_RULES stores denormalized territory rule information used by the ETRM (Enterprise Territory Management) engine. The WHERE clause JTDR.RELATED_TERR_ID = JTDR.TERR_ID restricts the result set to rows where the related territory equals the territory itself, effectively isolating the self-referential records that represent winning or terminal territory assignments rather than intermediate relationship mappings.

Key Columns

• ABSOLUTE_RANK — The absolute ranking position of the territory assignment. The view's ORDER BY clause sorts descending on this column, so the highest rank appears first.
• TERR_ID — Identifier of the territory associated with the winning rule row.
• NUM_QUAL — Number of qualifiers attached to the territory rule; indicates the volume of qualification criteria applied.
• TOP_LEVEL_TERR_ID — Identifier of the top-level (parent) territory in the territory hierarchy, useful for aggregation and roll-up reporting.
• QUAL_TYPE_ID — Identifier of the qualification type, indicating the category of qualification criteria used to score the territory.
• SOURCE_ID — Identifier of the source record (for example, a lead, opportunity, or customer) against which the territory qualification was evaluated.

Common Use Cases and Queries

This view is typically used to audit territory assignment outcomes, to identify the top-ranked territory for a given source, and to reconcile denormalized territory rule data with the underlying ETRM structures. A straightforward query retrieves all winning rows in rank order:

• SELECT absolute_rank, terr_id, num_qual, top_level_terr_id, qual_type_id, source_id FROM jtf_terr_winners_v;
• SELECT * FROM jtf_terr_winners_v WHERE source_id = :p_source_id ORDER BY absolute_rank DESC; — returns ranked winning territories for a specific source record.
• SELECT top_level_terr_id, COUNT(*) FROM jtf_terr_winners_v GROUP BY top_level_terr_id; — counts winning assignments grouped by top-level territory.
• SELECT DISTINCT qual_type_id FROM jtf_terr_winners_v; — enumerates the qualification types represented in the winning set.

Because the view already applies an ORDER BY, dependent queries should avoid re-sorting where unnecessary, and callers should note that the embedded sort applies only to direct selects unless the view is nested in an inline subquery. All access should be granted through the APPS schema, consistent with standard EBS security and synonym conventions.