Results for “epc_gtin_serial”

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

Overview

MTL_CROSS_REFERENCES_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the INV (Inventory) product. Per the ETRM metadata, its documented description is limited to "10SC ONLY," indicating that the object is restricted in scope and is not a general-purpose, cross-module deliverable. It exposes item cross-reference information — the alternate identifiers, manufacturer part numbers, and customer or vendor references that a company maintains against an inventory item — together with descriptive context drawn from the item master, organization, unit-of-measure, and revision tables.

The view is defined over MTL_CROSS_REFERENCES_VL, the translatable (VL) layer of the cross-references entity. As a consequence, it inherits row-level and language-handling attributes from that underlying VL object. Because the view's purpose is presentation and decoding rather than transaction processing, it is intended primarily for reporting, ad hoc inquiry, and integration extraction where a denormalized, human-readable cross-reference record is required. In both 12.1.1 and 12.2.2 the object resides in the APPS schema and is reported as VALID.

Underlying Base Objects

The documented referenced base objects are: HR_GENERAL (PACKAGE), HR_SECURITY (PACKAGE), MTL_CROSS_REFERENCES_VL (VIEW), MTL_ITEM_REVISIONS_B (SYNONYM), MTL_PARAMETERS (SYNONYM), MTL_SYSTEM_ITEMS_B_KFV (VIEW), MTL_SYSTEM_ITEMS_TL (SYNONYM), MTL_UNITS_OF_MEASURE_TL (SYNONYM), and ORG_ORGANIZATION_DEFINITIONS (VIEW).

The view text confirms these relationships. MTL_CROSS_REFERENCES_VL supplies the driving cross-reference rows (inventory item, organization, cross-reference type and value, UOM code, revision, EPC/GTIN serial, source system, and effective dates). MTL_SYSTEM_ITEMS_B_KFV provides the concatenated segment string for the item, while MTL_SYSTEM_ITEMS_TL contributes the language-specific item description. ORG_ORGANIZATION_DEFINITIONS supplies the organization name and code. MTL_UNITS_OF_MEASURE_TL is joined on the UOM code with the current session language, and MTL_ITEM_REVISIONS_B provides revision context. The presence of HR_GENERAL and HR_SECURITY in the dependency list reflects the standard Oracle Applications security model — organization and item access is filtered through these packages, which is typical of inventory reporting views used in a multi-org environment.

Key Columns

• ROW_ID, CROSS_REFERENCE_ID — Internal unique identifiers for the cross-reference record.
• INVENTORY_ITEM_ID, ORGANIZATION_ID — The item and organization that the cross-reference applies to; ORGANIZATION_ID is mandatory in the view's join logic.
• CROSS_REFERENCE_TYPE, CROSS_REFERENCE — The category (for example manufacturer part number or customer reference) and the actual reference value.
• INV_ITEM_CONCAT_SEGS — The concatenated item key flexfield segments, the most familiar item identifier for end users.
• ITEM_DESCRIPTION — The language-specific description from MTL_SYSTEM_ITEMS_TL.
• ORGANIZATION_NAME, ORGANIZATION_CODE — Organization descriptors from ORG_ORGANIZATION_DEFINITIONS.
• UOM_CODE, UNIT_OF_MEASURE_TL — The unit of measure code and its translated description.
• REVISION_ID, REVISION — The item revision associated with the cross-reference.
• EPC_GTIN_SERIAL, SOURCE_SYSTEM_ID — Serialization and source-system attributes.
• START_DATE_ACTIVE, END_DATE_ACTIVE — Effective date range for the cross-reference.
• ORG_INDEPENDENT_FLAG — Indicates whether the cross-reference is defined across organizations.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1–ATTRIBUTE15 — Descriptive flexfield context and values.
• Standard WHO columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, and the program/request columns.

Common Use Cases and Queries

Typical uses include retrieving all alternate identifiers for an item, mapping manufacturer or customer part numbers back to internal items, and populating conversion or integration extracts.

A representative query returning active cross-references for a specific item is:

SELECT cross_reference_type, cross_reference, inv_item_concat_segs, item_description, organization_code, uom_code, revision, start_date_active, end_date_active FROM apps.mtl_cross_references_v WHERE inventory_item_id = :item_id AND organization_id = :org_id AND TRUNC(SYSDATE) BETWEEN NVL(start_date_active, TRUNC(SYSDATE)) AND NVL(end_date_active, TRUNC(SYSDATE));

Because the view restricts to rows where ORGANIZATION_ID is not null, it returns organization-specific cross-references only and does not surface purely organization-independent definitions on their own. Consumers should also note the "10SC ONLY" designation and the HR security dependencies, which mean results are subject to the organization and item access privileges of the querying user.