Search Results okx_cust_prod_v




Overview
Explore in AI Chat

Overview

The OKX_CUST_PROD_V view is a reporting and integration object owned by the APPS schema within the OKX – Contracts Integration product family of Oracle E-Business Suite. Its documented status is VALID, and it exposes the installed base products information, commonly referred to as customer products. In practice, this view provides a denormalized, read-only projection of the CS_CUSTOMER_PRODUCTS_ALL entity, allowing downstream contracts, service, and integration processes to retrieve customer product records without directly querying the underlying installed base tables.

In the context of Oracle EBS 12.1.1 and 12.2.2, the view functions as an interface layer between the Service/Installed Base module and the Contracts Integration (OKX) module. Because Contracts Integration must reconcile contractual obligations with products actually shipped, delivered, and installed at a customer site, OKX_CUST_PROD_V surfaces the attributes required for that reconciliation—quantities, shipment and delivery indicators, serial numbers, site usage identifiers, and agreement references. The presence of audit and multi-org columns such as ORG_ID, CONTEXT, and OBJECT_VERSION_NUMBER confirms that the view is also suitable for use in multi-organization and concurrent-program contexts.

Underlying Base Objects

The ETRM metadata documents the view as dependent on two referenced base objects:

  • CS_CUSTOMER_PRODUCTS_ALL (SYNONYM) — The primary source of column data. This synonym resolves to the installed base customer products table, which stores the authoritative record for each customer product, including shipment, delivery, and configuration attributes.
  • CSICUMPI_PUB (PACKAGE) — A package in the Service/Installed Base interface layer referenced by the view definition, typically supporting programmatic logic or interface processing associated with customer product data.

The view text shows that columns are projected directly from the alias CP, which corresponds to CS_CUSTOMER_PRODUCTS_ALL. The view therefore adds no new persistent storage; it is a virtual representation maintained by Oracle, and its status of VALID indicates the underlying objects are compiled and accessible. Because it is owned by APPS, it is eligible for grants to reporting and integration schemas.

Key Columns

The view exposes a broad set of installed base attributes. Noteworthy columns include:

Common Use Cases and Queries

Typical usage centers on identifying delivered or shipped installed base products for contract reconciliation, service entitlement, and integration extracts. A representative query filtering on the searched attribute is:

  • SELECT customer_product_id, customer_id, inventory_item_id, quantity, delivered_flag, shipped_date FROM okx_cust_prod_v WHERE delivered_flag = 'Y' AND org_id = :p_org_id;

Other common scenarios include retrieving all most-recent records for a customer (WHERE most_recent_flag = 'Y'), joining to agreement tables via PRODUCT_AGREEMENT_ID, and extracting records within an effective date range using START_DATE_ACTIVE and END_DATE_ACTIVE. Because the view is read-only and owned by APPS, it is best consumed through standard EBS security and reporting mechanisms rather than modified directly.