Search Results cp_status




Overview
Explore in AI Chat

Overview

CS_SR_NEW_PRODUCTS_MAINT_V is an APPS-owned database view within the Oracle E-Business Suite Service (CS) module. It consolidates product and installed base information drawn from InstallBase releases 11.5.6 and higher, exposing a flattened, report-ready result set that Service Request functionality relies upon to resolve all products associated with a given customer account. Rather than requiring callers to join the customer, order, item, and instance schemas independently, the view presents a single denormalized source that maps owned items to their owning party, original sales order context, current service status, and location.

Its primary integration role is within the Service Request (SR) flow: when an agent or an external application opens an SR against an account, the view supplies the candidate product list from which the appropriate instance is selected. Because it joins across the Order Management, InstallBase (CSI), and Receivables/Trading Community (HZ) models, it is a convenient reporting surface for installed base analytics, entitlement lookups, and account-level product inventories.

Underlying Base Objects

The view is defined over the following documented objects:

Key Columns

Common Use Cases and Queries

Typical usage includes listing an account's serviceable products, locating an instance by serial number, or reconciling installed base against original order data — including the customer purchase order reference.

SELECT instance_number,
       serial_number,
       product_description,
       original_order_number,
       purchase_order_number,
       serviced_status_flag
FROM   apps.cs_sr_new_products_maint_v
WHERE  account_number = :p_account_number
AND    serviced_status_flag = 'Y';

To trace a product by its customer PO number, the PURCHASE_ORDER_NUMBER column supports direct filtering:

SELECT account_number,
       serial_number,
       original_order_number,
       original_order_date
FROM   apps.cs_sr_new_products_maint_v
WHERE  purchase_order_number = :p_po_number;

Because the view already applies serviced-status and incident-allowed filtering, ad hoc queries return only products eligible for Service Request activity, reducing the need to replicate these business rules in custom SQL.