Search Results install_date




Overview
Explore in AI Chat

Overview

CSI_UNIT_INSTANCES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the CSI – Install Base product. It exposes item instance records that qualify as "units" and that are simultaneously not components of any other instance. In Install Base terminology, an instance may represent a top-level unit (for example, a serialized asset placed at a customer site) or a component nested beneath a parent unit through an instance-to-instance relationship. This view deliberately restricts its result set to the former category, allowing callers to work with complete, stand-alone units without having to resolve relationship hierarchies themselves.

For Oracle EBS 12.1.1 and 12.2.2, the view is reported with VALID status, making it a stable object for custom reports, concurrent programs, interfaces, and third-party integrations. Its definition is a projection of CSI_ITEM_INSTANCES joined against CSI_II_RELATIONSHIPS to exclude instances referenced as components, while returning the full set of descriptive, status, location, and transactional attributes associated with each unit.

Underlying Base Objects

The documented referenced base objects are CSI_ITEM_INSTANCES (exposed to the view through a synonym) and CSI_II_RELATIONSHIPS (also referenced via a synonym). CSI_ITEM_INSTANCES is the primary Install Base table and supplies every column prefixed CII in the view text, including identifiers, item and revision information, serial and lot numbers, quantities, status codes, location attributes, and transactional references.

CSI_II_RELATIONSHIPS stores the parent-child associations between instances. The view uses this object to filter out records that participate as components within another instance, thereby returning only those instances that stand alone as units. All columns returned by the view map directly to CSI_ITEM_INSTANCES columns; no derived or aggregated values are introduced.

Key Columns

Common Use Cases and Queries

The view is commonly used to list customer-facing units for reporting, to reconcile installed base counts by item or organization, and to feed interfaces requiring only top-level instances. Because CREATION_COMPLETE_FLAG distinguishes fully created instances from in-progress or failed creations, it is frequently used as a filter to avoid exposing incomplete records.

  • Unit inventory listing: SELECT INSTANCE_NUMBER, SERIAL_NUMBER, INVENTORY_ITEM_ID, INSTANCE_STATUS_ID FROM CSI_UNIT_INSTANCES_V;
  • Complete-creation filter: SELECT INSTANCE_ID, INSTANCE_NUMBER FROM CSI_UNIT_INSTANCES_V WHERE CREATION_COMPLETE_FLAG = 'Y';
  • Units for a specific item and organization: SELECT INSTANCE_NUMBER, SERIAL_NUMBER, INV_ORGANIZATION_ID FROM CSI_UNIT_INSTANCES_V WHERE INVENTORY_ITEM_ID = :item_id AND INV_ORGANIZATION_ID = :org_id;
  • Sellable customer-visible units: SELECT INSTANCE_NUMBER, LOCATION_ID FROM CSI_UNIT_INSTANCES_V WHERE SELLABLE_FLAG = 'Y' AND CUSTOMER_VIEW_FLAG = 'Y';

All column names should be verified against the 12.1.1 or 12.2.2 data dictionary in the target instance, as patch levels can affect the presence of individual attributes.