Search Results jtf_terr_rsc_all

Overview

The JTF_TERR_RSC_ALL table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module. Its primary function is to manage the assignment of resources to territories, a fundamental concept in territory management for sales, service, and marketing operations. This table acts as the central junction linking territory definitions, individual resources, and resource groups, enabling the structured organization of workforce responsibilities and access rights based on geographical, account-based, or other defined territories. Its role is critical for routing opportunities, service requests, and marketing activities to the appropriate teams or individuals as defined by the enterprise's territory model.

Key Information Stored

The table's structure is designed to capture the essential links in the territory-resource relationship. While the full column list is not detailed in the provided metadata, the documented foreign keys and primary key reveal its critical components. The primary key, TERR_RSC_ID, uniquely identifies each assignment record. The TERR_ID column stores the foreign key to the JTF_TERR_ALL table, identifying the specific territory. The assignment can be to either an individual resource or a group, indicated by the RESOURCE_ID (linking to JTF_RS_RESOURCE_EXTNS) and GROUP_ID (linking to JTF_RS_GROUPS_B) columns, respectively. Additional columns typically manage multi-organization (Multi-Org) context through an ORG_ID, track creation and last update dates, and record the status of the assignment.

Common Use Cases and Queries

This table is central to queries that determine resource coverage and access. A common use case is generating a report of all resources assigned to a specific territory for territory planning or audit purposes. Another frequent operation is validating resource access to a customer or transaction by joining through territory qualification rules. Sample SQL patterns include listing all resource assignments and identifying territories for a given resource.

• Find all resources in a territory: SELECT r.resource_name FROM jtf_rs_resource_extns r, jtf_terr_rsc_all t WHERE t.terr_id = :p_terr_id AND t.resource_id = r.resource_id;
• Find all territories for a resource: SELECT terr.territory_name FROM jtf_terr_all terr, jtf_terr_rsc_all t WHERE t.resource_id = :p_resource_id AND t.terr_id = terr.terr_id;
• List all group assignments: SELECT g.group_name, terr.territory_name FROM jtf_rs_groups_b g, jtf_terr_all terr, jtf_terr_rsc_all t WHERE t.group_id = g.group_id AND t.terr_id = terr.terr_id;

Related Objects

The JTF_TERR_RSC_ALL table is integral to the territory management data model, with defined relationships to several key tables. As documented in the provided metadata, its foreign key relationships are as follows:

• JTF_TERR_ALL: References via TERR_ID. This is the master definition table for all territories.
• JTF_RS_RESOURCE_EXTNS: References via RESOURCE_ID. This table stores extended information about individual resources.
• JTF_RS_GROUPS_B: References via GROUP_ID. This is the base table for resource groups.

Furthermore, this table is referenced as a parent key in:

• JTF_TERR_RSC_ACCESS_ALL: Referenced via TERR_RSC_ID. This child table stores detailed access types and permissions for the territory-resource assignment, such as read or update privileges.