Search Results ego_item_gtn_attrs_b_u2

Overview

EGO.EGO_ITEM_GTN_ATTRS_B is a transactional attribute table within the Oracle E-Business Suite EGO (Product Information Management / Item Master) schema. It stores the single-row, untranslated Global Data Synchronization Network (GDSN) attributes for an item. Each row captures the GDSN attribute values that apply to a specific item and inventory organization combination, supporting the item publication and data synchronization processes used with trading partners. The table resides in the APPS_TS_TX_DATA tablespace with a PCT Free of 10, and its indexes are held in APPS_TS_TX_IDX.

Under the heuristic Data Vault classification supplied in the metadata, this object is modeled as a standalone structure. From a Data Vault perspective, this suggests the table behaves primarily as a satellite-like attribute store keyed off item and organization, rather than acting as a hub or link connecting multiple business entities. The classification is a modeling suggestion derived from the foreign-key topology observed in the object definition.

Key Information Stored

The table exposes 111 documented columns. The most significant identifiers and descriptive attributes are summarized below.

• EXTENSION_ID (NUMBER, 15) — Unique identifier for the attribute row; the surrogate primary key candidate enforced by unique index EGO_ITEM_GTN_ATTRS_B_U2.
• INVENTORY_ITEM_ID (NUMBER, 15) — Inventory item identifier; foreign key to MTL_SYSTEM_ITEMS_B and part of business-key candidate EGO_ITEM_GTN_ATTRS_B_U1.
• ORGANIZATION_ID (NUMBER, 15) — Organization identifier; foreign key to MTL_SYSTEM_ITEMS_B and the second column of EGO_ITEM_GTN_ATTRS_B_U1.
• ITEM_CATALOG_GROUP_ID (NUMBER, 15) — Item catalog group identifier; foreign key to MTL_ITEM_CATALOG_GROUPS_B, used for search.
• REVISION_ID (NUMBER, 15) — Item revision identifier; foreign key to MTL_ITEM_REVISIONS_B.
• IS_TRADE_ITEM_A_CONSUMER_UNIT and IS_TRADE_ITEM_A_BASE_UNIT — Flags indicating whether the item functions as a consumer unit and/or base unit for trade purposes.
• GROSS_WEIGHT and UOM_GROSS_WEIGHT — Item weight including packaging and its unit of measure.
• EFFECTIVE_DATE, CANCELED_DATE, and DISCONTINUED_DATE — Lifecycle dates including RCIR cancellation and discontinuation.
• START_AVAILABILITY_DATE_TIME and END_AVAILABILITY_DATE_TIME — Availability window for the item.
• BRAND_NAME (VARCHAR2, 50) — RCIR brand name associated with the item.
• Audit columns CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — Standard EBS who-columns tracking record creation and modification.

Common Use Cases and Queries

The table is primarily queried during item publication, GDSN synchronization, and trade-item setup reporting. Typical patterns join back to the item master and catalog groups.

• Retrieve GDSN attributes for an item/organization: SELECT * FROM EGO.EGO_ITEM_GTN_ATTRS_B WHERE INVENTORY_ITEM_ID = :item_id AND ORGANIZATION_ID = :org_id;
• Locate a specific attribute row by extension: SELECT * FROM EGO.EGO_ITEM_GTN_ATTRS_B WHERE EXTENSION_ID = :ext_id; — exploits unique index EGO_ITEM_GTN_ATTRS_B_U2.
• Validate trade-item completeness: Filter rows where key attributes such as GROSS_WEIGHT or BRAND_NAME are null, indicating incomplete publication data.
• Lifecycle reporting: Query records whose DISCONTINUED_DATE or CANCELED_DATE is populated to identify items removed from trade availability.
• Availability windows: Filter on START_AVAILABILITY_DATE_TIME and END_AVAILABILITY_DATE_TIME to report items currently available.

Because the table includes standard WHO columns, audit-oriented queries can reconstruct who last modified a given attribute set.

Related Objects

• MTL_SYSTEM_ITEMS_B — Core item master; joined on INVENTORY_ITEM_ID and ORGANIZATION_ID.
• MTL_ITEM_CATALOG_GROUPS_B — Joined on ITEM_CATALOG_GROUP_ID for catalog grouping searches.
• MTL_ITEM_REVISIONS_B — Joined on REVISION_ID for revision-level attribute resolution.
• EGO.EGO_ITEM_GTN_ATTRS_TL — The translated counterpart storing language-specific GDSN text, keyed by the same EXTENSION_ID.
• EGO_ITEM_GTN_ATTRS_B_U1 / _U2 — The unique indexes enforcing item/org and extension uniqueness.

These relationships reflect the documented foreign-key topology and the surrounding EGO item attribute model.