Search Results bom_attrs_v




Overview
Explore in AI Chat

Overview

BOM_ATTRS_V is an Oracle Application Object Library (APPS) view within the Bills of Material (BOM) product family. As documented in the ETRM reference for Oracle E-Business Suite 12.1.1 and 12.2.2, the view "displays the BOM attributes." It functions as a filtered projection of the Extensible Attribute Framework (Ego) attribute metadata, exposing only those attribute definitions that belong to the BOM component management and component base attribute groups. In practice, the view bridges generic attribute-registry metadata and the specific descriptive-flexfield-style columns that BOM uses for component-level attributes, making it useful for reporting, integration mapping, and diagnostics where the relationship between a displayed attribute name and its underlying database column or interface table must be resolved. Because it is a view rather than a table, it carries no independent storage; its results are derived at query time from the underlying Ego views and the application ID filter for BOM.

Underlying Base Objects

The view is defined over three Ego attribute views — EGO_ATTRS_V, EGO_ATTR_GROUPS_V, and EGO_ATTR_GROUP_TYPES_V — joined to a DUAL-derived inline set that supplies interface table names. The documented base objects are:

  • EGO_ATTRS_V (VIEW) — supplies individual attribute rows such as ATTR_NAME, ATTR_DISPLAY_NAME, and DATABASE_COLUMN.
  • EGO_ATTR_GROUPS_V (VIEW) — supplies attribute group metadata, including ATTR_GROUP_DISP_NAME and ATTR_GROUP_NAME.
  • EGO_ATTR_GROUP_TYPES_V (VIEW) — supplies the attribute group type definition used to correlate the groups.
  • DUAL (SYNONYM) — used to union the two BOM attribute group types with their corresponding interface table names.

The defining SQL restricts results to attribute group types 'BOM_COMPONENTMGMT_GROUP' and 'BOM_COMPONENT_BASE', and applies the filter ATTR.APPLICATION_ID = 702, the application identifier for Bills of Material. The inline union maps 'BOM_COMPONENTMGMT_GROUP' to the interface table BOM_INV_COMPS_EXT_INTERFACE and 'BOM_COMPONENT_BASE' to BOM_INVENTORY_COMPS_INTERFACE. Output is ordered by attribute group type then attribute group name.

Key Columns

  • ATTR_GROUP_NAME — the internal name of the attribute group to which the attribute belongs.
  • ATTR_GROUP_DISP_NAME — the user-facing display name of that attribute group.
  • ATTR_NAME — the internal name of the individual attribute.
  • ATTR_DISPLAY_NAME — the display label presented for the attribute in the BOM interface.
  • DATABASE_COLUMN — the physical database column that stores the attribute value.
  • EXT_TABLE_NAME — the extension table associated with the attribute.
  • INTF_TABLE_NAME — the interface table used for loading the attribute, resolved as BOM_INV_COMPS_EXT_INTERFACE or BOM_INVENTORY_COMPS_INTERFACE.
  • ATTR_GROUP_ID — the surrogate identifier of the attribute group.
  • ATTR_GROUP_TYPE — the group classification, limited to the two BOM component group types.

Common Use Cases and Queries

Typical uses include mapping display labels to physical columns for interface or conversion development, validating which attributes are exposed for a given component group, and reconciling BOM interface staging data against the attribute registry. A representative query follows:

  • SELECT attr_group_name, attr_display_name, database_column, ext_table_name, intf_table_name FROM apps.bom_attrs_v WHERE attr_group_type = 'BOM_COMPONENT_BASE' ORDER BY attr_group_name, attr_display_name;
  • SELECT attr_group_type, attr_group_disp_name, attr_name, database_column FROM apps.bom_attrs_v ORDER BY attr_group_type, attr_group_name;

Because the view is filtered to application 702 and the two BOM component group types, it should not be used as a general-purpose attribute catalog; queries requiring attributes from other product groups must target the underlying EGO_ATTRS_V view directly.