Search Results opinion_component_code

Overview

AMW.AMW_OPINION_COMPONTS_B is a base (non-translated) transaction table in the Oracle E-Business Suite AMW schema, delivered under the ETRM (Enterprise Transaction and Reference Model) data model. It stores the definition of opinion components — discrete elements that complexify an opinion by capturing information about a specific aspect of the object being evaluated, certified, or otherwise assessed. In practice, the table functions as the registration point for the reusable building blocks from which an opinion type is composed, each block carrying a code that application logic, page rendering, and downstream evaluation routines can reference.

From a modeling perspective, the FK structure heuristic classifies this table as hub-leaning. It carries a single-column surrogate primary key and two outbound foreign keys (to AMW_OBJECT_OPINION_TYPES and FND_SECURITY_GROUPS), placing it as a central definition entity that other AMW opinion tables attach to. The metadata supports treating it as the hub of an opinion-component star, with dependent satellite and detail tables referencing it by identifier.

Key Information Stored

The most significant columns are:

• OPINION_COMPONENT_ID (NUMBER) — the surrogate entity identifier and the primary key of the table (AMW_OPINION_COMPONTS_B_PK). It is also the single unique-index candidate documented (AMW_OPINION_COMPONTS_B_U1), making it the join key for every dependent table.
• OPINION_COMPONENT_CODE (VARCHAR2(30)) — the user-facing business code associated with the opinion component; this is the column the searched term "opinion_component_code" resolves to and is typically the value referenced in setup, configuration, and integration logic.
• OBJECT_OPINION_TYPE_ID (NUMBER) — foreign key identifying a unique entry in AMW_OBJECT_OPINION_TYPES, establishing which opinion type the component belongs to.
• PAGE_ORDER (NUMBER) — controls the vertical position of the component on the web page used to create or modify an opinion, driving UI sequencing.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard Who columns capturing audit and attribution metadata for each row.
• SECURITY_GROUP_ID — standard column constraining row visibility within the multi-tenant security model; it is a foreign key to FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER — standard optimistic locking column used by the Oracle Forms/ADF framework to detect concurrent updates.

Translatable text for each component is not held here; it is maintained in the companion table AMW_OPINION_COMPONTS_TL, which references this table by OPINION_COMPONENT_ID.

Common Use Cases and Queries

Typical reporting and integration scenarios involve extracting component definitions for a given opinion type, reordering components within the UI, or joining component detail and values.

• Extracting a single component by business code: SELECT opinion_component_id, opinion_component_code, object_opinion_type_id FROM amw.amw_opinion_compts_b WHERE opinion_component_code = :code;
• Listing components for an opinion type in display order: filter by OBJECT_OPINION_TYPE_ID and order by PAGE_ORDER.
• Joining to AMW_OPINION_COMPONTS_TL on OPINION_COMPONENT_ID to retrieve translated component names and descriptions for locale-specific reports.
• Joining to AMW_OPINION_VALUES_B or AMW_OPINION_DETAILS on OPINION_COMPONENT_ID to report captured values against each component definition.
• Auditing definitions changed within a period using CREATION_DATE and LAST_UPDATE_DATE.

Related Objects

• AMW_OBJECT_OPINION_TYPES — parent opinion type; joined via OBJECT_OPINION_TYPE_ID.
• AMW_OPINION_COMPONTS_TL — translated component text; references OPINION_COMPONENT_ID.
• AMW_OPINION_DETAILS — per-opinion component detail records; references OPINION_COMPONENT_ID.
• AMW_OPINION_VALUES_B — stored component values; references OPINION_COMPONENT_ID.
• AMW_OPINION_LOG_DETAILS — historical component activity; references OPINION_COMPONENT_ID.
• AMW_OPINION_MV and AMW_OPINION_LOG_MV — materialized views that depend on this table for opinion reporting.
• FND_SECURITY_GROUPS — security group reference via SECURITY_GROUP_ID.