Search Results product_description




Overview
Explore in AI Chat

Overview

The view CS_CUSTOMER_PRODUCTS_RG_V belongs to the Oracle E-Business Suite CS – Service module and stores information pertaining to products recorded in Oracle Installed Base. It functions as a reporting and integration layer that flattens the core customer product record into a single, denormalized result set, joining item master descriptions, customer account details, and the originating service or order context. Rather than requiring report developers to assemble these joins manually against CS_CUSTOMER_PRODUCTS, MTL_SYSTEM_ITEMS_KFV, and HZ_CUST_ACCOUNTS, the view presents the resolved product identifier, description, account number, and line instance detail identifier in one row per installed instance.

The suffix _RG_V indicates a report-generator style view used by Service/Installed Base reporting components. In EBS 12.1.1 and 12.2.2, such views typically back Oracle Reports, OAF pages, or customer-facing extracts where installed base product data must be displayed alongside account and item context. The view is read-only by design and is not a configuration or transactional entity.

Underlying Base Objects

The ETRM metadata records no explicitly documented referenced base objects, but the embedded view text exposes the full definition. The view is defined over:

  • CS_CUSTOMER_PRODUCTS CP — the primary installed base table that stores each customer product instance, including serial number, quantity, and the original service detail reference.
  • HZ_CUST_ACCOUNTS ACC — the trading community account table, joined on CP.CUSTOMER_ID = ACC.CUST_ACCOUNT_ID, supplying the account number.
  • MTL_SYSTEM_ITEMS_KFV SI — the key-flexfield item view, joined on CP.INVENTORY_ITEM_ID = SI.INVENTORY_ITEM_ID, providing the concatenated item segment description.

The item join is additionally constrained by SI.ORGANIZATION_ID = (SELECT CS_STD.GET_ITEM_VALDN_ORGZN_ID FROM DUAL), which restricts the item flexfield resolution to the validation organization returned by the CS_STD package function. This ensures the product name and description align with the master item definition rather than a warehouse-specific organization record.

Key Columns

Common Use Cases and Queries

Analysts commonly query this view to reconcile installed base instances with the service detail or order line that created them, particularly when tracing a line_inst_detail_id value back to a serialized product.

  • Listing all installed products for an account with item and quantity detail.
  • Locating the customer product record associated with a given line instance detail ID.
  • Validating item descriptions and account numbers for installed base extracts.
SELECT customer_product_id,
       reference_number,
       current_serial_number,
       product,
       account_number,
       line_inst_detail_id
  FROM cs_customer_products_rg_v
 WHERE line_inst_detail_id = :p_line_inst_detail_id;
SELECT account_number, product, quantity
  FROM cs_customer_products_rg_v
 WHERE account_id = :p_account_id
 ORDER BY product;