Search Results opinion_value_code_name

Overview

AMW_OPINIONS_V is a reporting view owned by the APPS schema within the Oracle E-Business Suite module AMW – Internal Controls Manager (ICM). Its documented description is simply “Opinions View,” and the object carries a VALID status in the ETRM 12.1.1 / 12.2.2 metadata. The view consolidates opinion records captured against control objects so that assessments, audit results, and their associated authors can be reported in a denormalized, ready-to-query form.

In the ICM data model, opinions are stored in normalized transactional tables: an opinion header (AMW_OPINIONS), the object-to-opinion-type linkage (AMW_OBJECT_OPINION_TYPES), opinion type definitions (AMW_OPINION_TYPES_B), opinion component definitions (AMW_OPINION_COMPONTS_B), opinion detail rows (AMW_OPINION_DETAILS), and opinion value lookups (AMW_OPINION_VALUES_B / AMW_OPINION_VALUES_TL). AMW_OPINIONS_V joins these together and resolves the “OVERALL” opinion component into a human-readable audit result, making it the natural reporting surface for internal control assessments rather than the base tables. It functions as a read-only integration and reporting layer exposed to BI Publisher, OBIEE/OBIA, and custom SQL.

Underlying Base Objects

The ETRM metadata documents no referenced base objects, but the view text embedded in the documentation defines its FROM clause explicitly. AMW_OPINIONS_V is defined over:

• AMW_OPINIONS (AO) — the opinion header table and primary driver of the query.
• AMW_OBJECT_OPINION_TYPES (AOOT) and AMW_OPINION_TYPES_B (AOT) — resolve the opinion type code (e.g., EFFECTIVE).
• FND_OBJECTS (FO) — supplies the OBJ_NAME of the object an opinion applies to.
• AMW_OPINION_VALUES_B (AOVB) and AMW_OPINION_VALUES_TL (AOVTL) — provide the opinion value code and its translated name, joined by LANGUAGE = USERENV('LANG').
• AMW_OPINION_DETAILS and AMW_OPINION_COMPONTS_B — correlated subqueries restrict results to the component with OPINION_COMPONENT_CODE = 'OVERALL'.
• FND_USER (FU), PER_ALL_PEOPLE_F (PAPF) — resolve the authoring user to an employee and full name.

Notably, the join to PER_ALL_PEOPLE_F applies TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE, so only the currently effective person record is returned. The view also references the profile option AMW_OPINION_DISPLAY_OPTION via FND_PROFILE.VALUE, which influences image resolution for the EFFECTIVE opinion value.

Key Columns

• OPINION_SET_ID, OPINION_ID, OBJECT_OPINION_TYPE_ID — keys linking an opinion to its set, definition, and object-opinion-type context.
• OBJECT_NAME — the FND_OBJECTS name of the entity being assessed.
• OPINION_TYPE_CODE — the code identifying the type of opinion (e.g., EFFECTIVE).
• PK1_VALUE through PK8_VALUE — the flexible key segments identifying the specific object instance.
• AUDIT_RESULT / AUDIT_RESULT_CODE — the translated and code forms of the overall opinion value.
• AUDIT_RESULT_IMAGE_ID / AUDIT_RESULT_IMAGE_NAME — attachment/image identifiers resolved through NVL fallbacks to AMW_OPINION_VALUE_CODES.
• AUTHOR, AUTHORED_BY, AUTHORED_DATE — the person who authored the opinion.
• PARTY_ID — the party associated with the opinion.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, SECURITY_GROUP_ID, OBJECT_VERSION_NUMBER — standard audit and multi-org columns.

Common Use Cases and Queries

The view is typically queried for internal control dashboards, audit opinion listings, and integration extracts. A representative query returns the overall audit result per object instance:

• SELECT OBJECT_NAME, OPINION_TYPE_CODE, AUDIT_RESULT, AUTHOR, AUTHORED_DATE FROM AMW_OPINIONS_V;
• Filter to a specific result: ... WHERE AUDIT_RESULT_CODE = 'EFFECTIVE';
• Restrict by object instance using PK columns: ... WHERE PK1_VALUE = :p_value;
• Scope to a security group: ... WHERE SECURITY_GROUP_ID = :sg_id;

As a locale-sensitive, profile-dependent view, results vary by the session language and the AMW_OPINION_DISPLAY_OPTION setting, which should be accounted for in any reporting or integration logic.