Search Results jtf_terr_qual_all

Overview

The JTF_TERR_QUAL_ALL table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the JTF (CRM Foundation) product module. Its primary function is to store the definition of qualifiers used to define territories. In the context of Oracle Territory Management, a territory is a logical grouping of entities, such as customers or sales resources, based on specific business rules. This table acts as the master repository for those rules, linking a territory to the type of qualifier used (e.g., geography, account classification, sales volume) and serving as the parent record for the specific qualifying values.

Key Information Stored

The table's structure centers on linking territories to qualification types and managing the rule's lifecycle. The primary key column, TERR_QUAL_ID, uniquely identifies each qualifier definition. The TERR_ID column is a foreign key that links the qualifier to its parent territory in the JTF_TERR_ALL table. The QUAL_USG_ID column is a critical foreign key that links to the JTF_QUAL_USGS_ALL table, which defines the type or usage of the qualifier (e.g., specifying whether the rule is based on a customer's SIC code or postal code). Additional standard EBS columns, such as CREATION_DATE, LAST_UPDATE_DATE, CREATED_BY, and LAST_UPDATED_BY, are present to track the record's audit history, while OBJECT_VERSION_NUMBER supports data integrity in multi-session environments.

Common Use Cases and Queries

This table is essential for understanding the composition of any territory and for troubleshooting territory assignment results. A common reporting use case is to list all qualifiers defined for a specific territory to verify business rules. For example:

• Identifying all qualifier types used for a territory: SELECT qual_usg_id FROM jtf_terr_qual_all WHERE terr_id = <TERRITORY_ID>;
• Generating a full territory rule definition by joining to related tables: SELECT tq.terr_id, tq.terr_qual_id, qu.qual_usg, tv.operand, tv.value FROM jtf_terr_qual_all tq JOIN jtf_qual_usgs_all qu ON tq.qual_usg_id = qu.qual_usg_id LEFT JOIN jtf_terr_values_all tv ON tq.terr_qual_id = tv.terr_qual_id WHERE tq.terr_id = <TERRITORY_ID> ORDER BY tq.terr_qual_id;

Data fixes or audits often involve querying this table to find qualifiers that are no longer associated with a valid territory or qualifier usage.

Related Objects

JTF_TERR_QUAL_ALL is a central hub in the territory definition schema, with documented foreign key relationships to several key tables.

• JTF_TERR_ALL: The master territory definition table. The relationship is defined by JTF_TERR_QUAL_ALL.TERR_ID = JTF_TERR_ALL.TERR_ID.
• JTF_QUAL_USGS_ALL: The table defining qualifier usages or types. The relationship is defined by JTF_TERR_QUAL_ALL.QUAL_USG_ID = JTF_QUAL_USGS_ALL.QUAL_USG_ID.
• JTF_TERR_VALUES_ALL: The child table that stores the specific operand and value for each qualifier rule (e.g., "EQUALS" and "USA"). The relationship is defined by JTF_TERR_VALUES_ALL.TERR_QUAL_ID = JTF_TERR_QUAL_ALL.TERR_QUAL_ID.