Search Results retainage_rate




Overview
Explore in AI Chat

Overview

APPS.POBV_QUOTATION_LINES is a Business Intelligence System (BIS) view in Oracle E-Business Suite Advanced Procurement. The "POBV" prefix identifies it as a Purchasing (PO) business view, a denormalized, reporting-oriented layer defined in FND Design Data as PO.POBV_QUOTATION_LINES. Its documented status is VALID and it is owned by the APPS schema. The view presents item and price information for a good or service quoted on a supplier quotation. In EBS 12.1.1 and 12.2.2, it is a read-only construct intended for reporting, extracts, and integration rather than transactional DML. Quotations are supplier responses to RFQs; each quotation line carries pricing and commercial terms that feed sourcing awards and downstream purchasing documents. The view surfaces these lines together with operating unit context, RFQ linkage, project and task references, and, critically for the user's search, the RETAINAGE_RATE column.

Underlying Base Objects

The documented referenced base objects are HR_ALL_ORGANIZATION_UNITS, PO_HEADERS_ALL, PO_LINES_ALL, and PO_LINE_TYPES, all accessed via synonyms. PO_LINES_ALL is the core transactional table holding quotation lines, identified by QUOTATION_LINE_ID, and the view joins to PO_HEADERS_ALL on QUOTATION_ID for header-level attributes such as the quotation document number. HR_ALL_ORGANIZATION_UNITS supplies OPERATING_UNIT_ID and OPERATING_UNIT_NAME. PO_LINE_TYPES provides LINE_TYPE classification, distinguishing goods from services and other line categories. Because quotations are stored in the same PO_HEADERS_ALL/PO_LINES_ALL structures as purchase orders and RFQs, LINE_TYPE, RFQ_ID, and RFQ_LINE_ID link a quoted line back to its originating request for quotation. Project and task identifiers connect the line to Oracle Projects when the quotation is project-related.

Key Columns

Common Use Cases and Queries

The view supports sourcing analysis, quotation comparison, retainage/progress-payment review, and extracts. A frequent query filters on RETAINAGE_RATE to identify quotations carrying retainage terms:

  • SELECT QUOTATION_DOCUMENT_NUMBER, LINE_NUMBER, ITEM_DESCRIPTION, UNIT_PRICE, RETAINAGE_RATE, MAX_RETAINAGE_AMOUNT FROM APPS.POBV_QUOTATION_LINES WHERE RETAINAGE_RATE IS NOT NULL;
  • SELECT OPERATING_UNIT_NAME, QUOTATION_DOCUMENT_NUMBER, SUM(UNIT_PRICE * MINIMUM_ORDER_QUANTITY) FROM APPS.POBV_QUOTATION_LINES GROUP BY OPERATING_UNIT_NAME, QUOTATION_DOCUMENT_NUMBER;
  • SELECT RFQ_ID, QUOTATION_DOCUMENT_NUMBER, LINE_NUMBER, PROGRESS_PAYMENT_RATE, RECOUPMENT_RATE FROM APPS.POBV_QUOTATION_LINES WHERE RFQ_ID = :rfq_id;
  • SELECT PROJECT_ID, TASK_ID, ITEM_DESCRIPTION, UNIT_PRICE FROM APPS.POBV_QUOTATION_LINES WHERE PROJECT_ID IS NOT NULL;

Always query as APPS or with appropriate PO/Projects read grants; the view is read-only and should not be used for updates.