Search Results jtf_seeded_qual_usgs_v




Overview
Explore in AI Chat

Overview

JTF_SEEDED_QUAL_USGS_V is a CRM Foundation (JTF) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It backs the territory qualifier setup form used within the Oracle Territory Manager and related CRM administration flows. Functionally, the view consolidates qualifier definitions with their usage configuration, exposing both what a qualifier is (its seeded name, description, and qualifier type) and whether that qualifier is currently enabled or disabled for territory use. Because it joins the usage table to the seeded qualifier and qualifier-type definitions, administrators and developers can treat it as a single reporting surface for the state of territory-qualifier configuration without traversing several underlying tables independently.

As a view rather than a table, it holds no data of its own; all content is derived at query time from the objects identified in the ETRM metadata. This makes it safe for read-only reporting and integration queries, and it is maintained as VALID in the APPS schema.

Underlying Base Objects

The documented base objects underlying the view are:

  • JTF_QUAL_USGS (synonym) — the primary usage table, aliased JQU, supplying the bulk of columns including enabled flag, qualifier columns, LOV SQL, rules, and display attributes.
  • JTF_SEEDED_QUAL (synonym) — aliased JSQ, contributing the seeded qualifier name and description.
  • JTF_QUAL_TYPE_USGS (view) — aliased JQTU, contributing the qualifier type usage identifier and QUAL_TYPE_ID.
  • JTF_QUAL_TYPES (view) — aliased JQT, contributing the qualifier type name and description.
  • JTF_SOURCES_ALL (synonym) — aliased JSE, contributing SOURCE_ID, LOOKUP_CODE, and the MEANING exposed as USAGE.
  • FND_ACCESS_CONTROL_UTIL (package) — invoked as GET_ORG_NAME to resolve the ORG_ID into a readable operating-unit name.
  • FND_GLOBAL (package) — referenced for session/context values used in the owner-organization resolution.

The view therefore joins usage detail to definitional metadata, translating internal identifiers into human-readable qualifier and organization names.

Key Columns

Common Use Cases and Queries

Typical scenarios include auditing which seeded qualifiers are active for territory definitions, validating configuration before migration between 12.1.1 and 12.2.2, and driving custom LOVs or reports for CRM administrators.

List enabled qualifiers grouped by type:

  • SELECT qualifier_type_name, seeded_qual_name, usage FROM jtf_seeded_qual_usgs_v WHERE enabled_flag = 'Y' ORDER BY qualifier_type_name, seeded_qual_name;

Find disabled qualifiers for review:

  • SELECT seeded_qual_name, qualifier_type_name, usage FROM jtf_seeded_qual_usgs_v WHERE enabled_flag = 'N';

Retrieve presentation metadata for a specific qualifier:

  • SELECT seeded_qual_name, display_type, display_sequence, lov_sql FROM jtf_seeded_qual_usgs_v WHERE seeded_qual_name = :qualifier_name;

Because the view resolves ORG_ID through FND_ACCESS_CONTROL_UTIL, queries return organization names directly, simplifying multi-org reporting without additional joins.