Search Results original_order_date




Overview
Explore in AI Chat

Overview

APPS.CS_SR_PRODUCTS_MAINT_V is a Service (CS) module view that consolidates installed base product information required by the Service Request (SR) maintenance flow in Oracle E-Business Suite 12.1.1 and 12.2.2. The view presents one row per customer product record held in the Install Base, enriched with the originating order context, item description, revision, system membership, and serviced status. Its principal purpose is to return all product instances belonging to a particular customer account so that a service agent can identify, select, or validate the product referenced on a service request.

For users searching on the term original_order_number, this view is the relevant access point: the column ORIGINAL_ORDER_NUMBER is projected directly from the order header source, allowing the original sales order number associated with an installed instance to be displayed alongside the original line number and order date without navigating to Order Management tables. The view is owned by the APPS schema and is reported with VALID status in the ETRM repository.

Underlying Base Objects

The view joins several base objects in a single flattened projection. The Install Base record itself is supplied by CS_CUSTOMER_PRODUCTS_ALL, which contributes the customer product identifier, serial number, lot number, install site, parent product, status, and shipped date. Current revision data is joined from CS_CP_REVISIONS on both CUSTOMER_PRODUCT_ID and CURRENT_CP_REVISION_ID. Item context comes from MTL_SYSTEM_ITEMS, restricted to the validation organization returned by CS_STD.GET_ITEM_VALDN_ORGZN_ID.

Original order attributes are sourced from ASO_I_OE_ORDER_HEADERS_V and ASO_I_OE_ORDER_LINES_V, joined to the installed instance on ORIGINAL_ORDER_LINE_ID. Account and party names are resolved through HZ_CUST_ACCOUNTS and HZ_PARTIES. System membership is supplied by CS_SYSTEMS via an outer join on SYSTEM_ID, and the serviced status flag is derived through CS_LOOKUPS using the function CS_STD.CS_GET_SERVICED_STATUS. Supporting packages referenced by the view definition include FND_GLOBAL and CSICUMPI_PUB. Records with a customer product status of 4 or 1003 are excluded by the view predicate.

Key Columns

Common Use Cases and Queries

The view is typically queried by service request forms, extensions, and custom reports that must display the products owned by an account. A frequent pattern filters on the customer and retrieves current instances with their original order reference:

  • SELECT customer_product_id, current_serial_number, product_description, original_order_number, original_order_date, system FROM cs_sr_products_maint_v WHERE customer_id = :p_customer_id;
  • SELECT customer_product_id, original_order_number, original_line_number, purchase_order_num FROM cs_sr_products_maint_v WHERE customer_product_id = :p_cp_id;
  • SELECT customer_product_id, current_serial_number, serviced_status_flag FROM cs_sr_products_maint_v WHERE customer_id = :p_customer_id AND most_recent_flag = 'Y';

Because the view excludes inactive customer product statuses and applies a lookup-based serviced status, results represent serviceable instances suitable for direct use in SR product selection. Queries should restrict on CUSTOMER_ID, CUSTOMER_PRODUCT_ID, or INVENTORY_ITEM_ID to avoid broad scans across the Install Base.