Search Results rcv_enter_receipts_sup_int_v




Overview
Explore in AI Chat

Overview

The RCV_ENTER_RECEIPTS_SUP_INT_V view is an Oracle E-Business Suite dictionary object owned by the APPS schema and classified under the PO – Purchasing product family. Its ETRM documentation describes it as "10SC ONLY – Retrofitted," indicating that the object originates from a specialized or customer-specific receiving implementation and has been retrofitted into the standard EBS Release 12.1.1 / 12.2.2 data model. In practical terms, the view presents a unified, horizontally integrated record of supplier-facing receipt entry data, consolidating purchase order shipments, requisition lines, ASN information, and inventory destination attributes into a single queryable structure.

Its role is that of an integration and reporting surface: rather than exposing the fragmented transaction tables used by the Receiving open interface, it returns a pre-joined rowset suitable for supplier portal displays, receipt entry screens, and inbound interface staging.

Underlying Base Objects

According to the documented 12.2.2 metadata, the view is defined over the following referenced objects:

The four RCV_ENTER_RECEIPTS_* views are unioned or joined to provide a single receipt-entry rowset spanning ASN, internal requisition, inventory, and PO sources, while the HR_* packages supply the multi-org and security predicates and PO_CLM_INTG_GRP supplies purchasing integration rules.

Key Columns

The SELECT list is extensive. Noteworthy column groups include:

Common Use Cases and Queries

Typical uses include supplier portal receipt entry, inbound receiving validation, and reconciliation reporting. A representative query:

  • SELECT po_number, po_shipment_number, item_number, ordered_qty, ordered_uom, vendor_item_number, expected_receipt_date FROM apps.rcv_enter_receipts_sup_int_v WHERE vendor_id = :p_vendor_id AND rcv_shipment_number IS NULL;
  • Filtering by SOURCE_TYPE_CODE to isolate ASN, inventory, or PO-originated lines.
  • Joining on RCV_SHIPMENT_HEADER_ID to correlate staged interface rows with confirmed receipts.