Search Results pobv_quotation_lines




Overview
Explore in AI Chat

Overview

POBV_QUOTATION_LINES is an APPS-owned read-only view in the Oracle E-Business Suite Purchasing (PO) module, documented in ETRM for releases 12.1.1 and 12.2.2 and flagged as retrofitted. It presents supplier quotation line detail drawn from the transactional purchasing tables, filtered so that only lines belonging to documents whose header type is QUOTATION are returned. Quotations represent supplier responses to requests for quotation, capturing pricing, quantity boundaries, and vendor product references. The view exposes a denormalized, business-friendly projection of that data, joining the quotation line to its header, line type, and operating unit so that report authors and integration developers can retrieve header and organization context without writing the join logic themselves.

The view implements an organization security predicate (the '_SEC:QL.ORG_ID' clause visible in the view text) and is defined WITH READ ONLY, meaning no DML may be issued against it. Because it reads directly from the base purchasing tables rather than a materialized snapshot, results always reflect the committed state of the underlying quotation transactions.

Underlying Base Objects

The view is defined over four base objects, all referenced through synonyms in the APPS schema:

The header join is an inner join, so only lines on quotation-type headers appear. The line type join is outer, allowing lines with an unresolved LINE_TYPE_ID to remain visible.

Key Columns

Column names exposed by the view are the report-facing aliases; several map to differently named base columns.

Common Use Cases and Queries

Typical uses include quotation price-list reporting, supplier response analysis, RFQ-to-quotation reconciliation, and inbound integration extracts. All queries are restricted by the view's built-in organization security; the accessing responsibility's organization context applies automatically.

Retrieve lines for a specific quotation document number:

  • SELECT quotation_document_number, line_number, item_description, unit_price, minimum_order_quantity, maximum_order_quantity FROM apps.pobv_quotation_lines WHERE quotation_document_number = :doc_num ORDER BY line_number;

List all quotation lines for an operating unit, with line type:

  • SELECT quotation_document_number, line_number, line_type, item_id, unit_price FROM apps.pobv_quotation_lines WHERE operating_unit_name = :org_name ORDER BY quotation_document_number, line_number;

Trace a quotation line back to its originating RFQ:

  • SELECT quotation_document_number, line_number, rfq_id, rfq_line_id FROM apps.pobv_quotation_lines WHERE quotation_line_id = :line_id;