Search Results amw_opinion_value_codes_u1

Overview

AMW.AMW_OPINION_VALUE_CODES is a reference (lookup) table in the Oracle E-Business Suite Applications Marketing (AMW) product schema. It defines the discrete codes used to qualify how a captured opinion value should be interpreted by the end user. Each row describes a named opinion value code, together with optional visual and file references used to render or annotate that code in the application UI. According to the ETRM documentation, four distinct codes are seeded: EFFECTIVE, SOMEWHAT_EFFECTIVE, NEARLY_INEFFECTIVE, and INEFFECTIVE. The application treats every code except EFFECTIVE as indicating a deficient state, which makes this table a small but semantically important control point for downstream opinion scoring and reporting logic.

The object resides in tablespace APPS_TS_TX_DATA with PCT Free 10 and holds 11 documented columns. Based on the Data Vault classification heuristic derived from its FK structure, the table is modeled as standalone — it is a small, slowly-changing reference/hub-style entity rather than a transaction or link table. It does not reference any database object (aside from the standard SECURITY_GROUP_ID foreign key to FND_SECURITY_GROUPS), but it is referenced by opinion materialized views in the same schema.

Key Information Stored

The most significant columns are:

• OPINION_VALUE_CODE_ID (NUMBER) — the surrogate primary key, enforced by AMW_OPINION_VALUE_CODES_PK and the unique index AMW_OPINION_VALUE_CODES_U2. This is the value most commonly searched for as opinion_value_code_id.
• OPINION_VALUE_CODE_NAME (VARCHAR2(30)) — the business-key candidate, unique via AMW_OPINION_VALUE_CODES_U1. Holds values such as the four seeded codes above.
• ATTACHMENT_ID (NUMBER) — identifies an attachment associated with the opinion value code.
• IMAGE_FILE_NAME (VARCHAR2(240)) — the OA_MEDIA image file used to visually represent the code.
• Standard Who columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — for auditing.
• SECURITY_GROUP_ID (NUMBER) — an FK to FND_SECURITY_GROUPS, supporting multi-organization/security partitioning.
• OBJECT_VERSION_NUMBER (NUMBER) — standard optimistic-locking column for the OAF/BC4J persistence layer.

Common Use Cases and Queries

Typical use cases include resolving a numeric OPINION_VALUE_CODE_ID to its human-readable name, filtering for deficient states, and joining opinion result data to classify effectiveness. A common lookup query is:

SELECT OPINION_VALUE_CODE_ID,
       OPINION_VALUE_CODE_NAME,
       IMAGE_FILE_NAME
FROM   AMW.AMW_OPINION_VALUE_CODES
WHERE  OPINION_VALUE_CODE_NAME <> 'EFFECTIVE';

Reporting logic in opinion materialized views joins this table to translate stored identifiers into descriptive labels and to flag rows that are not EFFECTIVE. The ATTACHMENT_ID and IMAGE_FILE_NAME columns support UI rendering and attachment retrieval during opinion review.

Related Objects

Per the dependency metadata, the following objects reference or depend on AMW_OPINION_VALUE_CODES:

• AMW.AMW_OPINION_MV — a materialized view joining opinion records to this code (on OPINION_VALUE_CODE_ID).
• AMW.AMW_OPINION_LOG_MV — a materialized view capturing opinion log data referencing the code.
• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID.
• The base table itself is referenced by the two MVs above, confirming it as an upstream lookup source in the AMW opinion reporting stack.