Search Results non_serialized_unit_id




Overview
Explore in AI Chat

Overview

The CUN_NON_SERIALIZED_UNITS table is a data object within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically belonging to the CUN (Network Logistics - NATS) module. As indicated by its description, it serves as the central repository for tracking non-serialized inventory units. These are items managed by quantity rather than by unique serial numbers. Critically, the provided ETRM metadata explicitly states this module and table are "obsolete" and "Not implemented in this database." This indicates that while the table's structure is defined in the data dictionary, it is not populated with transactional data in a standard, active deployment. Its historical role was to manage unit-level details for non-serialized assets within the logistics flow, linking inventory items, locations, and financial asset distributions.

Key Information Stored

Based on the primary and foreign key relationships documented, the table's structure was designed to store critical identifiers that link a non-serialized unit to other core EBS entities. The primary key is NON_SERIALIZED_UNIT_ID. Essential foreign key columns include ITEM_ID and ORGANIZATION_ID, linking to MTL_SYSTEM_ITEMS_B to define the inventory item and its owning organization. The HZ_LOCATION_ID links to CUN_LOCATIONS, storing the physical or logical location of the unit. For integration with Fixed Assets, the FA_DISTRIBUTION_ID references FA_DISTRIBUTION_HISTORY. The LAST_TRANSACTION_ID points to CUN_TRANSACTIONS, maintaining a log of the most recent activity performed on the unit.

Common Use Cases and Queries

Given the object's obsolete status and non-implementation, direct operational use cases are not applicable in a live environment. Its primary contemporary use would be for historical data analysis or during support for legacy system migrations. A sample analytical query might involve a LEFT JOIN to investigate potential data relationships, though no rows would be returned in a standard instance:

  • Identifying Units by Item: SELECT nsu.NON_SERIALIZED_UNIT_ID, msib.SEGMENT1 ITEM_CODE FROM CUN_NON_SERIALIZED_UNITS nsu LEFT JOIN MTL_SYSTEM_ITEMS_B msib ON nsu.ITEM_ID = msib.INVENTORY_ITEM_ID AND nsu.ORGANIZATION_ID = msib.ORGANIZATION_ID;
  • Linking to Transaction History: SELECT nsu.NON_SERIALIZED_UNIT_ID, ct.TRANSACTION_TYPE FROM CUN_NON_SERIALIZED_UNITS nsu LEFT JOIN CUN_TRANSACTIONS ct ON nsu.LAST_TRANSACTION_ID = ct.TRANSACTION_ID;

Related Objects

The table is integrated into a specific, obsolete data model within the CUN module. Its key relationships, as defined by foreign keys, are:

  • MTL_SYSTEM_ITEMS_B: Provides the master definition of the inventory item.
  • CUN_LOCATIONS: Defines the location where the unit is stored or used.
  • CUN_TRANSACTIONS: References the last transaction that modified the unit's state.
  • FA_DISTRIBUTION_HISTORY: Links the physical unit to its corresponding financial asset distribution record.
  • CUN_REDO_LOG: This table references CUN_NON_SERIALIZED_UNITS via its CUN_UNIT_ID column, suggesting a logging or audit mechanism for unit changes.