Search Results install_address1




Overview
Explore in AI Chat

Overview

The CS_CUSTOMER_PRODUCTS_REPORT_V view is an APPS-owned reporting object within the CS (Service) product family of Oracle E-Business Suite, documented in ETRM for releases 12.1.1 and 12.2.2. Its documented description is simply "Retrofitted," indicating that the view was migrated forward from an earlier EBS release (notably 11i) into the R12 data model, retaining its original column and join semantics for backward compatibility with existing reports, concurrent programs, and downstream integrations. The view presents a denormalized, report-ready projection of customer product (installed base) records, combining the customer product instance with its owning customer account, party name, installation address, item description, revision, system, and status.

Its primary role is to shield report consumers from the multi-table joins required to assemble an installed-base report. Rather than requiring report authors to navigate CS_CUSTOMER_PRODUCTS_ALL, the trading community model (HZ) tables, inventory master tables, and service status/revision tables individually, the view exposes a single flat row per customer product instance. Notably, the view defines NULL SERVICED_STATUS as a literal column, which is significant for users searching on serviced_status: the column exists in the result set but is not populated by the view's SQL and returns NULL for every row.

Underlying Base Objects

The view is defined over the following documented base objects: CS_CUSTOMER_PRODUCTS_ALL (the driving synonym for customer product instances), CS_CUSTOMER_PRODUCT_STATUSES, CS_CP_REVISIONS, CS_SYSTEMS, CS_LOOKUPS (a view over FND lookups used for CUSTOMER_PRODUCT_TYPE), MTL_SYSTEM_ITEMS (item master), and the HZ trading community synonyms HZ_CUST_ACCOUNTS, HZ_PARTIES, HZ_PARTY_SITES, and HZ_LOCATIONS. It also references the packages CS_STD (for GET_ITEM_VALDN_ORGZN_ID), CSICUMPI_PUB, and FND_GLOBAL, and DUAL.

Joins are keyed on CUSTOMER_PRODUCT_ID (to CS_CP_REVISIONS via current revision), CUSTOMER_PRODUCT_STATUS_ID, CUSTOMER_ID to HZ_CUST_ACCOUNTS, INSTALL_SITE_USE_ID to HZ_PARTY_SITES (outer-joined), INVENTORY_ITEM_ID to MTL_SYSTEM_ITEMS restricted to the validation organization returned by CS_STD.GET_ITEM_VALDN_ORGZN_ID, SYSTEM_ID to CS_SYSTEMS (outer), and TYPE_CODE to CS_LOOKUPS (outer).

Key Columns

Common Use Cases and Queries

The view supports installed-base reporting, customer product status audits, and service contract preparation. A typical query lists active customer products with their account, item, and installation address:

  • SELECT account_number, party_name, product_description, current_serial_number, cp_status FROM cs_customer_products_report_v WHERE end_date_active IS NULL ORDER BY account_number, party_name;
  • SELECT serviced_status, COUNT(*) FROM cs_customer_products_report_v GROUP BY serviced_status; — this returns a single NULL group, confirming the column is not derivable from this view. Users requiring a serviced status must obtain it from the customer product status tables or a related CS view.
  • SELECT party_name, install_location, install_address1, system, product_type FROM cs_customer_products_report_v WHERE product_type = 'Customer Product';

Because the view depends on CS_STD.GET_ITEM_VALDN_ORGZN_ID and HZ joins, performance is sensitive to the validation organization configuration and to indexes on the customer product and HZ tables; report authors should filter by account, item, or status to constrain result sets.