Search Results cover_prod




Overview
Explore in AI Chat

Overview

APPS.OKL_COV_PROD_LINES_V is a reporting view in the Oracle E-Business Suite Contracts (OKC) and Enterprise Trading and Risk Management (ETRM) schema. It exposes the contract lines that represent covered products within service contracts, specifically those whose line style is classified with the code COVER_PROD and whose parent contract header carries a status code of SERVICE. The view joins the base contract line tables with the line styles and header tables to present a denormalized, user-facing picture of each covered product line together with its description, active dates, current lifecycle status, and the authoring organization identifier.

The name, with its _V suffix, follows the standard EBS convention for read-only views intended for inquiry, reporting, and integration consumption. It is not a transactional entity; it provides a stable projection over the underlying OKC tables that BI Publisher reports, Discoverer workbooks, OAF/ADF pages, and custom SQL extracts can query directly.

Underlying Base Objects

The view is defined over four base objects, each referenced through APPS synonyms:

Because all four objects are joined through inner joins, a row appears from the view only when the line references a valid style, header, and translation in the session language.

Key Columns

  • ID1 — the contract line identifier (CLE.ID), the primary key of the covered product line.
  • ID2 — a literal placeholder column containing '#', retained from the source definition.
  • NAME — the translated line name from OKC_K_LINES_TL.
  • DESCRIPTION — the translated item description.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the line's effective start and end dates.
  • STATUS — a derived flag: 'I' when the current date precedes the start date or exceeds the end date, otherwise 'A' for active. The DECODE/SIGN logic treats missing dates as today's date, so a line with null dates evaluates to active.
  • STS_CODE — the raw status code of the contract line.
  • ORG_ID — the authoring organization identifier, used for multi-org security and reporting partitions.

Common Use Cases and Queries

The view is typically queried to list covered products for a service contract or to drive an LOV. A representative query is:

SELECT id1, name, description, start_date_active, end_date_active, status FROM apps.okl_cov_prod_lines_v WHERE status = 'A' ORDER BY name;

To scope by authoring organization for multi-org reporting, add WHERE org_id = :org_id. To resolve the parent contract, join id1 back to OKC_K_LINES_B on ID and then to OKC_K_HEADERS_B. Analysts commonly use the view in BI Publisher against AUTHORING_ORG_ID, and developers embed it in OAF regions where a covered-product list must be filtered to service contracts and active dates.