Search Results customer_product_item_id

Overview

APPS.OKI_COV_PROD_LINES_V is a public Oracle E-Business Suite view owned by the APPS schema and registered under the FND Design Data key OKI.OKI_COV_PROD_LINES_V. It exposes the covered product lines associated with service contracts managed by Oracle's Enterprise Contracts / Service Contracts modules (the OKI/OKC family of objects). The view is described in the ETRM metadata as one that "may be useful for custom reporting or other data requirements," which is the standard Oracle designation for views intended as a sanctioned read-only interface for customer extensions and reports.

The view is not a base table: it is a language-specific projection over OKI_COV_PROD_LINES. Because it joins language (MLS) information, the rows returned are filtered or resolved according to the session's language environment, so external descriptions such as status meaning and termination meaning are presented in the user's installed language rather than as raw lookup codes. For a user searching on customer_product_item_id, this view is relevant because covered product lines are the lines that carry the delivered customer product/item reference; however, the documented column list for this view does not include a CUSTOMER_PRODUCT_ITEM_ID column directly. Implementers seeking that identifier should confirm whether it resides on OKI_COV_PROD_LINES or a related table and is exposed through a different view or join.

Underlying Base Objects

The documentation identifies a single base object: OKI_COV_PROD_LINES, over which the view is defined with language-specific (MLS) substitution. The ETRM metadata lists no other referenced base objects; the "Referenced base objects: none documented" entry reflects that the flat column listing does not resolve the MLS join targets explicitly. In practice, the language-specific descriptions (STATUS_MEANING, STATUS_TYPE_MEANING, TERMINATION_MEANING) are derived from the multilingual lookup / value-set translation tables that support the OKI contract schema, resolved at query time by the view definition.

The view inherits the grain of OKI_COV_PROD_LINES: one row per covered product line on a service contract, keyed by CONTRACT_LINE_ID and related to its parent contract through CONTRACT_ID and to the top line through PARENT_LINE_ID. No independent storage or materialization exists; all access passes through to the base line table plus the language resolution.

Key Columns

• CONTRACT_LINE_ID — Internal identifier of the covered product line; the primary key at line level.
• CONTRACT_ID — Internal identifier of the parent contract.
• PARENT_LINE_ID — Identifier of the parent top line under which this covered product line is organized.
• COMPLETE_CONTRACT_NUMBER — Concatenation of CONTRACT_NUMBER and CONTRACT_NUMBER_MODIFIER, convenient for single-column display and joins.
• LINE_NUMBER — External (user-visible) line number.
• START_DATE / END_DATE / DURATION / PERIOD — Effective dating and duration of the line, with PERIOD holding the duration unit code.
• STS_CODE / STATUS_MEANING / STATUS_TYPE_CODE / STATUS_TYPE_MEANING — Status code and its translated meaning (for example ACTIVE or ENTERED), plus the status type classification.
• TRN_CODE / TERMINATION_MEANING / DATE_TERMINATED / DATE_RENEWED — Termination reason with translated meaning, termination date, and renewal date.
• NUMBER_OF_ITEMS / UOM_CODE / UNIT_PRICE / UNIT_PRICE_PERCENT — Covered quantity, its unit of measure, the unit price, and the pricing percentage applied to the line.
• SCS_CODE — Category (sub-class) code for the contract.

Common Use Cases and Queries

Typical uses include contract entitlement reporting, renewal and termination analysis, and feed extraction into downstream billing or CRM systems. Because the view carries translated meanings, it is well suited to end-user reports that must display status and termination reasons in the session language.

• List active covered product lines for a contract number.
• Report lines terminating or renewing within a date range.
• Summarize covered quantities and pricing by contract category.

Sample query:

SELECT contract_number, complete_contract_number, line_number,
  start_date, end_date, status_meaning, termination_meaning,
  number_of_items, uom_code, unit_price
FROM apps.oki_cov_prod_lines_v
WHERE status_meaning = 'Active'
  AND sysdate BETWEEN start_date AND NVL(end_date, sysdate + 1);

Where a customer product item identifier is required, query the base covered product line table or the service contract line tables and join back on CONTRACT_LINE_ID, since CUSTOMER_PRODUCT_ITEM_ID is not among the columns documented for this view.