Results for “current_serial_number”

50+ results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

CS_ACC_CP_RG_V is a valid APPS-owned database view in the Oracle E-Business Suite Service (CS) module. Its documented purpose is to support the main service request form, where it is consumed by a record group to retrieve install base information. In practical terms, the view exposes customer product (install base) records together with the item definition, system, revision, and status data needed to populate the customer product field on the service request window.

The view is defined with a SYSDATE predicate against the effective date range on CS_CUSTOMER_PRODUCTS_ALL, and it excludes certain inactive status identifiers (4 and 1003). As a result, it returns only currently effective customer products. Because it joins order line and order header data, it also surfaces the original sales order context associated with the installed item.

A notable characteristic of this view is that it explicitly projects placeholder columns. PLATFORM_ID, PLATFORM, PLATFORM_VERSION_ID, and VERSION are returned as typed NULLs rather than values sourced from a base table. This is directly relevant to searches for platform_version_id: although the column exists in the view's projection, it is not populated by this view. Its presence maintains a consistent record group structure for the service request form while the underlying platform data is supplied elsewhere, such as through the CSICUMPI_PUB package referenced in the metadata.

Underlying Base Objects

The view is defined over the following documented base objects:

The metadata additionally lists CS_STD, FND_GLOBAL, and CSICUMPI_PUB as referenced objects; these are packages used by the view definition or its supporting logic rather than row sources.

Key Columns

Common Use Cases and Queries

Typical use is to resolve the install base entries available for a service request, filtered by item, serial number, or system. For example, locating a product by serial number:

  • SELECT customer_product_id, product_name, current_serial_number, system_name, revision, customer_product_status
  • FROM cs_acc_cp_rg_v
  • WHERE current_serial_number = :serial_number;

Retrieving all effective products for a given system:

  • SELECT customer_product_id, product_name, reference_number, order_number
  • FROM cs_acc_cp_rg_v
  • WHERE system_id = :system_id
  • ORDER BY product_name;

Because PLATFORM_VERSION_ID is a constant NULL, queries that filter or report on platform version against this view will return no meaningful platform data; platform and version information must be obtained from the sources that populate it, consistent with the role of CSICUMPI_PUB in the documented metadata. Note also that the view applies its own effective-date and status filters, so callers do not need to re-apply them.