Search Results as_terr_type_qualifiers




Overview
Explore in AI Chat

Overview

The AS_TERR_TYPE_QUALIFIERS table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). It functions as a junction or mapping table that defines the permissible relationships between territory types and qualifiers in the application's territory management engine. Its primary role is to enforce data integrity by controlling which qualifiers—attributes like "Industry," "Customer Size," or "Geography"—can be assigned to a specific type of territory. This configuration is fundamental for structuring and segmenting sales territories according to an organization's business rules, ensuring that territory definitions are consistent and valid across the system.

Key Information Stored

The table's structure is designed to store unique combinations of territory types and their associated qualifiers. The critical columns include the surrogate primary key, TERR_TYPE_QUALIFIER_ID, and the unique key constraint composed of SEEDED_QUALIFIER_ID and TERRITORY_TYPE_ID. The TERRITORY_TYPE_ID is a foreign key linking to the AS_TERRITORY_TYPES_ALL table, identifying the specific type of territory (e.g., "Sales," "Service"). The SEEDED_QUALIFIER_ID references a seeded lookup value that represents a specific qualifying attribute. This design ensures that each territory type can be associated with a defined set of qualifiers, and duplicate combinations are prevented.

Common Use Cases and Queries

This table is central to administrative setup and validation processes. A common use case is during the configuration of new territory types, where an administrator must define which qualifiers are applicable. It is also critical for downstream processes when creating or updating individual territory records, as the application validates that the assigned qualifiers are permitted for the territory's type. A typical analytical query would join this table to the territory types and qualifier lookups to report on the current configuration.

  • Sample Query: To list all qualifiers allowed for a given territory type:
    SELECT qtl.meaning AS qualifier_name FROM as_terr_type_qualifiers ttq, fnd_lookup_values qtl WHERE ttq.territory_type_id = :p_terr_type_id AND ttq.seeded_qualifier_id = qtl.lookup_code AND qtl.lookup_type = 'AS_TERR_QUALIFIERS';

Related Objects

The AS_TERR_TYPE_QUALIFIERS table maintains a direct foreign key relationship with the AS_TERRITORY_TYPES_ALL table, which stores the master list of territory types. The join is performed on the TERRITORY_TYPE_ID column. This relationship ensures that a qualifier cannot be associated with a non-existent territory type. While not explicitly listed in the provided metadata, this table is logically a parent to transactional tables that store specific territory definitions (e.g., AS_TERRITORY_QUALIFIERS), which would reference the valid combinations established here. It is also closely tied to the lookup tables (such as FND_LOOKUP_VALUES) that store the descriptive meaning of the SEEDED_QUALIFIER_ID values.