Search Results jtf_type_qtype_usgs_all




Overview
Explore in AI Chat

Overview

The JTF_TYPE_QTYPE_USGS_ALL table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. It functions as a mapping or assignment table, defining the permissible relationships between transaction types and territory types. In the context of Oracle EBS's territory management and resource management functionalities, this table governs which specific transaction types—such as leads, opportunities, or service requests—can be associated with and managed within a given territory type. This enforcement is critical for structuring sales, service, and marketing operations, ensuring data and workflow assignments adhere to the defined organizational and geographical hierarchies configured in the system.

Key Information Stored

The table's primary purpose is to store the unique assignment records linking a territory type to a qualification type usage. The key columns that facilitate this are the primary and foreign keys. The primary key column, TYPE_QTYPE_USG_ID, uniquely identifies each assignment record. The two critical foreign key columns establish the relationships: TERR_TYPE_ID references a specific territory type defined in the JTF_TERR_TYPES_ALL table, and QUAL_TYPE_USG_ID references a specific qualification type usage (which defines a transaction type) in the JTF_QUAL_TYPE_USGS_ALL table. The existence of a record in this table explicitly permits the associated transaction type to be used within the context of the specified territory type.

Common Use Cases and Queries

This table is primarily accessed during the setup and administration of territories, as well as during runtime validation when transactions are created or assigned. A common administrative query would involve listing all transaction types enabled for a specific territory type to verify setup. For example:

  • Identifying all qualified transaction types for a 'SALES_REGION' territory type for audit purposes.
  • Troubleshooting configuration issues when a specific transaction type (e.g., 'Opportunity') is unavailable for assignment within a territory.
  • Generating a report of all territory-type-to-transaction-type mappings across the enterprise.

A typical SQL pattern would join JTF_TYPE_QTYPE_USGS_ALL to JTF_TERR_TYPES_ALL and JTF_QUAL_TYPE_USGS_ALL to resolve the IDs to meaningful names.

Related Objects

The JTF_TYPE_QTYPE_USGS_ALL table is central to a small but critical cluster of objects governing territory definitions. Its two direct foreign key dependencies are fundamental:

  • JTF_TERR_TYPES_ALL: The parent table for territory type definitions. The TERR_TYPE_ID foreign key links to this table.
  • JTF_QUAL_TYPE_USGS_ALL: The parent table that defines qualification type usages (transaction types). The QUAL_TYPE_USG_ID foreign key links to this table.

This table is referenced by territory management logic within the CRM Foundation APIs and user interfaces. Any programmatic creation or validation of territory rules that involve transaction types will ultimately query this table to enforce the configured relationships.