Search Results handling_information




Overview
Explore in AI Chat

Overview

The APPS.EGO_GTIN_HAND_INF_ATTRS_V view is a reporting and integration object in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 that exposes Global Trade Item Number (GTIN) handling information for inventory items. It is part of the EGO (Engineering/Product Information Management) product family and joins item master data, cross-reference definitions, and translated multi-attribute extensions to present handling instructions in a language-aware format.

The view is primarily consumed by downstream integration processes, GS1/GTIN data exchange utilities, label printing, and external systems that require item-level handling codes tied to a specific GTIN. Because handling instructions are captured as a multi-attribute (attribute group) extension rather than a base item attribute, they are not directly exposed on MTL_SYSTEM_ITEMS_B. This view provides that bridge, giving a flattened, query-ready projection of the handling information.

Underlying Base Objects

The view is defined over four base objects, each referenced through APPS synonyms in the documented metadata:

In addition, the view references EGO_ATTR_GROUPS_V through a correlated subquery to identify the attribute group whose ATTR_GROUP_TYPE = 'EGO_ITEM_GTIN_MULTI_ATTRS' and ATTR_GROUP_NAME = 'Handling_Information' with APPLICATION_ID = 431. This subquery filters the translated attribute rows so that only handling-instruction records are returned.

Key Columns

  • INVENTORY_ITEM_ID — unique item identifier from the item master.
  • ORGANIZATION_ID — the master organization context for the item.
  • GLOBAL_TRADE_ITEM_NUMBER — the GTIN sourced from MXR.CROSS_REFERENCE, where the cross-reference type is 'GTIN', the UOM matches the item's primary UOM, and the organization matches or is null on the item.
  • LANGUAGE — the language of the handling instruction, presented with a DECODE that maps 'US' to 'EN' for standardized language codes.
  • SOURCE_LANG — the originating (base) language of the translated attribute row, useful to distinguish translations from the source record.
  • HANDLING_INSTRUCTIONS_CODE — the actual handling instruction code value for the item, retrieved from the translated attribute table.

Common Use Cases and Queries

This view is typically used when exporting GTIN data with handling instructions for regulatory, logistics, or label compliance. A representative query retrieves handling instructions for a specific item and organization:

SELECT organization_id,
       inventory_item_id,
       global_trade_item_number,
       language,
       handling_instructions_code
  FROM apps.ego_gtin_hand_inf_attrs_v
 WHERE inventory_item_id = :item_id
   AND organization_id   = :org_id;

Integration scenarios may join the view to MTL_SYSTEM_ITEMS_VL or item description tables for enriched output, or filter on LANGUAGE = 'EN' to extract a single default translation. Because the view constrains data to master organizations via MTL_PARAMETERS, results reflect master-level item definitions rather than child organization overrides, which is important when planning downstream replication or interface loads.