Results for “jtf_terr_type_qualifiers_v”

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

Overview

The JTF_TERR_TYPE_QUALIFIERS_V view is an Oracle E-Business Suite database object owned by the APPS schema and delivered as part of the JTF – CRM Foundation product family. It is a reporting and integration-facing view that consolidates territory type qualifier usage with the operational details of each qualifier. In practical terms, the view answers the question: "For a given territory type, which qualifiers are enabled, how are they configured, and what are their behavioral attributes?" This makes it a central reference point for implementers and technical consultants working with Oracle Territory Manager and related CRM modules in both 12.1.1 and 12.2.2.

Territories in EBS are used to partition customers, leads, opportunities, and other CRM entities among sales teams and partners. Each territory type can be qualified by a set of qualifier types (for example, Industry, Geography, or Revenue Range). The view exposes the configuration that governs how those qualifiers behave, including the EXCLUSIVE_USE_FLAG, which indicates whether a qualifier value may be used exclusively by a single territory or shared across multiple territories. Because the view is a read-only projection over transactional and setup tables, it is safe to use within custom reports, concurrent programs, and integration extracts without affecting the underlying configuration.

Underlying Base Objects

The documented ETRM metadata identifies the following base objects that the view is defined over: FND_GLOBAL (package), JTF_QUAL_TYPES (view), JTF_QUAL_TYPE_USGS (view), JTF_QUAL_USGS (synonym), JTF_SEEDED_QUAL (synonym), and JTF_TERR_TYPE_QUAL (synonym). The primary driver table is JTF_TERR_TYPE_QUAL, which stores one row per territory type / qualifier usage combination and carries the flag columns such as EXCLUSIVE_USE_FLAG, OVERLAP_ALLOWED_FLAG, and IN_USE_FLAG. This table joins to JTF_QUAL_USGS on QUAL_USG_ID, which in turn links to JTF_SEEDED_QUAL and, through JTF_QUAL_TYPE_USGS, to JTF_QUAL_TYPES. The view therefore spans territory setup, qualifier usage definition, and the qualifier type catalog, producing a denormalized result set that is convenient for reporting.

Key Columns

• TERR_TYPE_QUAL_ID, TERR_TYPE_ID, QUAL_USG_ID, QUAL_TYPE_ID – Primary and foreign key identifiers linking the territory type to its qualifier usage and qualifier type.
• EXCLUSIVE_USE_FLAG – Indicates whether a value for this qualifier can be assigned to only one territory. This is the column most frequently referenced when diagnosing territory assignment conflicts.
• OVERLAP_ALLOWED_FLAG – Determines whether territories sharing this qualifier may overlap.
• IN_USE_FLAG – Shows whether the qualifier usage is currently active.
• QUALIFIER_MODE, DISPLAY_TYPE, COLUMN_COUNT – Control how the qualifier is presented in the Territory Manager UI and LOVs.
• LOV_SQL, DISPLAY_SQL1..3, LOV_SQL2..3 – SQL fragments used to render the list of values and display columns.
• CONVERT_TO_ID_FLAG, ENABLE_LOV_VALIDATION – Validation and data-conversion behavior flags.
• FORMATTING_FUNCTION_FLAG/NAME, SPECIAL_FUNCTION_FLAG/NAME – Optional PL/SQL hooks applied during qualifier processing.
• QUALIFIER_TYPE_NAME, QUALIFIER_TYPE_DESCRIPTION, QUALIFIER_NAME – Descriptive labels sourced from the qualifier type and seeded qualifier definitions.
• ORG_ID – Multi-org operating unit identifier.
• ROW_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN – Standard WHO columns enabling audit and row-level identification.

Common Use Cases and Queries

Because the view flattens several setup tables, it is well suited to discovery and diagnostic queries. A frequent scenario is auditing exclusive-use configuration across territory types:

• Identify qualifiers marked exclusive: SELECT terr_type_id, qualifier_name, exclusive_use_flag FROM jtf_terr_type_qualifiers_v WHERE exclusive_use_flag = 'Y';
• List all active qualifiers for a territory type: SELECT qualifier_name, qualifier_type_name, in_use_flag FROM jtf_terr_type_qualifiers_v WHERE terr_type_id = :p_terr_type_id;
• Review overlap and display settings together: SELECT qualifier_name, overlap_allowed_flag, display_type, lov_sql FROM jtf_terr_type_qualifiers_v;
• Feed integration extracts with qualifier metadata, including formatting function names and validation flags.

Oracle Proprietary, Confidential Information. The view is read-only; any modification to exclusive-use or overlap behavior must be performed through the supported Territory Manager setup forms, not by direct DML.