Search Results currency_code_renewed

Overview

OKI_COV_PROD_LINES_V is an Oracle EBS Contracts Intelligence (OKI) view that exposes the covered product lines associated with service contracts. Contracts Intelligence was an analytical and reporting layer historically bundled with Service Contracts (OKS) in earlier Oracle EBS releases, and is documented as obsolete in the ETRM 12.2.2 metadata. The view provides a consolidated, denormalized read model of the product lines a contract covers: identifying information (contract number, contract number modifier, complete contract number, line number), lifecycle dates and statuses, pricing and currency details, coverage quantities and units of measure, and the order, system, and site identifiers linked to the covered product.

Because the object is documented as "Not implemented in this database" in the provided metadata, the view should be treated as a legacy or de-supported artifact. In environments where it does exist, it is consumed primarily for operational reporting, contract profitability analysis, and extract/integration of covered product data into downstream systems. The user search term "complete_contract_number" corresponds directly to the COMPLETE_CONTRACT_NUMBER column, which is the concatenated, fully qualified contract identifier most often used as a business key in reporting joins and extracts.

Underlying Base Objects

The documented metadata notes that no referenced base objects are recorded and that the view is not implemented in this database. The view text itself indicates that the primary source is a covered product lines table aliased CPL, providing all CONTRACT_LINE_ID, CONTRACT_ID, PARENT_LINE_ID, and related contract, pricing, and coverage columns. Two lookup joins are also visible: an STS lookup supplying STATUS_MEANING from STS_CODE, and a TRN lookup supplying TERMINATION_MEANING from TRN_CODE. A further join against an object aliased SIM supplies DESCRIPTION, which is used to describe the covered product or service item. In a live OKI installation these typically correspond to the Service Contracts covered product lines table (e.g., OKC_K_LINES or the OKI covered-product staging structures) and the standard Service Contracts status and termination-reason lookup views. As the object is documented as obsolete, its definition should be validated against the specific instance rather than assumed.

Key Columns

• COMPLETE_CONTRACT_NUMBER — the fully qualified contract number, including the contract number modifier; the principal business identifier used in reporting and joins. Related columns are CONTRACT_NUMBER and CONTRACT_NUMBER_MODIFIER.
• CONTRACT_LINE_ID / CONTRACT_ID / PARENT_LINE_ID / LINE_NUMBER — the line, contract, parent line, and displayed line number identifiers that establish hierarchy and linkage.
• START_DATE, END_DATE, DATE_TERMINATED, DATE_RENEWED — effective and lifecycle dates for the covered line.
• STS_CODE, STATUS_MEANING, TRN_CODE, TERMINATION_MEANING — status and termination codes with their translated meanings from the lookup joins.
• NUMBER_OF_ITEMS, UOM_CODE, UNIT_PRICE, UNIT_PRICE_PERCENT, PRICE_NEGOTIATED, CURRENCY_CODE, PRICE_NEGOTIATED_RENEWED, CURRENCY_CODE_RENEWED — pricing and quantity attributes, including renewed values.
• SOB_PRICE_UNIT, SOB_PRICE_NEGOTIATED, SOB_PRICE_NEGOTIATED_RENEWED, SOB_CURRENCY_CODE, BASE_PRICE_UNIT, BASE_PRICE_NEGOTIATED, BASE_PRICE_NEGOTIATED_RENEWED, BASE_CURRENCY_CODE — set of books and base currency equivalents for multi-currency reporting.
• SERVICE_ITEM, COVERED_PRODUCT_ID, DESCRIPTION, COV_PROD_QUANTITY, COV_PROD_UOM — the covered product or service and the coverage quantity and unit of measure, with a descriptive text.
• INSTALLATION_DATE, COV_PROD_ORDER_DATE, COV_PROD_ORDER_NUMBER, COV_PROD_ORDER_LINE, COV_PROD_ORDER_LINE_ID, COV_PROD_NET_AMOUNT — installation and source order attributes, including line linkage and net amount.
• SYSTEM_ID, PRODUCT_AGREEMENT_ID, COV_PROD_BILL_TO_SITE_ID, COV_PROD_SHIP_TO_SITE_ID, COV_PROD_INSTALL_SITE_ID, COV_PROD_BILL_TO_CONTACT_ID, COV_PROD_SHIP_TO_CONTACT_ID — identifiers for the system, agreement, sites, and contacts associated with the covered product.
• CREATION_DATE, LAST_UPDATE_DATE, ATTRIBUTE_CATEGORY, ATTRIBUTE1..ATTRIBUTE7 — audit and descriptive flexfield columns.

Common Use Cases and Queries

Typical use cases include reporting covered products by contract using the complete contract number, analyzing pricing and currency across covered lines, tracking renewed versus original negotiated prices, and extracting covered product data with site and contact references. Because the object is obsolete, any query should first confirm the view exists; if it does not, the same information is generally obtainable from the Service Contracts covered product tables.

• Listing covered lines for a specific contract by its complete contract number.
• Summarizing covered products by status and termination reason.
• Comparing original and renewed negotiated prices in base and set-of-books currency.
• Reporting covered product quantities, UOMs, and installation dates by system.

Illustrative query using the complete contract number:

SELECT complete_contract_number, line_number, description, cov_prod_quantity, cov_prod_uom, unit_price, price_negotiated, currency_code, status_meaning, start_date, end_date FROM oki_cov_prod_lines_v WHERE complete_contract_number = :contract_number ORDER BY line_number;

Aggregation by status:

SELECT status_meaning, COUNT(*) line_count, SUM(cov_prod_net_amount) net_amount FROM oki_cov_prod_lines_v GROUP BY status_meaning ORDER BY status_meaning;