Results for “eng_web_ref_desig_v”

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

Overview

ENG_WEB_REF_DESIG_V is a read-only view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Engineering (ENG) product family. Its documented purpose is to present revised reference designators designed for use in Oracle self-service web applications. In practice, the view exposes reference designator data that has been associated with engineering change revisions, formatted so that it can be consumed directly by web-based user interfaces, Oracle Application Framework (OAF) pages, and downstream reporting or integration layers without requiring the consumer to reconstruct the joins between reference designators and revised components.

The object is documented as VALID in 12.2.2 and the column set is stable across 12.1.1 and 12.2.2, which means any custom report, ad hoc query, or interface built against it in 12.1.1 can generally be carried forward to 12.2.2 without structural change. The view is particularly relevant when a user searches for the column or concept of a component reference designator, since that field is surfaced here by its canonical name COMPONENT_REFERENCE_DESIGNATOR.

Underlying Base Objects

The view text is a four-way join across the following documented base objects:

• BOM_REFERENCE_DESIGNATORS (documented as a SYNONYM in 12.2.2) — the primary source of reference designator rows, including the designator value, the associated change notice, and the action type.
• BOM_INVENTORY_COMPONENTS (documented as a VIEW) — supplies the component sequence identifier and the revised item sequence identifier that link a designator to a specific revised component.
• ENG_REVISED_ITEMS — provides the engineering revision context and the change notice that ties a revised item to designator activity.
• MFG_LOOKUPS (documented as a VIEW) — used to translate the stored action code into a user-facing meaning, restricted to LOOKUP_TYPE = 'ENG_REF_DESIG_ACTION'.

Join conditions are defined on COMPONENT_SEQUENCE_ID between BOM_REFERENCE_DESIGNATORS and BOM_INVENTORY_COMPONENTS, on REVISED_ITEM_SEQUENCE_ID between BOM_INVENTORY_COMPONENTS and ENG_REVISED_ITEMS, and additionally on CHANGE_NOTICE between BOM_REFERENCE_DESIGNATORS and ENG_REVISED_ITEMS. The lookup join maps ML.LOOKUP_CODE = BRD.ACD_TYPE.

Key Columns

• COMPONENT_SEQUENCE_ID — the identifier of the component instance to which the reference designator applies; the principal join key back to component-level data.
• ACTION — the decoded meaning of the reference designator action, derived from MFG_LOOKUPS for lookup type ENG_REF_DESIG_ACTION (for example, add, delete, or change semantics).
• COMPONENT_REFERENCE_DESIGNATOR — the reference designator value itself, such as a schematic locator or component position on an assembly.
• REF_DESIGNATOR_COMMENT — free-text comment associated with the reference designator, useful for engineering notes captured during the change process.

Common Use Cases and Queries

Typical uses include engineering change reporting, self-service review of revised assemblies, and interfaces that feed PLM or manufacturing systems with designator-level change detail. A basic query retrieves all designators for a component sequence:

• SELECT component_sequence_id, action, component_reference_designator, ref_designator_comment FROM apps.eng_web_ref_desig_v WHERE component_sequence_id = :p_component_sequence_id;
• Searching by designator: SELECT component_sequence_id, action, component_reference_designator FROM apps.eng_web_ref_desig_v WHERE component_reference_designator = :p_ref_desig;

Because the view already resolves the lookup meaning and the revision linkage, it is the preferred source over querying BOM_REFERENCE_DESIGNATORS directly when the requirement is simply to display designator change information in a web or reporting context.