Search Results hazardous_information

Overview

The APPS.EGO_GTIN_HAZMAT_ATTRS_V view is a reporting and integration artifact within Oracle E-Business Suite that consolidates Global Trade Item Number (GTIN) identifiers with hazardous materials (hazmat) attribute data for inventory items. It resides in the APPS schema and is part of the Product Information Management (PIM) / Item Management layer, specifically the attribute framework administered by the EGO (Engineering/Item) schema. In EBS 12.1.1 and 12.2.2, this view serves as a convenient, join-ready projection that returns the hazmat classification attributes an item carries at the master organization level, keyed to both the inventory item and its GTIN cross-reference.

The view is particularly relevant when users search for hazardous_information, because its definition explicitly filters the attribute group named Hazardous_Information from the multi-attribute value tables. Rather than querying the EGO attribute framework directly, consumers can select from this view to obtain dangerous goods data without reconstructing the attribute-group lookup logic.

Underlying Base Objects

The view is defined over the following documented base objects:

• MTL_SYSTEM_ITEMS_B (SYNONYM) — the item master, providing INVENTORY_ITEM_ID, ORGANIZATION_ID, and PRIMARY_UOM_CODE.
• MTL_CROSS_REFERENCES (SYNONYM) — supplies the GTIN value via CROSS_REFERENCE, restricted to CROSS_REFERENCE_TYPE = 'GTIN' and matched to the item's primary UOM.
• EGO_ITM_GTN_MUL_ATTRS_VL (VIEW) — the multi-attribute value view holding the actual hazmat attribute values, joined on item and organization.
• MTL_PARAMETERS (SYNONYM) — used to constrain the query to the master organization by requiring MP.ORGANIZATION_ID = MP.MASTER_ORGANIZATION_ID.
• EGO_ATTR_GROUPS_V (VIEW) — referenced in the scalar subquery that resolves the attr_group_id for attribute group type EGO_ITEM_GTIN_MULTI_ATTRS and name Hazardous_Information under application_id = 431.

Joins link items to their multi-attribute values, to the GTIN cross-reference at the primary UOM, and restrict the result set to the master organization, so only master-level hazmat data is returned.

Key Columns

• INVENTORY_ITEM_ID, ORGANIZATION_ID — item and organization keys.
• GLOBAL_TRADE_ITEM_NUMBER — the GTIN sourced from MXR.CROSS_REFERENCE.
• CLASS_OF_DANGEROUS_CODE — the dangerous goods class.
• DANGEROUS_GOODS_MARGIN_NUMBER — margin/qualifier number for the dangerous goods entry.
• DANGEROUS_GOODS_HAZARDOUS_CODE — the hazardous code designation.
• DANGEROUS_GOODS_PACK_GROUP — packing group classification.
• DANGEROUS_GOODS_REG_CODE — regulatory code for dangerous goods.
• DANGEROUS_GOODS_SHIPPING_NAME — the official shipping name.
• UNITED_NATIONS_DANG_GOODS_NO — the UN number.
• FLASH_POINT_TEMP, UOM_FLASH_POINT_TEMP — flash point temperature and its unit of measure.
• DANGEROUS_GOODS_TECHNICAL_NAME — the technical name of the substance.

Common Use Cases and Queries

Typical uses include hazmat compliance reporting, item data extraction for logistics and shipping systems, and integration feeds requiring GTIN-to-dangerous-goods mappings. A representative query follows:

SELECT inventory_item_id,
       organization_id,
       global_trade_item_number,
       dangerous_goods_united_nations_dang_goods_no,
       dangerous_goods_shipping_name,
       class_of_dangerous_code
FROM   apps.ego_gtin_hazmat_attrs_v
WHERE  organization_id = :p_org_id
AND    inventory_item_id = :p_item_id;

Because the view already constrains the master organization and the Hazardous_Information attribute group, consumers avoid duplicating the EGO attribute-group resolution logic and can reliably retrieve hazmat attributes alongside the item's GTIN.