Results for “publication_status”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

EGO_ITEM_GTIN_V is a VALID Oracle Application Object Library view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It belongs to the EGO (Advanced Product Catalog) product family and is documented in ETRM as the "View for item gtin details." The view consolidates Global Trade Item Number (GTIN) assignments for inventory items together with their governing master organization context and their trade item publication status, producing a single queryable result set suitable for reporting, data extraction, and integration interfaces that must reconcile item cross-references against master-level item attributes.

Its principal design characteristic is that it returns one row per combination of inventory item, organization, and GTIN cross-reference. Because the join path is anchored to the master organization through MTL_PARAMETERS, the view exposes only items whose organization context resolves to the master organization. This makes it a master-data-oriented view rather than a transactional one, and it is commonly used by product information management (PIM) reporting and outbound item syndication extracts.

Underlying Base Objects

The documented definition is constructed from five referenced base objects:

• MTL_CROSS_REFERENCES (SYNONYM) — the source of the GTIN value, its description, its unit of measure code, and the ORG_INDEPENDENT_FLAG. The view restricts this table with CROSS_REFERENCE_TYPE = 'GTIN'.
• MTL_SYSTEM_ITEMS_KFV (SYNONYM) — supplies the concatenated item number (ITEM_NUMBER), the organization identifier, the primary UOM code, and the trade item descriptor.
• MTL_PARAMETERS (SYNONYM) — supplies the organization and master organization identifiers, and drives the master-organization anchor condition.
• MTL_UNITS_OF_MEASURE (SYNONYM) — provides the descriptive unit of measure (UNIT_OF_MEASURE) for the item's primary UOM code.
• EGO_ITEM_GTN_ATTRS_VL (VIEW) — the Advanced Product Catalog GTIN attribute view, supplying the publication status for the item and organization.

The join keys are INVENTORY_ITEM_ID and ORGANIZATION_ID between the item key flexfield view and the GTIN attribute view, ORGANIZATION_ID to MASTER_ORGANIZATION_ID through MTL_PARAMETERS, and INVENTORY_ITEM_ID and ORGANIZATION_ID between MTL_CROSS_REFERENCES and MTL_SYSTEM_ITEMS_KFV. The cross-reference organization is resolved using NVL(MXR.ORGANIZATION_ID, MSIK.ORGANIZATION_ID), allowing organization-independent cross-references to be attributed to the item's organization. Only cross-references whose UOM_CODE equals the item's PRIMARY_UOM_CODE are returned.

Key Columns

• INVENTORY_ITEM_ID — internal identifier of the inventory item.
• ORGANIZATION_ID — organization identifier from MTL_PARAMETERS, resolved to the master organization.
• ITEM_NUMBER — concatenated item key flexfield segments (MSIK.CONCATENATED_SEGMENTS).
• MASTER_ORGANIZATION_ID — the master organization that governs the item definition.
• GTIN — the cross-reference value where CROSS_REFERENCE_TYPE is 'GTIN'.
• DESCRIPTION — description of the GTIN cross-reference.
• ORG_INDEPENDENT_FLAG — indicates whether the GTIN cross-reference applies across organizations rather than being tied to one specific organization. This is the column most frequently targeted by users searching for "org_independent_flag," since it determines sharing semantics for the GTIN assignment.
• UOM_CODE — unit of measure code on the cross-reference, constrained to the item's primary UOM.
• UNIT_OF_MEASURE — descriptive UOM name from MTL_UNITS_OF_MEASURE.
• TRADE_ITEM_DESCRIPTOR — trade item descriptor from the item master.
• PUBLICATION_STATUS — publication status from EGO_ITEM_GTN_ATTRS_VL, indicating the GTIN attribute's publication state.

Common Use Cases and Queries

Typical uses include validating GTIN coverage across the item master, auditing organization-independent GTIN assignments, and extracting GTIN plus publication status for syndication or compliance reporting. A basic listing for a specific item:

SELECT item_number, organization_id, gtin, description,
       org_independent_flag, uom_code, publication_status
FROM   apps.ego_item_gtin_v
WHERE  inventory_item_id = :p_item_id;

To isolate organization-independent GTINs, which is the pattern implied by the "org_independent_flag" search:

SELECT item_number, gtin, org_independent_flag, publication_status
FROM   apps.ego_item_gtin_v
WHERE  org_independent_flag = 'Y';

For publication reporting, filter on PUBLICATION_STATUS and join back to MTL_SYSTEM_ITEMS_KFV or EGO_ITEM_GTN_ATTRS_VL if segment-level context is required. Because the view is a join of item, cross-reference, UOM, parameter, and catalog attribute data, use it as a read-only reporting source; GTIN maintenance should be performed through the Advanced Product Catalog or item cross-reference maintenance functions that write to MTL_CROSS_REFERENCES and EGO_ITEM_GTN_ATTRS_VL.