Search Results jtf_terr_type_qual_all




Overview
Explore in AI Chat

Overview

The JTF_TERR_TYPE_QUAL_ALL table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for the Territory Manager functionality. It serves as a critical junction table in the territory definition architecture. Its primary role is to store the association between a defined territory type and the specific qualifiers used to determine membership for territories of that type. This table enables the system to define the precise business rules—such as geography, customer classification, or product line—that automatically assign resources (e.g., sales representatives) to a territory based on transactional data.

Key Information Stored

The table's structure is designed to manage the relationship between territory types and their defining attributes. The most significant columns include the primary key, TERR_TYPE_QUAL_ID, which uniquely identifies each qualifier assignment. The TERR_TYPE_ID is a foreign key that links to the JTF_TERR_TYPES_ALL table, identifying the specific territory type being configured. The QUAL_USG_ID is a foreign key that links to the JTF_QUAL_USGS_ALL table, which holds the master definition of the qualifier itself (e.g., a specific country, state, industry code, or product category). Together, these columns define which qualifier is applied to which territory type, forming the basis of the territory's automatic assignment logic.

Common Use Cases and Queries

A primary use case is the analysis and auditing of territory type configurations. Administrators often need to generate reports listing all qualifiers associated with a given territory type to verify business rules. A common query pattern involves joining to the related master tables to retrieve meaningful names. For example, to list all qualifiers for a specific territory type, one might use:

  • SELECT tt.NAME TERR_TYPE_NAME, qu.QUAL_USG_NAME
  • FROM JTF_TERR_TYPE_QUAL_ALL ttq,
  • JTF_TERR_TYPES_ALL tt,
  • JTF_QUAL_USGS_ALL qu
  • WHERE ttq.TERR_TYPE_ID = tt.TERR_TYPE_ID
  • AND ttq.QUAL_USG_ID = qu.QUAL_USG_ID
  • AND tt.NAME = '<Territory_Type_Name>';

This table is also central during the territory assignment engine's runtime, where it is referenced to determine which qualifier values to evaluate against transaction records.

Related Objects

The JTF_TERR_TYPE_QUAL_ALL table has documented foreign key relationships with two key master tables, as per the provided metadata. These relationships are fundamental to its purpose:

  • JTF_TERR_TYPES_ALL: Linked via the TERR_TYPE_ID column. This table stores the master definition of territory types (e.g., "Sales Region," "Service Area").
  • JTF_QUAL_USGS_ALL: Linked via the QUAL_USG_ID column. This table is the master repository for all available qualifier values that can be used across the system to define territories.

These relationships ensure referential integrity, guaranteeing that every qualifier assigned to a territory type points to a valid type and a valid qualifier definition.