Search Results cp_service_status




Overview
Explore in AI Chat

Overview

The APPS.CS_SR_NEW_PRODUCTS_MAINT_V view is a Service (CS) module reporting object that consolidates customer product and item instance information for use by service request creation and maintenance flows. Its name reflects its purpose: to present "new products" — that is, customer-owned item instances eligible for service — in the format required by the service request maintenance user interface and related concurrent or integration processes. The view joins installed base item instances from the CSI schema with their owning party, inventory definitions, originating order information, and service status classification.

The view is owned by APPS and exposes a purpose-built projection of columns drawn from multiple EBS schemas. It is commonly referenced by service modules that need to display or validate the products that a customer owns before allowing service requests to be logged against them. Because it filters aggressively on serviced status, incident eligibility, and service-enabled inventory items, it returns only a curated set of records rather than the entire installed base.

Underlying Base Objects

The view is defined over a fixed set of base tables, synonyms, and views documented in the ETRM metadata:

Key Columns

Common Use Cases and Queries

The view is typically queried to validate customer product ownership before creating a service request, to report on installed base by customer, or to inspect the CP_SERVICE_STATUS value. Because it is constrained by organization, service-enabled inventory, and incident-eligible statuses, results are pre-filtered for serviceability.

A representative query to find serviceable products for a customer:

SELECT account_number, product_description, serial_number,
       cp_status, serviced_status_flag
FROM   apps.cs_sr_new_products_maint_v
WHERE  account_number = :p_account_number
AND    cp_status IS NOT NULL;

To locate products whose serviced status is a specific value:

SELECT instance_number, serial_number, serviced_status_flag
FROM   apps.cs_sr_new_products_maint_v
WHERE  inventory_item_id = :p_item_id;

Because several joins are outer joins and the status flag is computed from package logic, queries should not assume non-null order or status columns. The CP_SERVICE_STATUS lookup referenced in the user search governs the SERVICED_STATUS_FLAG column, making it the natural filter for categorizing products by serviced state.