Search Results jtf_qual_type_usgs_all

Overview

The JTF_QUAL_TYPE_USGS_ALL table is a core intersection entity within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for versions 12.1.1 and 12.2.2. It serves as a critical junction table that establishes and manages the permissible relationships between qualifier types (JTF_QUAL_TYPES_ALL) and their sources (JTF_SOURCES_ALL). Its primary role is to define the source of a qualifier type, thereby governing which qualifier types are available and valid for use by specific source entities within the CRM application. This table is fundamental to the data model that supports the flexible qualification and categorization features across various CRM objects.

Key Information Stored

The table's structure is designed to link two primary entities and track the usage of these links. While the full column list is not detailed in the provided metadata, the documented relationships and primary key reveal the essential data points. The primary key column, QUAL_TYPE_USG_ID, is a unique identifier for each valid source-to-qualifier-type relationship record. The two critical foreign key columns are QUAL_TYPE_ID, which references a specific qualifier type definition in JTF_QUAL_TYPES_ALL, and SOURCE_ID, which references an application source in JTF_SOURCES_ALL. The intersection record signifies that the referenced qualifier type is applicable to the referenced source.

Common Use Cases and Queries

A primary use case is the validation and population of lists of available qualifiers during data entry. For instance, when a user is assigning a qualifier to a territory or a party, the application queries this table to determine which qualifier types are valid for that specific object's source. Common queries involve joining to the referenced tables to get descriptive information. A typical reporting query might identify all qualifier types enabled for a particular source:

• SELECT qt.NAME qual_type_name, s.SOURCE_NAME
  FROM jtf_qual_type_usgs_all qtu,
      jtf_qual_types_all qt,
      jtf_sources_all s
  WHERE qtu.qual_type_id = qt.qual_type_id
  AND qtu.source_id = s.source_id
  AND s.SOURCE_NAME = '<Source Name>';

Another critical use is in data integrity checks before inserting records into dependent tables like JTF_QUAL_USGS_ALL, ensuring the qualifier usage is sanctioned by the defined relationships.

Related Objects

As documented in the metadata, JTF_QUAL_TYPE_USGS_ALL sits at the center of a key relationship hierarchy. It references two parent tables and is referenced by three child tables, forming the backbone of the qualifier assignment model.

• Parent Tables (Foreign Keys From):
  • JTF_QUAL_TYPES_ALL: Joined via QUAL_TYPE_ID. This table stores the master definition of qualifier types.
  • JTF_SOURCES_ALL: Joined via SOURCE_ID. This table defines the application entities or modules that can use qualifiers.
• Child Tables (Foreign Keys To):
  • JTF_QUAL_USGS_ALL: Joined via QUAL_TYPE_USG_ID. This table stores the actual assigned qualifier values for specific objects.
  • JTF_TERR_QTYPE_USGS_ALL: Joined via QUAL_TYPE_USG_ID. Governs the usage of qualifier types within the territory management module.
  • JTF_TYPE_QTYPE_USGS_ALL: Joined via QUAL_TYPE_USG_ID. Manages qualifier type usage for specific object types.