Search Results opinion_value_code_name




Overview
Explore in AI Chat

Overview

APPS.AMW_OPINIONS_V is a reporting and integration view within the Oracle E-Business Suite ETRM (Enterprise Transaction and Records Management) module, formerly delivered under the AMW (Approvals Management) schema family. The view exposes opinion records — human or system evaluations attached to EBS objects — in a denormalized, human-readable form suitable for concurrent program reports, OAF pages, and downstream integrations. Rather than requiring the caller to join the opinions header, object opinion types, opinion values, language translations, and HR person data manually, the view performs these joins internally and returns a single row per opinion with resolved author name, audit result label, and audit result codes.

The object is of particular interest because the user search term amw_opinion_display_option appears directly in the view definition. The profile option AMW_OPINION_DISPLAY_OPTION controls whether the audit result is rendered as an image file or as text. This conditional logic is embedded in the view, meaning the view's output can vary at runtime based on the current profile value.

Underlying Base Objects

The ETRM metadata lists no explicitly documented referenced base objects, but the view text itself enumerates them unambiguously:

Key Columns

Common Use Cases and Queries

Typical usages include audit-result reports, approval workflow summaries, and integrations that need a display-ready opinion value. A basic query filtering by object and date:

SELECT opinion_id, object_name, opinion_type_code, audit_result, author, authored_date FROM apps.amw_opinions_v WHERE object_name = 'MY_OBJECT' AND trunc(authored_date) >= trunc(sysdate)-30;

To surface image references for graphical display:

SELECT opinion_id, audit_result, audit_result_image_name FROM apps.amw_opinions_v WHERE opinion_type_code = 'MY_TYPE';

Because the view respects the AMW_OPINION_DISPLAY_OPTION profile setting, callers should confirm whether the target environment is configured for image or text output before relying on image columns.