Search Results jtf_seeded_qual_all_b




Overview
Explore in AI Chat

Overview

The JTF_SEEDED_QUAL_ALL_B table is a core repository for territory definition within Oracle E-Business Suite's CRM Foundation module. It serves as the master source for all seeded qualifiers, which are the fundamental building blocks used to create complex territory rules. These qualifiers define the criteria—such as geographic location, customer attributes, or product categories—against which accounts, contacts, or sales opportunities are evaluated for assignment to specific sales territories. The table's role is foundational to the territory management engine, enabling the systematic and rule-based partitioning of market data for sales force automation, resource allocation, and compensation planning.

Key Information Stored

The primary data element stored in this table is the unique identifier for each seeded qualifier. While the full column list is not detailed in the provided metadata, the documented primary key and foreign key relationships establish the critical columns. The SEEDED_QUAL_ID column is the primary key, uniquely identifying each qualifier record. This ID is the central reference point for the entire qualifier ecosystem. Other typical columns in such a base table would include system-level attributes like creation date, created by, last update date, and last updated by, which are standard in Oracle EBS tables. The table likely contains columns defining the qualifier's data type, the application table it references, and the specific column used for evaluation.

Common Use Cases and Queries

The primary use case is the setup and maintenance of territory qualification rules within the CRM Territory Manager. Administrators rely on the definitions in this table when constructing territory definitions through the application's user interface. From a technical perspective, common queries involve joining this table to its related objects to retrieve a complete definition of a qualifier or to audit system setup. A fundamental query pattern is retrieving the base qualifier information for a specific ID or a set of IDs used in a territory.

  • Sample Query: Retrieving basic qualifier details for analysis or integration: SELECT seeded_qual_id, last_update_date FROM jtf.jtf_seeded_qual_all_b WHERE seeded_qual_id = <ID_VALUE>;
  • Reporting Use Case: Generating a list of all seeded qualifiers available in the system as part of a territory design document or implementation audit report.

Related Objects

The JTF_SEEDED_QUAL_ALL_B table has defined relationships with several key objects in the territory management schema, as per the provided metadata.

  • JTF_SEEDED_QUAL_ALL_TL: This is the Translation table, linked via SEEDED_QUAL_ID. It stores the user-facing name and description of the qualifier in multiple languages, enabling global deployments.
  • JTF_QUAL_USGS_ALL: This table stores the specific usages of a qualifier, defining how it is applied within different territory rule contexts. It is linked via SEEDED_QUAL_ID.
  • Primary Key: The table is uniquely identified by the JTF_SEEDED_QUAL_ALL_B_PK constraint on the SEEDED_QUAL_ID column.

These relationships form a critical data model where JTF_SEEDED_QUAL_ALL_B acts as the master definition, JTF_SEEDED_QUAL_ALL_TL provides translatable descriptions, and JTF_QUAL_USGS_ALL governs the practical application of each qualifier within territory rules.