Results for “qual_relation_product”

42 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JTF_TERR_QTYPE_USGS_ALL is a CRM Foundation (JTF) transactional table that stores the transaction types which can be assigned to a territory. In Oracle EBS 12.1.1 and 12.2.2, it functions as the association table that links a territory definition to a qualification type usage, effectively controlling which transaction or qualification categories (for example, leads, opportunities, or other qualified entities) are eligible for territory assignment. Territory management drives routing, assignment, and access rules across CRM modules such as Sales, TeleSales, and Trade Management, and this table supplies the configuration that determines which qualifier types participate in those rules.

From a Data Vault modeling perspective, the FK structure suggests this object behaves as a link table: it resolves a many-to-many relationship between territories (JTF_TERR_ALL) and qualification type usages (JTF_QUAL_TYPE_USGS_ALL). The heuristic classification is therefore a link rather than a hub or satellite, with the qualification usage attributes carried in dependent satellites.

Key Information Stored

The table contains 13 documented columns. The most significant are:

Common Use Cases and Queries

Typical reporting retrieves all transaction types enabled for a given territory, or all territories eligible for a specific qualifier type. A sample join pattern follows:

  • SELECT t.territory_id, t.name, q.qual_type_usg_id FROM jtf_terr_qtype_usgs_all u JOIN jtf_terr_all t ON u.terr_id = t.terr_id JOIN jtf_qual_type_usgs_all q ON u.qual_type_usg_id = q.qual_type_usg_id WHERE u.org_id = :org_id;

Administrators use this table to validate territory setup before running the territory assignment concurrent programs. Integration and reconciliation reports compare configured usages against actual lead and opportunity assignments to detect missing or stale territory qualifiers. Because JTF_CHANGED_TERR_ALL carries TERR_QTYPE_USG_ID, change-tracking processes and delta extraction routines reference this table to identify which territory-type usages were modified.

Related Objects

  • JTF_TERR_ALL — parent territory definition; joined on TERR_ID.
  • JTF_QUAL_TYPE_USGS_ALL — qualification type usages; joined on QUAL_TYPE_USG_ID.
  • FND_SECURITY_GROUPS — security group ownership; joined on SECURITY_GROUP_ID.
  • JTF_CHANGED_TERR_ALL — change-tracking table referencing this object via TERR_QTYPE_USG_ID.