Search Results ordered_qty




Overview
Explore in AI Chat

Overview

POR_RCV_SUPPL_V is a reporting view owned by the Oracle iProcurement (ICX) module in Oracle E-Business Suite 12.1.1 and 12.2.2. Its documented purpose is to support the querying of items that are available to receive, filtered and searched by supplier. In practice, the view consolidates purchase order, purchase release, shipment, distribution, item, and supplier information into a single denormalized result set that the iProcurement receiving and search flows can consume without joining the underlying purchasing tables directly.

The view does not persist data; it is a read-only projection over transactional purchasing tables. It exposes pending receipt quantities, shipment attributes, supplier details, and expected receipt dates so that receiving personnel and iProcurement search pages can identify open, approved, and receivable purchase order distributions. Note that the ETRM metadata records this object as "Not implemented in this database" for the referenced environment, meaning the view text exists as documentation but the object may not be deployed in every instance. The user's search term "ordered_qty" maps directly to a column of this view.

Underlying Base Objects

Although the ETRM metadata documents "none" as referenced base objects, the view text explicitly joins a fixed set of purchasing and inventory tables. These are:

Filtering logic restricts results to distributions with a positive open quantity, shipments with an approved flag of 'Y', a non-cancelled status, an open (non-closed, non-finally-closed) closed code, and shipment types of STANDARD, BLANKET, or SCHEDULED.

Key Columns

Common Use Cases and Queries

Typical use is supplier-driven receiving search, where the user filters by vendor and retrieves open items awaiting receipt. A representative query selecting the requested column follows:

  • SELECT PO_NUMBER, PO_LINE_NUMBER, ITEM_DESCRIPTION, ORDERED_QTY, EXPECTED_RECEIPT_QTY, SOURCE FROM POR_RCV_SUPPL_V WHERE SOURCE = :supplier AND ORDERED_QTY > 0;
  • Aggregating expected receipts by supplier for receiving workload planning.
  • Driving iProcurement receiving pages with approved, open shipments only.
  • Excluding finally closed or cancelled shipments via the built-in filters.