Search Results rfq_close_date




Overview
Explore in AI Chat

Overview

APPS.PO_RFQS_FOR_QUOTE_ALL_V is a reporting and inquiry view in the Oracle Purchasing module of Oracle E-Business Suite, registered under the FND Design Data object PO.PO_RFQS_FOR_QUOTE_ALL_V. Its purpose is to present a consolidated, quote-oriented perspective of Request for Quotation (RFQ) headers together with the vendors and vendor sites invited to respond. The view isolates the subset of RFQ information required by the sourcing and quotation workflow, so that standard Oracle Applications programs and inquiry screens can retrieve candidate RFQs without navigating the full PO_HEADERS structure directly.

Because the object name carries the _ALL_V suffix, it is multi-organization aware: the ORG_ID column exposes the operating unit under which each RFQ was created, and the definition references FND_GLOBAL to resolve the current organization context at runtime. The view status is documented as VALID, and Oracle explicitly notes that this is an internal object not supported for direct customer access outside standard Oracle Applications programs. The column list makes the business intent clear: SEGMENT1 (the RFQ number), DISPLAYED_FIELD, RFQ_CLOSE_DATE, COMMENTS, and PO_HEADER_ID identify the RFQ itself, while TYPE_LOOKUP_CODE, APPROVAL_REQUIRED_FLAG, and QUOTATION_CLASS_CODE carry sourcing attributes.

Underlying Base Objects

The view is defined over the following documented objects:

  • PO_HEADERS (synonym) — the primary source of RFQ header information, including SEGMENT1, COMMENTS, and the header identifier.
  • PO_RFQ_VENDORS (synonym) — supplies the vendor/site invitations associated with each RFQ.
  • PO_VENDORS (view) — provides VENDOR_NAME and the vendor key.
  • PO_VENDOR_SITES_ALL (view) — supplies VENDOR_SITE_CODE and vendor site identification across organizations.
  • PO_LOOKUP_CODES (view) — resolves lookup codes such as TYPE_LOOKUP_CODE and QUOTATION_CLASS_CODE into meaningful values.
  • FND_GLOBAL (package) — supplies session-level context, most notably the current organization (ORG_ID).

The view is not referenced by any other database object, confirming its role as a terminal reporting/inquiry layer rather than a building block for further dependent views.

Key Columns

  • SEGMENT1 (VARCHAR2 20) — the RFQ number, the principal user-facing identifier.
  • RFQ_CLOSE_DATE (DATE) — the date on which the RFQ closes for supplier responses; the column most frequently searched by users.
  • PO_HEADER_ID (NUMBER) — the surrogate key linking back to PO_HEADERS.
  • DISPLAYED_FIELD (VARCHAR2 80) — a concatenated display value for the RFQ.
  • COMMENTS (VARCHAR2 240) — free-text notes held on the RFQ header.
  • TYPE_LOOKUP_CODE, QUOTATION_CLASS_CODE, APPROVAL_REQUIRED_FLAG — sourcing classification and approval attributes.
  • VENDOR_ID, VENDOR_NAME, VENDOR_SITE_ID, VENDOR_SITE_CODE — the invited supplier and site.
  • ORG_ID (NUMBER) — operating unit identifier for multi-org security and filtering.

Common Use Cases and Queries

Typical scenarios include identifying RFQs approaching their close date, listing suppliers invited to a given RFQ, and feeding custom sourcing or quotation dashboards. The following example returns open RFQs and their invited vendors, filtered by organization:

SELECT SEGMENT1,
       RFQ_CLOSE_DATE,
       VENDOR_NAME,
       VENDOR_SITE_CODE,
       ORG_ID
FROM   APPS.PO_RFQS_FOR_QUOTE_ALL_V
WHERE  RFQ_CLOSE_DATE >= SYSDATE
AND    ORG_ID = :p_org_id
ORDER BY RFQ_CLOSE_DATE;

A second common pattern links the view back to the RFQ header for additional attributes:

SELECT V.SEGMENT1,
       V.VENDOR_NAME,
       H.AUTHORIZATION_STATUS
FROM   APPS.PO_RFQS_FOR_QUOTE_ALL_V V,
       APPS.PO_HEADERS H
WHERE  V.PO_HEADER_ID = H.PO_HEADER_ID
AND    V.RFQ_CLOSE_DATE BETWEEN :p_start AND :p_end;

Because Oracle classifies this view as internal and unsupported for direct access, any custom use should be treated as read-only and validated against the target release (12.1.1 or 12.2.2) before deployment in production reporting.