Search Results original_order_currency_code




Overview
Explore in AI Chat

Overview

APPS.CS_CUSTOMER_PRODUCTS is a reporting and integration view in Oracle E-Business Suite (EBS) Release 12.1.1 and 12.2.2 that presents the installed base of customer products tracked by the Oracle Service (CS) module. A "customer product" record represents a specific instance of an inventory item that a customer has purchased, installed, or received, and around which service, depot repair, contract, and entitlement activity is managed. The view exposes the full column set of the underlying customer products entity, including identity, financial, shipping, configuration, and descriptive flexfield attributes, making it a convenient single source for queries, concurrent programs, and outbound integrations that need to read installed-base data without directly referencing the multi-org base table.

Because the object is a view rather than a table, it is read-oriented. It plays a central role in customer-facing reporting such as installed-base extracts, warranty and return tracking, configuration reporting, and downstream data feeds to CRM or data warehouse systems. In the specific case of the searched column ORIGINAL_ORDER_CURRENCY_CODE, the view is the standard access point for retrieving the currency in which the customer's original sales order for the product was booked.

Underlying Base Objects

Per the documented ETRM metadata for 12.2.2, the view owner is APPS and its referenced base objects are:

  • CS_CUSTOMER_PRODUCTS_ALL (SYNONYM) — the synonym resolving to the underlying customer products table, which stores one row per installed-base instance. This is the principal source of the columns projected by the view.
  • CSICUMPI_PUB (PACKAGE) — a public server-side package referenced in the view definition (typically for derived or formatted values used in installed-base presentation logic).

The DDL is defined in the APPS schema and is therefore accessible to any responsibility or custom code with SELECT privilege on APPS objects. Since the base synonym is an "_ALL" object, the underlying data is partitioned by operating unit via ORG_ID; the view itself does not filter by operating unit, so consumers must apply their own ORG_ID or Multi-Org security predicate where appropriate.

Key Columns

Common Use Cases and Queries

Typical usage includes installed-base extracts, warranty/return monitoring, configuration reporting, and reconciliation of service history against original order financials. To retrieve original order currency alongside identifying information:

  • SELECT customer_product_id, customer_id, inventory_item_id, original_order_line_id, original_order_currency_code, original_net_amount FROM apps.cs_customer_products WHERE customer_id = :p_customer_id AND org_id = :p_org_id;
  • SELECT original_order_currency_code, SUM(original_net_amount) FROM apps.cs_customer_products WHERE org_id = :p_org_id GROUP BY original_order_currency_code; to summarize installed-base value by currency.
  • Join to CS_CUSTOMER_PRODUCTS_ALL or HZ_CUST_ACCOUNTS to enrich with customer and product descriptions, and always filter on ORG_ID to respect Multi-Org boundaries.