Search Results aso_quote_statuses_tl




Overview
Explore in AI Chat

Overview

ASO_QUOTE_STATUSES_TL is the translation table that accompanies ASO_QUOTE_STATUSES_B within the ASO (Order Capture) module of Oracle E-Business Suite. In EBS Release 12.1.1 and 12.2.2, Oracle stores multilingual lookup and status definitions using a two-table translation model: a base table (_B) holds language-independent attributes and the primary key, while the translation table (_TL) holds the language-dependent descriptive text. ASO_QUOTE_STATUSES_TL therefore holds the translated name and description for each quote status defined in the base table, allowing quote statuses such as those used in the Oracle Quoting and Order Capture flows to be displayed in the session language of the user. The table is owned by the ASO schema and is reported as VALID in the ETRM 12.2.2 data dictionary.

From a Data Vault modeling perspective, the mined FK structure classifies this object heuristically as standalone. Extending that heuristic, ASO_QUOTE_STATUSES_TL is best modeled as a satellite of the quote-status hub, keyed on quote status and language, rather than as an independent hub or a link. This reflects its role as descriptive, language-specific context attached to the core status entity.

Key Information Stored

The table contains 17 documented columns, of which the following are the most significant for querying and reporting:

  • QUOTE_STATUS_ID — Surrogate identifier for the quote status; the first component of the composite primary key and the column that joins back to ASO_QUOTE_STATUSES_B.
  • LANGUAGE — The language code of the translated row (for example, US or an installed NLS language). This is the second component of the primary key and the discriminating column that allows a single status to carry multiple translations.
  • SOURCE_LANG — The language of the source (base) row from which this translation was derived; typically the installation's base language.
  • MEANING — The translated, user-facing display name of the quote status. This is the principal attribute consumed by concurrent programs, forms, and reports.
  • DESCRIPTION — The translated long description of the quote status.
  • ZD_EDITION_NAME — Editioning column introduced with the EBS 12.2 online patching architecture; it participates in the unique index ASO_QUOTE_STATUSES_TL_U1 along with QUOTE_STATUS_ID and LANGUAGE.

The documented primary key is ASO_QUOTE_STATUSES_TL_PK on (QUOTE_STATUS_ID, LANGUAGE). The business-key candidate is captured by the unique index ASO_QUOTE_STATUSES_TL_U1 on (QUOTE_STATUS_ID, LANGUAGE, ZD_EDITION_NAME). The standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — and the concurrent-manager audit columns REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, and PROGRAM_UPDATE_DATE record insert/update provenance. SECURITY_GROUP_ID carries a foreign key to FND_SECURITY_GROUPS, and OBJECT_VERSION_NUMBER supports optimistic locking.

Common Use Cases and Queries

The most frequent requirement is to resolve a quote's status code into a readable, localized label. A typical join is:

  • SELECT t.meaning, t.description FROM aso_quote_statuses_tl t WHERE t.quote_status_id = :status_id AND t.language = USERENV('LANG');
  • Reporting on quote pipeline by status: join ASO_QUOTE_HEADERS_ALL to ASO_QUOTE_STATUSES_B, then to ASO_QUOTE_STATUSES_TL filtered on the reporting language, to produce grouped counts and values.
  • Data-quality checks that identify statuses in the base table lacking a translation: SELECT b.quote_status_id FROM aso_quote_statuses_b b WHERE NOT EXISTS (SELECT 1 FROM aso_quote_statuses_tl t WHERE t.quote_status_id = b.quote_status_id AND t.language = 'US');
  • Verifying the active edition in a 12.2 environment by including the ZD_EDITION_NAME predicate against the run edition when querying translation rows directly.

Because translation rows are maintained in multiple languages, queries should always constrain LANGUAGE (or use USERENV('LANG')) to avoid duplicate rows in result sets.

Related Objects

  • ASO_QUOTE_STATUSES_B — The base table; join on QUOTE_STATUS_ID to obtain language-independent attributes and to obtain the status code.
  • FND_SECURITY_GROUPS — Referenced by ASO_QUOTE_STATUSES_TL.SECURITY_GROUP_ID; used for multi-org/security-group filtering.
  • FND_LANGUAGES — Provides the valid values for LANGUAGE and SOURCE_LANG.
  • ASO_QUOTE_HEADERS_ALL — Holds quote header records whose status is resolved through the status tables.
  • ASO_QUOTE_LINES_ALL — Line-level records that inherit status context from the quote header and status definitions.
  • ASO_LOOKUPS / FND_LOOKUPS — Common cross-reference for enumerating the status codes surfaced by the quote status tables.
  • FND_APPLICATION / FND_APPLICATION_TL — 12.2 edition-aware views that align with the ZD_EDITION_NAME pattern used by this table.
  • ASO_QUOTE_STATUSES_TL_PK / ASO_QUOTE_STATUSES_TL_U1 — The primary key and unique indexes that enforce row identity and business-key uniqueness.