Search Results jtf_tty_named_accts




Overview
Explore in AI Chat

Overview

The JTF_TTY_NAMED_ACCTS table is a core data repository within the Oracle E-Business Suite CRM Foundation (JTF) module, specifically for the Territory Manager (TTY) functionality. Its primary role is to serve as the master definition table for Named Accounts, a key concept in territory management. A Named Account represents a specific customer or prospect organization (Party) that has been formally identified and designated for targeted sales, marketing, or service activities. This designation allows the account to be centrally managed, assigned to territories, and tracked with specific metrics and qualification criteria, enabling strategic account management within the EBS framework.

Key Information Stored

While the provided ETRM metadata does not list individual columns, the defined relationships and primary key structure reveal the table's critical data elements. The central column is NAMED_ACCOUNT_ID, which serves as the unique primary key identifier for each Named Account record. A fundamental foreign key is PARTY_ID, which links the Named Account to a specific organization record in the HZ_PARTIES table of the Trading Community Architecture (TCA) model. This linkage is essential, as it grounds the Named Account in the master customer data of the enterprise. Other columns typically found in such a table would include creation and last update dates, the creating user, and potentially status flags to indicate whether the Named Account is active or inactive.

Common Use Cases and Queries

This table is central to operations involving strategic account management and territory assignment. Common use cases include generating lists of all Named Accounts assigned to a specific territory or sales representative, and creating reports on key accounts for executive review. A fundamental query involves joining to the TCA model to retrieve the account's name and details.

  • Retrieve Basic Named Account Information:
    SELECT n.named_account_id, p.party_name, n.creation_date
    FROM jtf.jtf_tty_named_accts n,
    hz_parties p
    WHERE n.party_id = p.party_id
    AND n.named_account_id = :1;
  • Find Named Accounts in a Territory Group:
    SELECT n.named_account_id, p.party_name
    FROM jtf_tty_named_accts n,
    jtf_tty_terr_grp_accts t,
    hz_parties p
    WHERE n.named_account_id = t.named_account_id
    AND n.party_id = p.party_id
    AND t.territory_group_id = :1;

Related Objects

The JTF_TTY_NAMED_ACCTS table sits at the center of a key data model for account management, with defined relationships to several supporting tables.

  • Referenced Parent Table:
    • HZ_PARTIES: The Named Account is based on a TCA Party. Joined via JTF_TTY_NAMED_ACCTS.PARTY_ID = HZ_PARTIES.PARTY_ID.
  • Referencing Child Tables:
    • JTF_TTY_ACCT_METRICS: Stores performance metrics (e.g., revenue, opportunity pipeline) specific to a Named Account. Joined via JTF_TTY_ACCT_METRICS.NAMED_ACCOUNT_ID = JTF_TTY_NAMED_ACCTS.NAMED_ACCOUNT_ID.
    • JTF_TTY_ACCT_QUAL_MAPS: Holds qualification data or scores assessing the account's potential or fit. Joined via JTF_TTY_ACCT_QUAL_MAPS.NAMED_ACCOUNT_ID = JTF_TTY_NAMED_ACCTS.NAMED_ACCOUNT_ID.
    • JTF_TTY_TERR_GRP_ACCTS: Maps the Named Account to one or more territory groups for assignment and coverage. Joined via JTF_TTY_TERR_GRP_ACCTS.NAMED_ACCOUNT_ID = JTF_TTY_NAMED_ACCTS.NAMED_ACCOUNT_ID.