Search Results xnc_item_type_v




Overview
Explore in AI Chat

Overview

XNC_ITEM_TYPE_V is a reporting view belonging to the XNC — Sales for Communications product family, a module that is documented as obsolete in Oracle E-Business Suite. The view retrieves the Communications item type together with other item attributes for a given Inventory Item and Organization. Its principal output is a derived classification that distinguishes recurring items from non-recurring items, determined through the unit of measure class assigned to the item's primary UOM.

Because the view joins item master data to unit of measure and lookup information, it functions as a denormalized, ready-to-query source for reporting and integration requirements that must present item type semantics alongside core inventory attributes such as the shippable item flag and the customer order enabled flag. Users searching for shippable_item_flag will find that XNC_ITEM_TYPE_V exposes this column directly, making the view a convenient single source for combined item type and fulfillment attribute reporting.

Underlying Base Objects

The documented view text defines XNC_ITEM_TYPE_V over four referenced objects:

  • MTL_SYSTEM_ITEMS_VL MSI — the item master view, supplying organization, item identifiers, item name, description, shippable flag, customer order enabled flag, and primary UOM code.
  • MTL_UNITS_OF_MEASURE_VL MTLUM — the units of measure view, supplying UOM_CLASS, which drives the derived ITEM_TYPE value.
  • FND_LOOKUP_VALUES_VL LKPR — lookup values filtered to view application 532 and lookup type XNC_ITEM_TYPE with lookup code RECURRING.
  • FND_LOOKUP_VALUES_VL LKPN — lookup values filtered to view application 532 and lookup type XNC_ITEM_TYPE with lookup code NON_RECURRING.

The two lookup joins act as existence filters against the XNC_ITEM_TYPE lookup definition rather than as columns in the select list. The item master and UOM views are joined by matching MTL_SYSTEM_ITEMS_VL.PRIMARY_UOM_CODE to MTL_UNITS_OF_MEASURE_VL.UOM_CODE. The ETRM metadata notes that the view is not implemented in the reference database and that no base objects are separately documented; the view text above is the authoritative definition.

Key Columns

  • ORGANIZATION_ID — inventory organization identifier for the item record.
  • INVENTORY_ITEM_ID — unique inventory item identifier.
  • ITEM_NAME — the padded concatenated segments of the item, presented as the formatted item name.
  • ITEM_DESCRIPTION — the item description from the item master.
  • ITEM_TYPE and ITEM_TYPE_NAME — both derived identically using DECODE on UPPER(MTLUM.UOM_CLASS). A UOM class of TIME yields RECURRING; any other class yields NON-RECURRING.
  • SHIPPABLE_ITEM_FLAG — indicates whether the item is shippable, sourced directly from the item master.
  • CUSTOMER_ORDER_ENABLED_FLAG — indicates whether the item may be placed on customer orders.

Common Use Cases and Queries

The view supports reporting that must reconcile item type classification with order and shipping attributes, particularly for communications industry item catalogs where recurring (time-based) services are distinguished from non-recurring goods and services.

SELECT organization_id,
       inventory_item_id,
       item_name,
       item_type,
       shippable_item_flag,
       customer_order_enabled_flag
FROM   xnc_item_type_v
WHERE  organization_id = :org_id
AND    shippable_item_flag = 'Y';

A second common pattern filters on the derived classification to isolate recurring items available for customer orders. Because the view applies the XNC_ITEM_TYPE lookup filters internally, callers should not re-apply those lookup conditions. Given the obsolete status of the XNC module, implementations on 12.1.1 and 12.2.2 should confirm the view's presence in the target instance before relying on it, and prefer direct queries against MTL_SYSTEM_ITEMS_VL and MTL_UNITS_OF_MEASURE_VL where the derived item type is not required.