Search Results aso_quote_statuses_vl




Overview
Explore in AI Chat

Overview

ASO_QUOTE_STATUSES_VL is a multilingual (VL) view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the ASO – Order Capture product family. It exposes the full set of descriptive and control attributes that define the lifecycle statuses available to a quote in Oracle Quoting / Order Capture. The view combines the non-translatable business columns held in the base table ASO_QUOTE_STATUSES_B with the language-dependent text columns (MEANING and DESCRIPTION) held in the translation table ASO_QUOTE_STATUSES_TL.

Because it is a VL view, it resolves the translated text for the session language only, using USERENV('LANG') as the language discriminator. This makes it the standard access point for forms, reports, concurrent programs, and integration interfaces that must present quote status information in the user's own language without manually joining the translation table. Under EBS 12.1.1 and 12.2.2 the definition and column list are consistent, and the view is reported as VALID.

Underlying Base Objects

The ETRM metadata documents two referenced base objects, both resolved through synonyms in the APPS schema:

  • ASO_QUOTE_STATUSES_B — the base (non-translatable) table supplying identifiers, audit columns, status code, the update/version/user-maintainability flags, effective dating columns, and the fifteen descriptive flexfield (DFF) attribute columns.
  • ASO_QUOTE_STATUSES_TL — the translation table supplying the language-specific MEANING and DESCRIPTION text.

The join is performed on QUOTE_STATUS_ID, with the additional predicate T.LANGUAGE = USERENV('LANG') restricting returned rows to the current session language. The view is therefore read-only with respect to the translation join; the status code itself is stored once in the B table, while its display text is translated per installed language. The B.ROWID value is also projected, which is unusual for a VL view but allows row identification of the base record.

Key Columns

Common Use Cases and Queries

Typical uses include populating status LOVs, driving workflow or approval routing based on the control flags, and joining quote headers to obtain a translated status label. A representative query returning only currently effective, user-maintainable statuses is:

  • SELECT quote_status_id, status_code, meaning, update_allowed_flag
  • FROM   aso_quote_statuses_vl
  • WHERE  user_maintainable_flag = 'Y'
  • AND    SYSDATE BETWEEN NVL(effective_start_date, SYSDATE)
  •                     AND NVL(effective_end_date, SYSDATE)
  • ORDER BY meaning;

A second common pattern resolves the status text for a quote header by joining on QUOTE_STATUS_ID, relying on the view to supply the correct language automatically. Because the view handles the translation join, report and interface code should query ASO_QUOTE_STATUSES_VL rather than the underlying tables directly, ensuring correct multilingual output and shielding callers from the B/TL table split.