Search Results covd_line_id




Overview
Explore in AI Chat

Overview

The view APPS.OKS_PROD_DETAILS_V belongs to the Oracle Service Contracts (OKS) module and is documented in ETRM as a valid object in both release 12.1.1 and 12.2.2. Its stated purpose is to expose service contracts product details — that is, the covered products, quantities, and pricing recorded against contract lines — in a single denormalized result set suitable for reporting and integration. Rather than forcing consumers to join header, line, item, and inventory structures independently, the view consolidates those relationships and resolves the line style (covered level) through the translatable lookup table OKC_LINE_STYLES_TL.

The view is defined as a UNION of three branches. Each branch selects contract header, contract line, covered line, and item attributes, but restricts the line style via L.LSE_ID: the first branch covers LSE_ID values 9, 18, and 25, the second covers LSE_ID = 35, and the third selects the remaining product detail set. This design reflects the differing join paths required for inventory-item-based covered products versus customer-account-based covered products (for example, subscriptions or service-only coverage), where a serial number and inventory item context are not always available.

Underlying Base Objects

The ETRM metadata lists the referenced objects for this view, principally synonyms and views in the APPS schema. The documented base objects include OKC_K_HEADERS_B, OKC_K_LINES_B, OKC_K_ITEMS, and OKC_LINE_STYLES_TL, together with the customer product views CS_CUSTOMER_PRODUCTS, CS_CUSTOMER_PRODUCTS_ALL, and the OKX public views OKX_SYSTEM_ITEMS_V, OKX_CUSTOMER_ACCOUNTS_V, OKX_CUST_SITE_USES_V, OKX_PARTIES_V, and OKX_SYSTEMS_V. Two packages, ARP_ADDR_LABEL_PKG and CSICUMPI_PUB, are also recorded as referenced objects.

Within the view text, OKC_LINE_STYLES_TL is joined on L.LSE_ID = LS.ID with the restriction LS.LANGUAGE = USERENV('LANG'), ensuring the covered-level name (LS.NAME) is returned in the session language. OKX_SYSTEM_ITEMS_V supplies the item description (SX.DESCRIPTION), and CS_CUSTOMER_PRODUCTS_ALL supplies the current serial number via a scalar subquery on CUSTOMER_PRODUCT_ID = IT.OBJECT1_ID1.

Key Columns

Common Use Cases and Queries

Typical usage includes service contract coverage reporting, entitlement feeds, and reconciliation of covered quantities and negotiated prices against contract lines. A representative query retrieves covered product details for a contract:

  • SELECT contract_id, covd_line_number, covred_level, covd_description, covered_serial_no, quantity, qty_uom, price FROM oks_prod_details_v WHERE contract_id = :p_contract_id ORDER BY covd_line_number;
  • Join to OKC_K_HEADERS_B or OKC_K_LINES_B when additional contract attributes such as dates, parties, or statuses are required, since the view itself exposes a focused column set.
  • Filter on covred_level to distinguish coverage categories, noting that the underlying WHERE clauses restrict which LSE_ID values are eligible in each UNION branch.

Because the covered level is resolved through a translatable table restricted by USERENV('LANG'), results for covred_level are language-dependent and may differ across environments.