Search Results jtf_tty_terr_grp_accts




Overview
Explore in AI Chat

Overview

The JTF_TTY_TERR_GRP_ACCTS table is a core data object within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for the Territory Manager functionality. Its primary role is to manage the association between territory groups and named accounts, serving as a critical junction table in the territory management data model. This table enables the assignment of specific customer accounts to defined territory groups, which is fundamental for structuring sales, service, and marketing coverage models. It acts as a central hub, linking the definition of territory groups with specific account entities and subsequently distributing those account assignments to individual resources.

Key Information Stored

While the provided metadata does not list all column details, the documented foreign key relationships and primary key define its essential structure. The table's primary key is TERR_GROUP_ACCOUNT_ID, a unique identifier for each association record. Two critical foreign key columns form the core of the table's purpose: TERR_GROUP_ID, which references a specific territory group in the JTF_TTY_TERR_GROUPS table, and NAMED_ACCOUNT_ID, which references a specific customer account in the JTF_TTY_NAMED_ACCTS table. The table likely contains standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) for auditing, and may include attributes to manage the status or type of the account-group relationship.

Common Use Cases and Queries

This table is central to queries that determine account coverage and territory composition. A common use case is generating a report of all accounts assigned to a specific territory group for a sales manager. Another is validating account assignments before running compensation or quota calculations. Sample SQL to list all accounts within a territory group would typically join this table with the named accounts and territory groups tables.

  • Sample Query: SELECT nga.NAMED_ACCOUNT_ID, na.ACCOUNT_NAME, tg.TERR_GROUP_NAME FROM JTF_TTY_TERR_GRP_ACCTS nga, JTF_TTY_NAMED_ACCTS na, JTF_TTY_TERR_GROUPS tg WHERE nga.NAMED_ACCOUNT_ID = na.NAMED_ACCOUNT_ID AND nga.TERR_GROUP_ID = tg.TERR_GROUP_ID AND tg.TERR_GROUP_ID = :p_terr_group_id;
  • Data Maintenance: Administrators use this table when adding or removing accounts from a territory group via the Territory Manager UI or supporting APIs.
  • Impact Analysis: Before modifying a territory group's definition, queries against this table identify all dependent account assignments that may be affected.

Related Objects

The metadata clearly defines JTF_TTY_TERR_GRP_ACCTS as a junction point with multiple dependencies. It references two parent tables and is referenced by three child tables, forming a key part of the territory assignment hierarchy.

  • Referenced Parent Tables (Foreign Keys From):
    • JTF_TTY_TERR_GROUPS: Via TERR_GROUP_ID. This table defines the territory group entity.
    • JTF_TTY_NAMED_ACCTS: Via NAMED_ACCOUNT_ID. This table defines the customer account entities eligible for territory assignment.
  • Referencing Child Tables (Foreign Keys To):
    • JTF_TTY_ACCT_RSC_DN: Via TERR_GROUP_ACCOUNT_ID. This table likely manages the detailed breakdown or distribution of the group account assignment to individual resources.
    • JTF_TTY_ALIGN_ACCTS: Via TERR_GROUP_ACCOUNT_ID. This table may handle the alignment or validation of account assignments against other rules.
    • JTF_TTY_NAMED_ACCT_RSC: Via TERR_GROUP_ACCOUNT_ID. This table is pivotal for storing the final assignment of the named account to a specific territory resource, making JTF_TTY_TERR_GRP_ACCTS a prerequisite for individual resource assignment.