Search Results amw_opinion_values_vl




Overview
Explore in AI Chat

Overview

AMW_OPINION_VALUES_VL is a view within the Oracle E-Business Suite AMW – Internal Controls Manager module, an obsolete product component in releases 12.1.1 and 12.2.2. The view presents translated opinion value definitions used to categorize and qualify auditor or reviewer opinions within the internal controls and audit management workflow. Its "_VL" suffix designates it as a "view of list" style object that joins translated and base table content, exposing display-ready, language-specific rows to forms, reports, and integrations.

Because the underlying tables are translatable, the view resolves the appropriate language row at query time by comparing the translation table's LANGUAGE column to the session language returned by USERENV('LANG'). This design allows reporting tools such as Oracle Reports, BI Publisher, and OBIEE to retrieve opinion value descriptions in the end user's language without implementing application-level translation logic. Under ETRM 12.2.2, the object is documented as "Not implemented in this database," indicating that the view definition is registered in the data model but the compiled object is absent in the shipped schema; site-level deployment of AMW determines whether the view actually exists in a given instance.

Underlying Base Objects

The view is defined over two AMW tables:

  • AMW_OPINION_VALUES_B — the base (non-translated) table holding opinion value identifiers, codes, component references, attachment references, ordering, and standard WHO audit columns.
  • AMW_OPINION_VALUES_TL — the translation table holding the language-specific opinion value names, joined on OPINION_VALUE_ID and LANGUAGE.

The join condition links B.OPINION_VALUE_ID to T.OPINION_VALUE_ID and restricts the translation row by T.LANGUAGE = USERENV('LANG'), producing one logical row per opinion value per session language. Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER) are inherited from the base table, supporting multi-org security and optimistic locking conventions.

Key Columns

  • ROW_ID — the B.ROWID of the base table row, used as a stable row identifier for the view.
  • OPINION_VALUE_ID — primary key linking the base and translation tables.
  • OPINION_VALUE_CODE — the internal code for the opinion value.
  • OPINION_COMPONENT_ID — reference to the opinion component to which this value belongs.
  • END_DATE — effective end date controlling the active lifecycle of the value.
  • ATTACHMENT_ID and IMAGE_FILE_NAME — reference an associated attachment and its stored file name; IMAGE_FILE_NAME is the column most relevant to the user's search, supporting graphics associated with an opinion value.
  • DISPLAY_ORDER — controls the sequence in which values appear in list-of-values and report output.
  • OPINION_VALUE_NAME — the translated display name in the session language.
  • SECURITY_GROUP_ID and OBJECT_VERSION_NUMBER — support data security and concurrent update control.

Common Use Cases and Queries

Typical uses include populating opinion value lists of values, producing audit opinion reports in the user's language, and retrieving attachment or image file names tied to specific opinion values. Because the view is obsolete, validation of existence in each instance is advisable before embedding it in custom code.

Sample query to retrieve opinion values with image file names:

  • SELECT opinion_value_id, opinion_value_code, opinion_value_name, image_file_name, display_order FROM amw_opinion_values_vl WHERE image_file_name IS NOT NULL ORDER BY display_order;

Sample query filtered by component:

  • SELECT opinion_value_id, opinion_value_name, display_order FROM amw_opinion_values_vl WHERE opinion_component_id = :component_id AND (end_date IS NULL OR end_date > SYSDATE) ORDER BY display_order;