Search Results current_serial_number




Overview
Explore in AI Chat

Overview

CSI_INSTANCE_ACCTS_RG_V is an Oracle Applications (APPS) view within the CSI – Install Base product module. Its documented purpose is to present instance and party account information in a format suitable for record groups, which are the data sources used by Oracle EBS flexfield and reporting infrastructure. In the Oracle EBS 12.1.1 and 12.2.2 releases, the view joins item instance records to their associated owning parties and customer accounts, producing a denormalized result set that combines product identification, serialized instance attributes, quantity, and account data.

The object is registered as VALID in the ETRM metadata for 12.2.2 and is owned by the APPS schema. Because the view is oriented toward record-group consumption, it exposes friendly column aliases such as CUSTOMER_PRODUCT_ID, REFERENCE_NUMBER, and ACCOUNT_NUMBER rather than raw internal identifiers alone. A recurring point of interest for users searching this object is the line_inst_detail_id column, which the view surfaces through the aliased expression CII.LAST_TXN_LINE_DETAIL_ID LINE_INST_DETAIL_ID. This column links an instance to the last transaction line detail that affected it, providing traceability back to the originating inventory or order transaction line.

Underlying Base Objects

The view is defined over six documented base objects, all referenced through synonyms in the APPS schema:

  • CSI_ITEM_INSTANCES (aliased CII) — the driving table, supplying instance-level attributes such as instance ID, number, serial number, quantity, unit of measure, system ID, and the last transaction and order line references.
  • CSI_I_PARTIES (aliased CIP) — instance party relationships, restricted to party source HZ_PARTIES and relationship type OWNER.
  • CSI_IP_ACCOUNTS (aliased CIA) — instance party accounts, also filtered to relationship type OWNER, joined to CIP on INSTANCE_PARTY_ID.
  • HZ_CUST_ACCOUNTS (aliased ACC) — the customer account master, providing ACCOUNT_NUMBER and joined on PARTY_ACCOUNT_ID = CUST_ACCOUNT_ID.
  • MTL_SYSTEM_ITEMS_KFV (aliased SI) — the key flexfield value view for inventory items, supplying concatenated segments as PRODUCT and the item description.
  • CSI_INSTALL_PARAMETERS — used in a NOT IN subquery to exclude internal parties (INTERNAL_PARTY_ID), so only external owner accounts are returned.

The joins enforce a consistent ownership chain: an instance is tied to its owning party, that party is tied to an account, and the account is tied to the customer account master. The item join requires the instance's inventory master organization to match the item's organization.

Key Columns

  • CUSTOMER_PRODUCT_ID — maps to CII.INSTANCE_ID, the primary instance identifier.
  • REFERENCE_NUMBER — the instance number (CII.INSTANCE_NUMBER).
  • CURRENT_SERIAL_NUMBER — the serial number of the instance.
  • PRODUCT / PRODUCT_DESCRIPTION — concatenated item segments and description from MTL_SYSTEM_ITEMS_KFV.
  • QUANTITY / UNIT_OF_MEASURE_CODE — instance quantity and its unit of measure.
  • ACCOUNT_ID / ACCOUNT_NUMBER — the owning customer account identifier and number.
  • LINE_INST_DETAIL_ID — the last transaction line detail ID (CII.LAST_TXN_LINE_DETAIL_ID), a key traceability column.
  • SYSTEM_ID — the inventory system identifier for the instance.
  • ORIGINAL_ORDER_LINE_ID — the last OE order line ID associated with the instance.

Common Use Cases and Queries

The view is typically used to obtain owner-account context for installed base records, for reporting on serialized products by customer, and for resolving the transaction line detail behind an instance.

To locate an instance by its line detail:

SELECT instance_id, reference_number, current_serial_number,
       product, account_number, line_inst_detail_id
FROM   csi_instance_accts_rg_v
WHERE  line_inst_detail_id = :line_detail_id;

To list all owned instances for an account:

SELECT customer_product_id, reference_number, product,
       quantity, unit_of_measure_code
FROM   csi_instance_accts_rg_v
WHERE  account_number = :account_number;

Because internal parties are filtered out, results are limited to external owner accounts, making the view suitable for customer-facing record groups and integrations.