Results for “as_terr_type_qualifiers_v”

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

Overview

AS_TERR_TYPE_QUALIFIERS_V is a Sales Foundation (AS) reporting view that exposes territory type qualifier definitions in Oracle E-Business Suite 12.1.1 and 12.2.2. Territory types classify the categories of territories an enterprise maintains in its territory model (for example, sales, service, or collections territories), and territory qualifiers determine the customer, product, or resource attributes that drive territory assignment. This view joins the type-level qualifier assignment table to a seeded qualifier view, producing a flattened, denormalized result set that combines the relationship data with the descriptive attributes of each qualifier.

The view is read-only and primarily intended for reporting, data extraction, and integration scenarios. Because it surfaces columns such as OVERLAP_ALLOWED_FLAG alongside qualifier descriptive data, it is commonly used to verify how qualifier overlap is configured for a given territory type, an important consideration when designing territory assignment rules in Oracle Territory Manager.

Underlying Base Objects

The view is defined over two objects:

• AS_TERR_TYPE_QUALIFIERS (aliased TYPQUAL) — the base table holding territory type qualifier assignments, including the qualifying flag.
• AS_TERR_SEEDED_QUALIFIERS_V (aliased SEEDQUAL) — a seeded qualifiers view supplying descriptive attributes.

The two are related by an inner join on SEEDED_QUALIFIER_ID, so only type qualifiers with a matching seeded qualifier are returned. All columns are inherited from the two source objects; no computed or aggregated columns are exposed. Documentation for the referenced base objects is limited in the ETRM metadata, and the view is noted as not implemented in the reference database.

Key Columns

• TERR_TYPE_QUALIFIER_ID — primary surrogate key identifying the type-qualifier assignment.
• SEEDED_QUALIFIER_ID — foreign key to the seeded qualifier definition.
• TERRITORY_TYPE_ID — identifies the territory type to which the qualifier is assigned.
• OVERLAP_ALLOWED_FLAG — indicates whether qualifier values may overlap within the territory type; central to the user's search.
• SEEDQUAL_QUALIFIER_CODE, SEEDQUAL_NAME, SEEDQUAL_DESCRIPTION — identifying and descriptive text for the qualifier.
• SEEDQUAL_TYPE_CODE, SEEDQUAL_TYPE — the qualifier's data type (for example text or number).
• SEEDQUAL_FORMAT_CODE, SEEDQUAL_FORMAT — display/formatting attributes for qualifier values.
• SEEDQUAL_ENABLED_FLAG — indicates whether the seeded qualifier is currently active.
• SEEDQUAL_ACCESS_TYPE_CODE, SEEDQUAL_ACCESS_TYPE — usable values/access semantics for the qualifier.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Who columns inherited from the base table.
• ROW_ID — the ROWID of the underlying AS_TERR_TYPE_QUALIFIERS row.

Common Use Cases and Queries

Typical scenarios include auditing which qualifiers are assigned to a territory type, checking overlap settings before enabling a territory, and extracting qualifier metadata for migration or validation scripts. A representative query filtering on the overlap flag is:

• SELECT territory_type_id, seedqual_name, overlap_allowed_flag FROM as_terr_type_qualifiers_v WHERE overlap_allowed_flag = 'Y';
• SELECT territory_type_id, seedqual_qualifier_code, seedqual_name, overlap_allowed_flag FROM as_terr_type_qualifiers_v WHERE territory_type_id = :p_type_id ORDER BY seedqual_name;
• SELECT a.seedqual_name, a.seedqual_type_code, a.overlap_allowed_flag FROM as_terr_type_qualifiers_v a WHERE a.seedqual_enabled_flag = 'Y' AND a.overlap_allowed_flag = 'N';

Because the view is built on a join, consumers should expect only rows with valid seeded qualifier references. Ordering and filtering on SEEDQUAL_NAME and TERRITORY_TYPE_ID is recommended for readable output in concurrent programs and BI Publisher reports.