Results for “seeded_qual_id”

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

Overview

JTF_SEEDED_QUAL_ALL_B is a CRM Foundation (JTF) table in Oracle E-Business Suite that stores the seeded qualifiers used to define territories within the Territory Management framework. Qualifiers represent the filterable attributes — such as customer classification, geography, industry, or sales channel — against which territory rules are evaluated. The table acts as the master definition repository for these qualifier records, which are then consumed by territory assignment and eligibility processing across CRM applications.

From a Data Vault modeling perspective, the table's relationship structure suggests a hub-leaning classification. The primary key SEEDED_QUAL_ID serves as a stable surrogate identifier, while the SURROGATE-style foreign key to FND_SECURITY_GROUPS and the presence of language-translation children indicate a central entity surrounded by descriptive and security satellites rather than a transactional link. This classification is a heuristic derived from the foreign key topology and should be treated as a modeling suggestion, not a documented architectural mandate.

Key Information Stored

The table has 11 documented columns in the ETRM 12.2.2 physical schema. The most significant are:

• SEEDED_QUAL_ID — Surrogate primary key (JTF_SEEDED_QUAL_ALL_B_PK) uniquely identifying each seeded qualifier.
• NAME — The display name of the qualifier, used in territory rule definition screens.
• DESCRIPTION — Free-text explanation of the qualifier's intended use.
• ORG_ID — Operating unit / organization identifier, enabling multi-org scoping of qualifier records.
• SECURITY_GROUP_ID — Foreign key to FND_SECURITY_GROUPS, controlling which security context can access the row.
• ZD_EDITION_NAME — Editioning column supporting Oracle EBS 12.2 online patching and edition-based redefinition.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — Standard EBS audit columns tracking row provenance and change history.

A unique index, JTF_SEEDED_QUAL_B_U1, spans SEEDED_QUAL_ID, ORG_ID, and ZD_EDITION_NAME, making this the strongest business-key candidate for the entity.

Common Use Cases and Queries

Territory administrators and CRM developers query this table to enumerate available qualifiers when building or auditing territory definitions. A typical lookup returns all non-editioned active qualifiers for a given operating unit:

• SELECT seeded_qual_id, name, description FROM jtf_seeded_qual_all_b WHERE org_id = :org_id AND zd_edition_name = 'SET1';
• Join to the translation table to retrieve language-specific names: SELECT b.seeded_qual_id, t.name FROM jtf_seeded_qual_all_b b, jtf_seeded_qual_all_tl t WHERE b.seeded_qual_id = t.seeded_qual_id AND t.language = USERENV('LANG');
• Usage auditing via JTF_QUAL_USGS_ALL to determine which qualifiers are actually referenced by territory rules.

Reporting use cases include territory rule governance reports, security-group exposure analysis, and post-upgrade validation that seeded qualifiers remain consistent across editions.

Related Objects

The following objects have documented referential relationships with JTF_SEEDED_QUAL_ALL_B:

• JTF_SEEDED_QUAL_ALL_TL — Translation child table; joins on SEEDED_QUAL_ID and supplies language-specific NAME and DESCRIPTION.
• JTF_QUAL_USGS_ALL — Qualifier usage table; references SEEDED_QUAL_ID to record where each qualifier is consumed in territory and qualifier assignment logic.
• FND_SECURITY_GROUPS — Referenced by SECURITY_GROUP_ID, governing access control for qualifier rows.
• JTF_SEEDED_QUAL_ALL_B_PK — Primary key constraint enforcing unique SEEDED_QUAL_ID values.
• JTF_SEEDED_QUAL_B_U1 — Unique index on SEEDED_QUAL_ID, ORG_ID, ZD_EDITION_NAME.

Together these objects form the qualifier definition and consumption layer that underpins Territory Management and related CRM Foundation functionality in EBS 12.1.1 and 12.2.2.