Search Results bom_component_base

Overview

APPS.BOM_ATTRS_V is a reporting and integration view in Oracle E-Business Suite that exposes the attribute metadata used by the Bill of Materials component management framework. It resolves the descriptive attributes associated with the two Bill of Materials attribute group types — BOM_COMPONENTMGMT_GROUP and BOM_COMPONENT_BASE — and presents them alongside their display names, backing database columns, extension table names, and interface table names. The view is owned by the APPS schema and is scoped exclusively to application_id 702, which is the Bill of Materials application.

In practice, BOM_ATTRS_V functions as the metadata dictionary that describes how Bill of Materials component attributes map onto physical storage. It is the object consulted when the application needs to determine which database column or extension table holds a given attribute, and which interface table is used to load that attribute. This makes it relevant to both reporting implementations and to interface/integration development that targets the Bill of Materials component interfaces.

Underlying Base Objects

The view is defined over three EGO attribute metadata views and the DUAL synonym:

• EGO_ATTRS_V — supplies the individual attribute definitions (attribute group name, attribute name, display name, database column, and extension table name). It is restricted by application_id = 702.
• EGO_ATTR_GROUPS_V — supplies attribute group metadata, including the group display name, group identifier, and group type. It is joined to EGO_ATTRS_V on attribute group name.
• EGO_ATTR_GROUP_TYPES_V — supplies the attribute group type definitions and is joined on attribute group type.
• DUAL — used in an inline UNION ALL construct that hard-codes the mapping between each Bill of Materials attribute group type and its corresponding interface table name.

The join establishes a three-way relationship: attributes are matched to their group by name, groups are matched to their group type, and the inline DUAL subquery matches each group type to its interface table. The result set is filtered to the two Bill of Materials group types and ordered by attribute group type and attribute group name. Because all three EGO objects are themselves views, BOM_ATTRS_V is effectively a metadata layer built over the Enterprise Object attribute framework rather than over base transactional tables.

Key Columns

• ATTR_GROUP_NAME — the internal name of the attribute group.
• ATTR_GROUP_DISP_NAME — the user-facing display name of the attribute group.
• ATTR_NAME — the internal name of the individual attribute.
• ATTR_DISPLAY_NAME — the user-facing display name of the attribute.
• DATABASE_COLUMN — the physical column that stores the attribute value.
• EXT_TABLE_NAME — the extension table that holds the attribute where storage is externalized.
• INTF_TABLE_NAME — the interface table used to load the attribute. This resolves to BOM_INV_COMPS_EXT_INTERFACE for the BOM_COMPONENTMGMT_GROUP type and BOM_INVENTORY_COMPS_INTERFACE for the BOM_COMPONENT_BASE type.
• ATTR_GROUP_ID — the surrogate identifier of the attribute group.
• ATTR_GROUP_TYPE — the group type discriminator, restricted to the two Bill of Materials values.

Common Use Cases and Queries

The view is typically queried to discover attribute metadata prior to building interface loads or reporting extracts. A common pattern lists all attributes for the component management group:

SELECT attr_name, attr_display_name, database_column, ext_table_name, intf_table_name FROM apps.bom_attrs_v WHERE attr_group_type = 'BOM_COMPONENTMGMT_GROUP';

A second pattern identifies every interface table referenced by the Bill of Materials attribute metadata:

SELECT DISTINCT intf_table_name FROM apps.bom_attrs_v;

Developers also use the view to resolve an attribute's physical storage location before writing queries against the underlying column or extension table, and integration developers use INTF_TABLE_NAME to determine the correct staging table for a given attribute during component import.