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:
- TERR_QTYPE_USG_ID — surrogate primary key and the single-column key for JTF_TERR_QTYPE_USGS_ALL_PK. It uniquely identifies each territory-to-qualification-type association.
- TERR_ID — foreign key to JTF_TERR_ALL; identifies the territory to which the transaction type is being assigned.
- QUAL_TYPE_USG_ID — foreign key to JTF_QUAL_TYPE_USGS_ALL; identifies the qualification type usage (transaction or qualifier category) being attached to the territory.
- ORG_ID — operating unit or organization context; together with TERR_QTYPE_USG_ID it forms the unique business-key candidate JTF_TERR_QTYPE_USGS_U1.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS; enforces multi-org / data-security partitioning.
- NUM_QUAL — numeric qualifier value associated with the usage, typically a count or threshold qualifying the association.
- QUAL_RELATION_PRODUCT — identifies the product context under which the qualification relation applies.
- OBJECT_VERSION_NUMBER — optimistic-locking column used by the OAF/BC4J framework to detect concurrent updates.
- Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — who created and last modified the record and when.
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.
-
Stores the transaction types that can be assigned to a territory.
-
Stores the transaction types that can be assigned to a territory.
-
Denormalized Territory tables for performance purposes
-
Denormalized Territory tables for performance purposes
-
eTRM - JTF Tables and Views 12.1.1
Interface table to store data that needs to be displayed in Excel
-
eTRM - JTF Tables and Views 12.2.2
Interface table to store data that needs to be displayed in Excel