Search Results primary_uom_class




Overview
Explore in AI Chat

Overview

POR_RCV_REQUESTOR_V is a view owned by the Oracle iProcurement (ICX) module. As documented in ETRM, its stated purpose is to present receiving-related purchasing data sorted or organized by requester, supporting the iProcurement receiving flow. The name prefix POR aligns it with the Purchasing receive/receiving family of objects, and the suffix REQUESTOR_V indicates it exposes a requester-centric projection of receipt-eligible supply.

The view returns one row per outstanding purchase distribution that still has quantity to receive: specifically, it filters to distributions where DELIVER_TO_PERSON_ID is populated and where (QUANTITY_ORDERED - QUANTITY_DELIVERED - QUANTITY_CANCELLED) > 0. This makes it a candidate-supply view for the "Receive Items" workflow, where a user is shown goods expected against their requested orders. Note that ETRM records the object as not implemented in the documented database and lists no documented base objects, so the definition below is derived from the embedded view text rather than from a live deployment.

Underlying Base Objects

Although ETRM lists no documented referenced base objects, the view text shows a ten-table join across the Purchasing and HR schema:

Key Columns

The view exposes a broad record suitable for a receiving list page. Notable columns include:

Common Use Cases and Queries

The primary use case is presenting a requester's pending receipts. A typical query lists outstanding supply grouped by person:

SELECT requestor, po_number, po_line_number, shipment_num,
       item_description, expected_receipt_qty, ordered_uom,
       expected_receipt_date, source
  FROM por_rcv_requestor_v
 WHERE requestor_id = :person_id
 ORDER BY expected_receipt_date, po_number;

Because REQ_LINE_ID is always null here, joining back to requisition tables is required if requisition context is needed. A filtered query by supplier or need-by window is equally common:

SELECT po_num_rel_num, item_description, quantity_delivered,
       expected_receipt_qty
  FROM por_rcv_requestor_v
 WHERE vendor_id = :vendor_id
    AND need_by_date <= SYSDATE + 7;

The view is best treated as a read-only reporting source for outstanding receipt demand by requester, rather than as an integration interface for requisition linkage.