Search Results qualifier_mode_desc

Overview

APPS.JTF_TERR_QUALIFIERS_V is a reporting view in the Oracle E-Business Suite Territory Management (also branded as Oracle Trade Management / ETRM) module. It presents the qualifier configuration that is attached to territories, resolving the numeric foreign-key relationships held in the transactional territory-qualifier table into business-readable descriptions. The view joins the territory qualifier assignment (JTF_TERR_QUAL) to the qualifier usage definitions (JTF_QUAL_USGS), the seeded qualifier registry (JTF_SEEDED_QUAL), the qualifier type usages (JTF_QUAL_TYPE_USGS) and the qualifier types (JTF_QUAL_TYPES). Because it exposes names, display types, LOV SQL fragments and formatting metadata rather than raw IDs, it is the standard surface for reporting, diagnostics and integration extracts that must describe what a territory is qualified by rather than merely which usage row is referenced.

The view is defined as a UNION ALL of two branches. The first branch selects rows where QUALIFIER_MODE IS NULL, treating them as the unqualified (default) case; the second branch carries rows with a non-null qualifier mode. Both branches return the identical column list so the union remains type-consistent. The owner is APPS and the view is subject to standard multi-org security through the ORG_ID column.

Underlying Base Objects

• JTF_TERR_QUAL (synonym) — the driving table; stores each territory-to-qualifier-usage assignment, including TERR_QUAL_ID, TERR_ID, QUAL_USG_ID, mode and flag columns.
• JTF_QUAL_USGS (synonym) — the qualifier usage definition; supplies display behaviour such as DISPLAY_TYPE, LOV_SQL, COLUMN_COUNT, formatting and special function settings.
• JTF_SEEDED_QUAL (synonym) — the seeded qualifier registry; provides the human-readable QUALIFIER_NAME.
• JTF_QUAL_TYPE_USGS (view) and JTF_QUAL_TYPES (view) — resolve the qualifier hierarchy, yielding QUAL_TYPE_ID, QUALIFIER_TYPE_NAME and QUALIFIER_TYPE_DESCRIPTION.
• FND_GLOBAL (package) and FND_LOOKUPS (view) — documented dependencies supporting session context and lookup translation.

Joins are driven on QUAL_USG_ID, SEEDED_QUAL_ID and QUAL_TYPE_USG_ID / QUAL_TYPE_ID respectively, producing one row per territory-qualifier usage assignment.

Key Columns

• TERR_QUAL_ID, TERR_ID, QUAL_USG_ID — primary identifiers linking the row to its territory and qualifier usage.
• QUALIFIER_MODE — the qualifier's operating mode; QUALIFIER_MODE_DESC is returned as NULL in the documented text and is normally resolved by the caller or a lookup join.
• OVERLAP_ALLOWED_FLAG, USE_TO_NAME_FLAG, GENERATE_FLAG — control flags governing overlap behaviour, naming and generation of qualifier values.
• QUALIFIER_NAME, QUALIFIER_TYPE_NAME, QUALIFIER_TYPE_DESCRIPTION — descriptive attributes from the seeded qualifier and qualifier type.
• DISPLAY_TYPE, LOV_SQL, LOV_SQL2, LOV_SQL3, DISPLAY_SQL1, DISPLAY_SQL2, DISPLAY_SQL3, COLUMN_COUNT — UI/render metadata used by the qualifier LOV and display framework.
• CONVERT_TO_ID_FLAG, FORMATTING_FUNCTION_FLAG, FORMATTING_FUNCTION_NAME, SPECIAL_FUNCTION_FLAG, SPECIAL_FUNCTION_NAME, ENABLE_LOV_VALIDATION — extended validation and rendering behaviour.
• ORG_ID plus the standard WHO columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN) — multi-org and audit context.

Common Use Cases and Queries

The view supports territory setup verification, migration comparisons between 12.1.1 and 12.2.2, and extracts feeding downstream analytics. A typical listing joins it to the territory name for readability:

• List all qualifiers for a territory: SELECT qualifier_name, qualifier_type_name, qualifier_mode, overlap_allowed_flag FROM jtf_terr_qualifiers_v WHERE terr_id = :p_terr_id;
• Find territories using a specific seeded qualifier: SELECT terr_id, qualifier_name FROM jtf_terr_qualifiers_v WHERE qualifier_name = :p_name;
• Audit LOV configuration: SELECT qualifier_name, display_type, column_count, enable_lov_validation FROM jtf_terr_qualifiers_v ORDER BY qualifier_name;
• Multi-org scoped report: SELECT org_id, qualifier_name, use_to_name_flag FROM jtf_terr_qualifiers_v WHERE org_id = :p_org_id;

Because QUALIFIER_MODE_DESC is not populated by the view text, reports requiring a decoded mode should join to the appropriate lookup or apply a local decode.