Search Results okx_quote_lines_v




Overview
Explore in AI Chat

Overview

OKX_QUOTE_LINES_V is an APPS-owned database view within the Oracle E-Business Suite OKX - Contracts Integration product. It exposes quote line information sourced from Oracle Advanced Pricing and Oracle Order Capture quotation data, and is classified as a valid object in both EBS 12.1.1 and 12.2.2 environments. The view functions as a simplified, read-only projection of quote line records, presenting a curated subset of attributes from the underlying quote line table while applying a derived STATUS value and supplying placeholder columns for NAME and DESCRIPTION.

Because the object is a view rather than a base table, it carries no data of its own and introduces no storage or maintenance overhead. Its primary role is to provide integration and reporting consumers — particularly within the Contracts Integration flow — a stable, denormalized access point for quote line pricing, invoicing, and party information. The INVOICING_RULE_ID column, which is the attribute most frequently associated with this view in user searches, is a key element for downstream billing and invoice generation logic.

Underlying Base Objects

The view is defined over a single documented base object: ASO_QUOTE_LINES_ALL, referenced as a synonym. ASO_QUOTE_LINES_ALL is the master quotation line table in the Order Capture schema, storing one row per quote line across all operating units. The view aliases this table as LIN and selects columns directly from it without joins, unions, or aggregations, meaning the cardinality of OKX_QUOTE_LINES_V matches that of ASO_QUOTE_LINES_ALL one-to-one. No filtering predicate appears in the documented view text, so all quote lines are exposed, including those across multiple ORG_ID values.

Note that the documented view text ends mid-statement at INVOICE_TO_CUST_ACCOUNT_ID; the ETRM excerpt does not show the closing FROM clause details or any WHERE restriction, but the column list and the alias LIN confirm the single-table derivation.

Key Columns

  • QUOTE_LINE_ID — Not exposed as a standalone column; it is mapped to ID1 in the view text, serving as the unique line identifier.
  • QUOTE_HEADER_ID — Foreign key to the parent quote header, linking each line to its quotation.
  • ORG_ID — Operating unit identifier, supporting multi-org reporting and access control.
  • INVENTORY_ITEM_ID, ORGANIZATION_ID, QUANTITY, UOM_CODE — Item and quantity attributes describing what is being quoted.
  • LINE_LIST_PRICE, LINE_QUOTE_PRICE — List and negotiated price amounts for the line.
  • PRICE_LIST_ID, PRICE_LIST_LINE_ID — References to the price list and specific price list line applied.
  • INVOICING_RULE_ID — Identifies the invoicing rule governing how the line is billed, critical for revenue scheduling and invoice generation.
  • INVOICE_TO_PARTY_ID, INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_CUST_ACCOUNT_ID — Billing destination attributes for the quote line.
  • STATUS — A derived value computed with DECODE/SIGN logic: returns 'I' (inactive) when SYSDATE precedes START_DATE_ACTIVE or exceeds END_DATE_ACTIVE, otherwise 'A' (active).
  • NAME, DESCRIPTION — Returned as NULL placeholders, indicating they are intentionally suppressed in this projection.

Common Use Cases and Queries

Typical usage centers on reporting active quote lines and retrieving invoicing metadata. Because INVOICING_RULE_ID is exposed directly, analysts frequently query it to reconcile quotation billing rules against AR invoice setup.

To list active quote lines for an operating unit:

  • SELECT QUOTE_HEADER_ID, LINE_NUMBER, INVENTORY_ITEM_ID, QUANTITY, LINE_QUOTE_PRICE, INVOICING_RULE_ID FROM APPS.OKX_QUOTE_LINES_V WHERE ORG_ID = :org_id AND STATUS = 'A';

To find lines tied to a specific invoicing rule for billing review:

  • SELECT QUOTE_HEADER_ID, LINE_NUMBER, INVOICE_TO_CUST_ACCOUNT_ID, INVOICING_RULE_ID FROM APPS.OKX_QUOTE_LINES_V WHERE INVOICING_RULE_ID = :rule_id;

To examine price list alignment and negotiated pricing:

  • SELECT LINE_NUMBER, LINE_LIST_PRICE, LINE_QUOTE_PRICE, PRICE_LIST_ID, PRICE_LIST_LINE_ID FROM APPS.OKX_QUOTE_LINES_V WHERE QUOTE_HEADER_ID = :header_id;

These queries should respect the multi-org ORG_ID filter and, where applicable, standard EBS security profiles to ensure consistent results across 12.1.1 and 12.2.2 releases.