Search Results global_trade_item_number




Overview
Explore in AI Chat

Overview

The EGO_GTIN_HAZMAT_ATTRS_V view is a reporting and integration object owned by the APPS schema in Oracle E-Business Suite, belonging to the EGO – Advanced Product Catalog product family. Its stated purpose is to expose hazardous information associated with a Global Trade Item Number (GTIN) attribute set. The view joins core inventory item definitions with cross-reference data, hazardous material multi-attribute values, and organization parameters to produce a single denormalized result set.

For users searching on "global_trade_item_number", this view is significant because it surfaces the GTIN directly as the GLOBAL_TRADE_ITEM_NUMBER column, alongside the dangerous goods attributes held against the item. This makes the view valuable for supply chain, trade compliance, and logistics initiatives that must associate a scannable item identifier with regulated hazardous material characteristics such as UN numbers, packing groups, and flash points.

Underlying Base Objects

ETRM 12.2.2 documents the following referenced base objects, all resolved through APPS:

The view therefore inherits its scope from the intersection of item master data, GTIN cross-references, and the hazardous attribute group defined in the Advanced Product Catalog.

Key Columns

Common Use Cases and Queries

Typical uses include hazardous material reporting, shipping document preparation, and downstream integration with compliance systems. A basic query retrieves GTIN and hazardous attributes for a given item and organization:

  • SELECT GLOBAL_TRADE_ITEM_NUMBER, DANGEROUS_GOODS_SHIPPING_NAME, UNITED_NATIONS_DANG_GOODS_NO, DANGEROUS_GOODS_PACK_GROUP FROM EGO_GTIN_HAZMAT_ATTRS_V WHERE INVENTORY_ITEM_ID = :item_id;
  • Filtering by organization to enumerate all hazardous items carrying GTINs within a warehouse.
  • Joining the view back to MTL_SYSTEM_ITEMS_B for concatenated item descriptions.

Because the view enforces master-organization parameters and the GTIN cross-reference type, results remain bounded to properly configured items.