Search Results out_of_service




Overview
Explore in AI Chat

Overview

CUN_ITEM_NETWORK_UNITS_V is a reporting view shipped with the Oracle E-Business Suite Network Logistics module (product code CUN), which is part of the NATS (Network Asset Tracking System) family. The view presents network unit information originating from the Network Logistics system, exposing attributes of communications network equipment tracked at the unit level. In EBS 12.1.1 and 12.2.2, this object is classified as obsolete and documented as Not implemented in this database, meaning that in a standard installation the view is not created or, where present, remains unsupported. Its principal role historically was to surface network-unit status — particularly units flagged as IN_SERVICE, OUT_OF_SERVICE, or RETIRED — to downstream reporting, integration, and asset-reconciliation processes that needed a denormalized, business-friendly picture of deployed network equipment.

Underlying Base Objects

Per the ETRM metadata, no physical base tables are directly documented as referenced objects; the view is defined over another view rather than a table. The defining query selects from CUN_ASSET_UNITS_V (aliased CAU), which supplies the underlying network unit rows. The outer query applies a simple filter restricting output to three lifecycle statuses:

  • CAU.STATUS IN ('IN_SERVICE', 'OUT_OF_SERVICE', 'RETIRED')

This makes CUN_ITEM_NETWORK_UNITS_V a filtered projection of CUN_ASSET_UNITS_V, retaining the column set of the parent view while excluding units in any other status (for example, staged, in-transit, or otherwise undefined states). Because it references only a view, its effective physical dependency chain extends one level deeper into the CUN tables that populate CUN_ASSET_UNITS_V, but those are not enumerated in the documented metadata.

Key Columns

The view exposes the following columns, which correspond to network unit attributes:

Common Use Cases and Queries

Because the view is obsolete and not implemented in the database, queries against it will not execute in supported 12.1.1 / 12.2.2 environments. The intended reporting scenarios, however, centered on network equipment status tracking — notably searching for units that had gone out of service — and reconciliation with fixed assets. A representative query would have been:

  • SELECT unit_id, network_number, status, status_description, vendor_name, work_order_number FROM cun_item_network_units_v WHERE status = 'OUT_OF_SERVICE';
  • SELECT network_identifier, fixed_asset_location FROM cun_item_network_units_v WHERE status IN ('IN_SERVICE','OUT_OF_SERVICE');

Organizations encountering references to this view should redirect reporting to CUN_ASSET_UNITS_V (or its supported successors), applying the same status filter, and confirm object availability against the ETRM for the target release.