Search Results serviced_status_flag




Overview
Explore in AI Chat

Overview

The APPS.CS_SR_NEW_FIND_PROD_MAINT_V view is a Service (CS) module reporting object that consolidates Oracle Install Base product information for presentation within the Service Request workflow. According to the ETRM documentation, the view "contains the information about all products in the InstallBase" and is used "to get all product information for a particular account in Service request." It is a legacy compatibility object that incorporates the Oracle Install Base changes delivered in release 11.5.6, and it remains VALID in the 12.1.1 and 12.2.2 codelines.

Operationally, the view answers the question: for a given customer account, which installed products are eligible to be referenced on a service request? Eligibility is enforced through filters on the instance status definition, the service-request enablement of the item, and communications tracking. The view therefore acts as a pre-filtered source for the Service Request "find product" (CS_SR_NEW_FIND_PROD) user interface flow and for any custom report or concurrent program that needs candidate installed base records tied to an account.

Underlying Base Objects

The view is defined in the APPS schema and joins synonyms that resolve to the base Install Base, Trading Community Architecture (TCA), Order Management, and inventory item tables. The documented referenced objects in 12.2.2 are:

The Item Instances record joins to the item master, the TCA party, the sales order line and header (outer-joined), the system, and the status definition. The join to CSI_INSTANCE_STATUSES is an inner join constrained to statuses where INCIDENT_ALLOWED_FLAG = 'Y'. Item master attributes further restrict output to service-request-enabled items (SERV_REQ_ENABLED_CODE = 'E') and communications-trackable items (COMMS_NL_TRACKABLE_FLAG = 'Y'), while the active date range window limits records to currently effective instances.

Key Columns

The projection exposes both Install Base native attributes and harmonized aliases expected by the Service Request product finder. Notable columns include:

Common Use Cases and Queries

The view is typically queried to validate whether a particular serviced status flag or account-instance combination exists before provisioning a service request, and to populate LOV or multi-record blocks in the Service Request finder.

Sample query returning eligible installed base products for a given account:

SELECT customer_product_id, reference_number, current_serial_number, product_name, serviced_status_flag FROM apps.cs_sr_new_find_prod_maint_v WHERE customer_id = :p_customer_id ORDER BY product_name;

Filtering on the serviced status flag:

SELECT customer_product_id, product_name, most_recent_flag FROM apps.cs_sr_new_find_prod_maint_v WHERE customer_id = :p_customer_id AND serviced_status_flag = 'N';

Because SERVICED_STATUS_FLAG is a hard-coded literal in the view definition, filtering on it will always return every row for the account when set to 'N', and no rows when set to any other value. Customized reports that depend on a dynamically sourced serviced status should therefore query CSI_ITEM_INSTANCES directly rather than relying on this column.