Search Results jtf_qual_usgs_all

Overview

The JTF_QUAL_USGS_ALL table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically in releases 12.1.1 and 12.2.2. It functions as a pivotal junction table that defines and stores the valid associations between specific qualification rules (qualifiers) and the transaction types of business sources. Its primary role is to govern which qualification criteria can be applied to which types of business transactions, such as sales orders or service requests, thereby enforcing data integrity and business logic within the CRM framework. The table's "ALL" suffix indicates it is a multi-organization enabled table, storing data for all operating units.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal the critical data elements. The central column is QUAL_USG_ID, the unique primary key identifier for each qualifier-to-source-type association record. Two essential foreign key columns define the relationship: SEEDED_QUAL_ID links to a specific seeded qualification rule in JTF_SEEDED_QUAL_ALL_B, and QUAL_TYPE_USG_ID links to a source and transaction type combination defined in the JTF_QUAL_TYPE_USGS_ALL table. This structure ensures that every record in JTF_QUAL_USGS_ALL represents a precise, authorized link between a qualification definition and a transactional context.

Common Use Cases and Queries

A primary use case is the validation and administration of qualification rules during CRM transaction processing. For instance, when a user attempts to apply a qualification to an account or territory assignment, the system references this table to confirm the rule is permitted for that transaction source. Common queries involve listing all qualifiers available for a specific source type or identifying the usage context of a particular seeded qualifier. A sample SQL pattern to retrieve this information is:

• SELECT qa.qual_usg_id, sq.qualifier_name, qtus.source_code, qtus.transaction_type_id FROM jtf_qual_usgs_all qa, jtf_seeded_qual_all_b sq, jtf_qual_type_usgs_all qtus WHERE qa.seeded_qual_id = sq.seeded_qual_id AND qa.qual_type_usg_id = qtus.qual_type_usg_id;

This data is also fundamental for reports analyzing the configuration and coverage of business rules across different sales or service channels.

Related Objects

The JTF_QUAL_USGS_ALL table sits at the center of a key relationship hierarchy within the JTF schema. It references two parent tables and is referenced by several child tables that extend its associations into other functional areas.

• Referenced Parent Tables:
  • JTF_SEEDED_QUAL_ALL_B: Via the SEEDED_QUAL_ID column. This provides the specific qualification rule definition.
  • JTF_QUAL_TYPE_USGS_ALL: Via the QUAL_TYPE_USG_ID column. This provides the source system (e.g., ONT for Order Management) and transaction type context.
• Referencing Child Tables:
  • JTF_TERR_QUAL_ALL: Uses QUAL_USG_ID to assign qualifier usage to specific territories.
  • JTF_TERR_TYPE_QUAL_ALL: Uses QUAL_USG_ID to assign qualifier usage to territory types.
  • JTF_TTY_ACCT_QUAL_MAPS: Uses QUAL_USG_ID to map qualifier usage to specific account types.