Results for “okc_rel_obj_quote_lines_v”

26 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

OKC_REL_OBJ_QUOTE_LINES_V is a reporting and integration view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It resides within the OKC (Contracts Core) product family, which underpins Oracle's Enterprise Contract Management and sourcing/quoting integration flows. The view exposes the relationship between contract lines held in OKC and the corresponding quotation lines originating from the Oracle Quoting module (OKX), presenting a denormalized, read-only projection that joins contract relationship objects to quote detail.

Practically, this view answers the question "which contract line corresponds to which quote line, and at what price and quantity?" It is therefore consumed by downstream reporting, order capture, and integration programs that need a single, stable object to reconcile contractual commitments against pre-sales quotations. Because it is a view rather than a table, it carries no storage of its own and reflects the current state of the underlying OKC and OKX base views at query time.

Underlying Base Objects

The view is defined over four referenced base objects, all of which are themselves views:

  • OKK_K_LINES_V (OKC_K_LINES_V) — the contract lines view, providing the contract line identifier (CLE_ID) and configuration item type used to filter top-level model lines.
  • OKX_QUOTE_LINES_V — the quote lines view, supplying line number, quote header, quantity, price, currency, inventory item, and organization identifiers. This is the exact object users typically search for when looking for quote-line reporting.
  • OKC_K_REL_OBJS_V — the contract relationship objects view, which bridges the contract line to the quote line via OBJECT1_ID1, CHR_ID, and the relationship type code JTOT_OBJECT1_CODE.
  • OKX_SYSTEM_ITEMS_V — the system items view, which resolves inventory item and organization identifiers into a human-readable item name and description.

The join logic is important: quote lines are linked to contract relationship objects by matching QL.ID1 to REL.OBJECT1_ID1, restricted to relationships where JTOT_OBJECT1_CODE equals 'OKX_QUOTELINE'. The item details are then resolved by matching both inventory item and organization. A final predicate excludes top-level model lines unless they are childless, preventing duplication of hierarchical configuration data.

Key Columns

  • LINE_NUMBER — the quote line sequence number, used for ordering and reference.
  • QUOTE_HEADER_ID — the identifier of the parent quote header, enabling grouping of lines by quotation.
  • DESCRIPTION — descriptive text drawn from the system items view.
  • QUANTITY — the quoted or contracted quantity on the line.
  • AMOUNT — the line quote price, aliased from LINE_QUOTE_PRICE.
  • OBJECT1_ID1 — the relationship object identifier linking the contract relationship to the quote line.
  • CHR_ID — the contract line identifier carried on the relationship record.
  • ITEM_NAME — the inventory item name from the system items view.
  • CURRENCY — the currency code applicable to the quote line amount.

Common Use Cases and Queries

Typical scenarios include reconciling quoted pricing against awarded contract lines, reporting quote-to-contract conversion, and feeding downstream order or billing processes. A representative query retrieves all quote lines associated with a given quote header:

SELECT line_number, quote_header_id, item_name, quantity, amount, currency
FROM apps.okc_rel_obj_quote_lines_v
WHERE quote_header_id = :p_quote_header_id
ORDER BY line_number;

A second common pattern aggregates quoted value by item for a set of quotes, joining to OKX quote headers outside this view for customer context. Because all columns are read-only projections, no DML should be issued against the view; writes must target the underlying OKX_QUOTE_LINES and OKC relationship tables through their supported APIs.