Search Results jtf_terr_qtype_usgs_all

Overview

The JTF_TERR_QTYPE_USGS_ALL table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It functions as a junction table that defines the permissible relationships between territories and transaction types, a critical component of the territory management engine. Its primary role is to store the assignment of specific qualification or transaction types to a territory, thereby governing which business activities—such as sales opportunities, service requests, or marketing campaigns—can be managed by resources within that territory. This table is essential for enforcing business rules and data access security based on the territory-qualification matrix in both Oracle EBS 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to link two primary entities through foreign key relationships. The most significant columns include the primary key, TERR_QTYPE_USG_ID, which uniquely identifies each assignment record. The TERR_ID column stores the identifier for the territory, linking to the JTF_TERR_ALL table. The QUAL_TYPE_USG_ID column stores the identifier for the specific qualification type usage, linking to the JTF_QUAL_TYPE_USGS_ALL table. This column defines the type of transaction, such as 'SALES_OPPORTUNITY' or 'SERVICE_REQUEST', that is enabled for the associated territory.

Common Use Cases and Queries

A primary use case is the administration and validation of territory definitions. When configuring a territory, administrators use this table to define which transaction types are relevant. A common reporting need is to list all transaction types assigned to a specific territory for audit or setup verification. A typical query would be:

• SELECT terr.NAME, qtype.MEANING FROM jtf_terr_qtype_usgs_all assign, jtf_terr_all terr, jtf_qual_type_usgs_all qtype WHERE assign.terr_id = terr.terr_id AND assign.qual_type_usg_id = qtype.qual_type_usg_id AND terr.NAME = '&TERRITORY_NAME';

Conversely, identifying all territories authorized for a specific transaction type is crucial for access control logic within CRM flows, often performed via APIs or direct SQL lookups.

Related Objects

This table sits at the intersection of two major master data entities, as defined by its documented foreign key constraints.

• JTF_TERR_ALL: The master table for all territory definitions. The relationship is established via the column JTF_TERR_QTYPE_USGS_ALL.TERR_ID, which references JTF_TERR_ALL. This links a qualification type assignment to a specific territory.
• JTF_QUAL_TYPE_USGS_ALL: The master table defining available qualification (transaction) types. The relationship is established via the column JTF_TERR_QTYPE_USGS_ALL.QUAL_TYPE_USG_ID, which references JTF_QUAL_TYPE_USGS_ALL. This links a territory assignment to a specific business transaction type.

These relationships are fundamental; the table is meaningless without joins to these parent tables to resolve territory names and qualification type meanings.