Search Results cross_ref_status




Overview
Explore in AI Chat

Overview

OE_ITEMS_V is a dictionary view owned by the APPS schema within the Oracle Order Management (ONT) product. Its documented purpose is to present a unified, union-style result set combining inventory items, customer items, and generic items for use in order-entry and pricing flows. In Oracle EBS 12.1.1 and 12.2.2, the view serves as the resolution layer that Order Management forms, pricing engines, and customer-item substitution logic consult to translate between a sold-to organization's own part numbers and the internal master-organization inventory item. Because customer items (MTL_CUSTOMER_ITEMS) and their cross-references (MTL_CUSTOMER_ITEM_XREFS) are customer-specific while inventory items are defined at the master organization, the view provides a single denormalized surface where item number, description, item status, cross-reference rank, and address context are presented together.

Underlying Base Objects

The documented base objects referenced by the view span Order Management, Inventory, Receivables, and Trading Community (HZ) schemas:

Outer joins (+) on the HZ and lookup objects allow customer items without a fully populated ship-to or lookup to remain visible.

Key Columns

Common Use Cases and Queries

Typical scenarios include customer-item substitution during order entry, validation of cross-references during import, and reporting on item definition level. A representative query filtering on the searched attribute:

  • SELECT item, inventory_item, item_status, item_definition_level FROM oe_items_v WHERE sold_to_org_id = :p_customer_id AND item_definition_level = 'CUSTOMER';
  • SELECT item, inventory_item, rank FROM oe_items_v WHERE organization_id = :p_org_id ORDER BY item, rank;
  • SELECT item, inventory_item FROM oe_items_v WHERE item_status = 'ACTIVE' AND cross_ref_status = 'ACTIVE';

Because the view is read-only and union-based, it is best used for query and validation rather than as a DML target.