Search Results clli_code




Overview
Explore in AI Chat

Overview

CUN_ITEMS_V is a reporting view belonging to the CUN – Network Logistics – NATS product family. Within the Oracle E-Business Suite 12.1.1 and 12.2.2 environments, this component is classified as obsolete; the ETRM metadata confirms it is not implemented in the current database instance. The view presents a consolidated, denormalized picture of item unit information originating from the Network Logistics system, combining inventory item attributes with fixed asset and project accounting context. It was designed to give downstream reporting and integration processes a single read-only source for unit-level records spanning warehouses, subinventories, locators, lots, serialized and non-serialized items, and their related fixed asset assignments.

Because the underlying data model depends on custom NATS tables (CUN_NON_SERIALIZED_ITEMS_V and CUN_SERIALIZED_ITEMS_V), the view is only meaningful in environments where that legacy product has been deployed. In standard Oracle EBS installations the view will not exist or will return no rows.

Underlying Base Objects

The view text is defined as a UNION of two integration views rather than as a direct projection over base tables:

  • CUN_NON_SERIALIZED_ITEMS_V – supplies item unit rows for items not tracked by serial number.
  • CUN_SERIALIZED_ITEMS_V – supplies item unit rows for items tracked by serial number.

No base Oracle EBS tables are documented as referenced objects by the ETRM metadata. Operationally, these two source views likely resolve against CUN product tables and reference standard Oracle entities such as MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, FA_DISTRIBUTIONS, and project/task tables, but those relationships are inherited indirectly rather than declared in the CUN_ITEMS_V definition. The identical column list on both sides of the UNION ensures a stable, uniform result set for callers.

Key Columns

The column list reflects the dual inventory-and-asset nature of the view. Notable columns include:

Common Use Cases and Queries

The most frequent scenario is reconciling network inventory units against their fixed asset distributions, driven by the FA_DISTRIBUTION_ID column for which the user searched. A representative query joining the distribution to asset attributes is:

SELECT assET_number, fa_distribution_id, book_type_code,
       fixed_asset_location, inventory_org_id, locator
FROM   cun_items_v
WHERE  fa_distribution_id IS NOT NULL;

Other typical uses include locating units by organization, subinventory, or locator; listing serialized units with their serial and vendor serial numbers; and grouping units by project, task, or asset grouping element. Because the view is obsolete and not implemented in current databases, any existing query referencing it should be migrated to supported inventory and fixed asset views in EBS rather than retained in its current form.