Search Results cs_sr_find_prod_maint_p_eam_v




Overview
Explore in AI Chat

Overview

CS_SR_FIND_PROD_MAINT_P_EAM_V is a Service (CS) module view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its stated purpose is to surface Enterprise Asset Management (eAM) asset records within the "Find Product" user interface used by Service Request and depot repair flows. In effect, the view projects CSI item instances (customer products) that were created from eAM-enabled inventory items and joined them to their originating sales order context, owner party, system hierarchy, and item master definition, producing a denormalized result set suitable for query-driven product selection screens. The view exposes a stable, read-only projection rather than storing data, and because it is defined entirely in SQL over public synonyms and views, it is also usable in custom reports, concurrent program extracts, and integration queries where service agents or interfaces must locate an asset by serial number, reference number, or original sales order line. Notably, the column ORIGINAL_LINE_NUMBER is sourced from OE_ORDER_LINES_ALL.LINE_NUMBER, tying each asset back to the exact sales order line that created it.

Underlying Base Objects

The view is defined over the following documented objects, resolved through APPS synonyms unless otherwise noted:

All joins are inner joins except the CSI_SYSTEMS_TL language-constrained outer join.

Key Columns

Common Use Cases and Queries

Typical usage includes locating an eAM asset during service request creation, validating serial numbers against original sales order lines, and reconciling field-service inventory with order history. A representative query filtering on the original line number is:

SELECT customer_product_id, current_serial_number, original_order_number, original_line_number, product_name, principal_party_name FROM apps.cs_sr_find_prod_maint_p_eam_v WHERE original_line_number = :line_number AND current_serial_number = :serial_number;

For asset discovery by owner, constrain CUSTOMER_ID or PRINCIPAL_PARTY_NAME; for maintenance organization reporting, group by MAINT_ORGANIZATION_ID. Because the view enforces eAM item type, serviceable status, and active-date window predicates, callers should not expect non-eAM or inactive assets to appear; additional filtering on SYSTEM_ID or ORGANIZATION_ID is commonly applied to scope results to a specific operating unit or maintenance organization.