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.

  • Table: JTF_SEEDED_QUAL_ALL_B 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_SEEDED_QUAL_ALL_B,  object_name:JTF_SEEDED_QUAL_ALL_B,  status:VALID,  product: JTF - CRM Foundation ,  description: This table will contain all the qualifiers that are going to be used to define territories. ,  implementation_dba_data: JTF.JTF_SEEDED_QUAL_ALL_B , 

  • Table: JTF_SEEDED_QUAL_ALL_B 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_SEEDED_QUAL_ALL_B,  object_name:JTF_SEEDED_QUAL_ALL_B,  status:VALID,  product: JTF - CRM Foundation ,  description: This table will contain all the qualifiers that are going to be used to define territories. ,  implementation_dba_data: JTF.JTF_SEEDED_QUAL_ALL_B , 

  • View: JTF_SEEDED_QUAL_ALL_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_SEEDED_QUAL_ALL_VL,  object_name:JTF_SEEDED_QUAL_ALL_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Multi-Org single language view of seeded qualifiers. ,  implementation_dba_data: APPS.JTF_SEEDED_QUAL_ALL_VL , 

  • View: JTF_SEEDED_QUAL_ALL_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_SEEDED_QUAL_ALL_VL,  object_name:JTF_SEEDED_QUAL_ALL_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Multi-Org single language view of seeded qualifiers. ,  implementation_dba_data: APPS.JTF_SEEDED_QUAL_ALL_VL , 

  • Table: JTF_SEEDED_QUAL_ALL_TL 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_SEEDED_QUAL_ALL_TL,  object_name:JTF_SEEDED_QUAL_ALL_TL,  status:VALID,  product: JTF - CRM Foundation ,  description: This is the MLS support table for the JTF_SEEDED_QUAL_B table. This table will contain all the translations in different languages for the territory qualifiers that are going to be used to define territories. ,  implementation_dba_data: JTF.JTF_SEEDED_QUAL_ALL_TL , 

  • Table: JTF_SEEDED_QUAL_ALL_TL 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_SEEDED_QUAL_ALL_TL,  object_name:JTF_SEEDED_QUAL_ALL_TL,  status:VALID,  product: JTF - CRM Foundation ,  description: This is the MLS support table for the JTF_SEEDED_QUAL_B table. This table will contain all the translations in different languages for the territory qualifiers that are going to be used to define territories. ,  implementation_dba_data: JTF.JTF_SEEDED_QUAL_ALL_TL , 

  • Table: JTF_QUAL_USGS_ALL 12.1.1

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_QUAL_USGS_ALL,  object_name:JTF_QUAL_USGS_ALL,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the association between a qualifer and the transaction type of a source via JTF_QUAL_TYPE_USGS (stores association between SOURCES/QUALIFER TYPES tables). ,  implementation_dba_data: JTF.JTF_QUAL_USGS_ALL , 

  • Table: JTF_QUAL_USGS_ALL 12.2.2

    owner:JTF,  object_type:TABLE,  fnd_design_data:JTF.JTF_QUAL_USGS_ALL,  object_name:JTF_QUAL_USGS_ALL,  status:VALID,  product: JTF - CRM Foundation ,  description: This table stores the association between a qualifer and the transaction type of a source via JTF_QUAL_TYPE_USGS (stores association between SOURCES/QUALIFER TYPES tables). ,  implementation_dba_data: JTF.JTF_QUAL_USGS_ALL , 

  • View: JTF_SEEDED_QUAL_VL 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_SEEDED_QUAL_VL,  object_name:JTF_SEEDED_QUAL_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Single-languagel,single-org view for displaying the seeded qualifier in Territories ,  implementation_dba_data: APPS.JTF_SEEDED_QUAL_VL , 

  • View: JTF_SEEDED_QUAL_VL 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:JTF.JTF_SEEDED_QUAL_VL,  object_name:JTF_SEEDED_QUAL_VL,  status:VALID,  product: JTF - CRM Foundation ,  description: Single-languagel,single-org view for displaying the seeded qualifier in Territories ,  implementation_dba_data: APPS.JTF_SEEDED_QUAL_VL ,