Search Results cs_sr_find_prod_maint_eam_v




Overview
Explore in AI Chat

Overview

The APPS.CS_SR_FIND_PROD_MAINT_EAM_V view is a Service (CS) module database object that consolidates Enterprise Asset Management (eAM) asset records for presentation in the Find Product user interface. It is the data source behind the search and selection screens used by service agents and field service personnel when identifying a customer product against which a service request, incident, or depot repair activity will be raised. The view presents a single, denormalized row per tracked eAM instance, combining customer identity, product definition, order provenance, and asset status into a flattened projection.

Because the view is defined in the APPS schema and its source text is shipped with the product, it is treated as an Oracle-owned reporting object. It should not be modified; extensions and custom reporting should query the view as published.

Underlying Base Objects

The view is defined over the following documented base objects:

All OE and CSI_SYSTEMS_TL joins are outer joins, so asset records without a surviving order line or translated system name are still returned. MTL_PARAMETERS and MTL_SYSTEM_ITEMS_VL participate as inner joins because every eAM instance must resolve to a serviced inventory item.

Key Columns

Common Use Cases and Queries

The primary scenario is populating the Find Product Lov or search block for eAM-enabled items. A typical filtered query retrieves assets by serial number or by shipment date window:

  • Locating an asset by serial number before raising a service request.
  • Reporting on assets shipped within a period for warranty or recall analysis.
  • Reconciling eAM instances to their originating sales orders.

Sample SQL:

  • SELECT customer_product_id, current_serial_number, principal_party_name, shipped_date, original_order_number FROM apps.cs_sr_find_prod_maint_eam_v WHERE current_serial_number = :serial;
  • SELECT customer_product_id, product_name, shipped_date FROM apps.cs_sr_find_prod_maint_eam_v WHERE shipped_date BETWEEN :from_date AND :to_date;
  • SELECT principal_party_name, COUNT(*) FROM apps.cs_sr_find_prod_maint_eam_v GROUP BY principal_party_name;

Note that the view text filters on SERV_REQ_ENABLED_CODE = 'E', COMMS_NL_TRACKABLE_FLAG = 'Y', an active date window, and EAM_ITEM_TYPE in (1,3). Results are therefore restricted to currently active, service-request-enabled, communication-trackable eAM assets.