Results for “opinion_component_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The AMW_OPINION_COMPONTS_B table is the base (non-translated) table for Opinion Components within the Oracle E-Business Suite AMW — Internal Controls Manager product. Opinion Components define the discrete building blocks or criteria that comprise an overall opinion type, allowing an organization to structure how audit, control, and compliance opinions are assembled and evaluated. Each row represents one component belonging to a parent opinion type, and the base table holds the language-independent attributes, while user-facing descriptive text is stored separately in the translation table.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as hub-leaning. The table functions as a durable identity anchor for opinion components, keyed by a single surrogate identifier, and is heavily referenced by dependent detail and value tables. This classification is a heuristic suggestion rather than a documented Oracle architecture statement.

Key Information Stored

The table contains 11 documented columns. The most significant are:

• OPINION_COMPONENT_ID — the surrogate primary key, enforced by AMW_OPINION_COMPONTS_B_PK and additionally covered by the unique index AMW_OPINION_COMPONTS_B_U1. This is the single business-key candidate documented for the table.
• OPINION_COMPONENT_CODE — the user-assigned short code identifying the component, typically used in reporting and integration.
• OBJECT_OPINION_TYPE_ID — foreign key linking the component to its parent opinion type in AMW_OBJECT_OPINION_TYPES.
• PAGE_ORDER — controls the display sequence of the component on the opinion entry page.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, providing multi-tenant / operating-unit data segregation.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Application Framework (OAF) to detect concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit who-columns recording row creation and modification.

Common Use Cases and Queries

Typical usage centers on retrieving the definition of an opinion component along with its translated name and its associated opinion values.

• Listing components for a given opinion type, ordered by page:

  SELECT b.opinion_component_id, b.opinion_component_code, t.opinion_component_name
  FROM   amw_opinion_componts_b b,
         amw_opinion_componts_tl t
  WHERE  b.opinion_component_id = t.opinion_component_id
  AND    t.language = USERENV('LANG')
  AND    b.object_opinion_type_id = :type_id
  ORDER BY b.page_order;

• Security-scoped reporting by joining to FND_SECURITY_GROUPS on SECURITY_GROUP_ID.
• Identifying which components have associated opinion values via AMW_OPINION_VALUES_B.
• Reconciliation queries comparing component definitions against opinion details recorded in AMW_OPINION_DETAILS.

Related Objects

The following objects are documented as directly related through primary and foreign key relationships:

• AMW_OBJECT_OPINION_TYPES — parent table; joined on AMW_OPINION_COMPONTS_B.OBJECT_OPINION_TYPE_ID.
• AMW_OPINION_COMPONTS_TL — translation table; joined on OPINION_COMPONENT_ID.
• AMW_OPINION_DETAILS — detail records referencing the component via OPINION_COMPONENT_ID.
• AMW_OPINION_VALUES_B — permissible values for the component, joined on OPINION_COMPONENT_ID.
• AMW_OPINION_LOG_DETAILS — audit log of opinion activity, referencing OPINION_COMPONENT_ID.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID for data access control.