Search Results qualifier_code

Overview

The Oracle E-Business Suite view AS_TERR_SEEDED_QUALIFIERS belongs to the AS (Sales Foundation) product family and is documented as Obsolete. Its stated purpose is to expose Territory Qualifiers in a single-organization, non-MLS (Multi-Lingual Support) context. The view presents a filtered, organization-scoped snapshot of seeded qualifier definitions — the attributes used to define and evaluate territory qualifiers such as qualifier code, name, type, format, and enablement status.

The view is not implemented in the current database (per the ETRM metadata, "Not implemented in this database"), and its referenced base objects are not documented. In Oracle EBS 12.1.1 and 12.2.2 environments, its historical role was to support reporting and integration queries against territory qualifier seed data without requiring callers to handle the MLS "_ALL" table directly. Because the view strips MLS columns and applies an ORG_ID predicate derived from the session's CLIENT_INFO, it was suited to single-org responsibility contexts. In 12.2.2 the same functional data is served by other objects, and this view is retained only as legacy metadata.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text explicitly selects from AS_TERR_SEEDED_QUALIFIERS_ALL, which is the MLS-enabled table holding territory qualifier seed records across organizations. The view is therefore a thin projection over that table with two transformations:

• Column projection: it exposes only the non-MLS columns of the "_ALL" table and omits MLS language columns.
• Row filtering: the WHERE clause compares NVL(ORG_ID, -99) against the organization identifier resolved from USERENV('CLIENT_INFO'). When CLIENT_INFO's first character is a space, the extracted value is NULL; otherwise the first ten characters are converted to a number. Records whose ORG_ID is NULL are coerced to -99, allowing both org-specific and global (null-org) rows to match when the session resolves to -99.

Because the "-_ALL" table is MLS-enabled, the "_ALL" suffix and the CLIENT_INFO filter reflect the standard EBS multi-org and MLS access pattern used throughout the 11i and 12.x releases.

Key Columns

The view exposes fourteen columns that collectively describe a seeded territory qualifier:

• SEEDED_QUALIFIER_ID — Primary identifier for the seeded qualifier record.
• QUALIFIER_CODE — The short code uniquely identifying the qualifier; this is the column most often used in joins and lookups.
• NAME — Descriptive name of the qualifier as displayed to users.
• TYPE — Classification of the qualifier (for example, the category or source type used in territory definition).
• FORMAT — The value format expected for the qualifier.
• ENABLED_FLAG — Indicates whether the qualifier is active (typically 'Y'/'N').
• DESCRIPTION — Free-text description of the qualifier's purpose.
• ACCESS_TYPE — Access scope or visibility classification for the qualifier.
• ORG_ID — Operating unit/organization identifier used for multi-org filtering.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN record standard EBS row audit information.

Common Use Cases and Queries

Historically, this view was queried to list or resolve territory qualifiers by code within a single operating unit, particularly in reports and integration extracts that avoided the MLS columns of the underlying table. A representative query is:

SELECT QUALIFIER_CODE, NAME, TYPE, FORMAT, ENABLED_FLAG
FROM   AS_TERR_SEEDED_QUALIFIERS
WHERE  ENABLED_FLAG = 'Y'
ORDER BY QUALIFIER_CODE;

Because the object is obsolete, developers on 12.1.1 and 12.2.2 should query the supported objects (such as AS_TERR_SEEDED_QUALIFIERS_ALL, applying appropriate MO and MLS predicates) or the current seeded-qualifier structures instead. Any legacy code referencing AS_TERR_SEEDED_QUALIFIERS should be reviewed for replacement, as the view is not implemented in the database and is retained for documentation only.