Search Results qualifier_type_description




Overview
Explore in AI Chat

Overview

The JTF_TERR_INHERITED_QUAL_V view belongs to the JTF – CRM Foundation product family and resides in the APPS schema. Its documented purpose is to expose the qualifiers that a given territory inherits from the territories positioned above it in the territory hierarchy, when such a hierarchy exists. In Oracle EBS 12.1.1 and 12.2.2, this view supports territory management and access control reporting by surfacing the effective set of qualifying criteria applying to a territory, not merely those directly assigned to it.

Because qualifiers drive how territories are matched to customers, resources, and opportunities in modules such as Trade Management, Sales, and Service, this view is commonly used in reporting and integration scenarios where inherited—rather than local—qualifier context must be resolved. The column QUALIFIER_TYPE_DESCRIPTION is the descriptive attribute most frequently searched by users, since it translates the underlying seeded qualifier into a human-readable label.

Underlying Base Objects

The view is defined over four primary objects, joined through the territory hierarchy and qualifier usage mappings:

  • JTF_TERR (synonym) — aliased as J1 and J2 to represent the child territory and its parent territory respectively.
  • JTF_TERR_QUAL (synonym) — aliased as J3, providing the qualifier usage assignments tied to a territory.
  • JTF_SEEDED_QUAL_USGS_V (view) — aliased as J4, supplying seeded qualifier usage details including the qualifier type description.
  • FND_ACCESS_CONTROL_UTIL and FND_GLOBAL (packages) — documented reference dependencies frequently invoked by territory and access-control logic.

The join condition J1.PARENT_TERRITORY_ID = J2.TERR_ID establishes the parent-child lineage, while J3.TERR_ID = J1.TERR_ID and J3.QUAL_USG_ID = J4.QUAL_USG_ID link the qualifier assignments to their seeded definitions. A filter J4.QUAL_TYPE_ID <> -1001 excludes a reserved qualifier type from the result set.

Key Columns

  • QUAL_USG_ID — Identifier of the qualifier usage record.
  • SEEDED_QUAL_NAME — Name of the seeded qualifier.
  • QUAL_TYPE_ID — Identifier of the qualifier type; reserved values such as -1001 are excluded.
  • QUALIFIER_TYPE_DESCRIPTION — Descriptive text for the qualifier type, the most commonly referenced attribute in searches.
  • TERR_ID — Identifier of the territory inheriting the qualifier.
  • TERR_NAME — Name of the inheriting territory.
  • PARENT_TERR_NAME — Name of the parent territory in the hierarchy.
  • HIERARCHY_LEVEL — Exposed as NULL in the view text; not populated by this definition.

Common Use Cases and Queries

Typical scenarios include auditing which qualifiers a territory inherits, validating territory setups prior to campaign or opportunity assignment, and reconciling inherited qualifiers against those directly assigned. A representative query filtering on the searched attribute is:

  • SELECT terr_name, parent_terr_name, seeded_qual_name, qualifier_type_description FROM jtf_terr_inherited_qual_v WHERE qualifier_type_description = :desc;
  • SELECT terr_id, terr_name, qualifier_type_description FROM jtf_terr_inherited_qual_v ORDER BY terr_name;

These queries return the inherited qualifier context for each territory, supporting reporting, troubleshooting, and integration extraction in both 12.1.1 and 12.2.2 environments.