Search Results rcv_enter_receipts_v




Overview
Explore in AI Chat

Overview

The RCV_ENTER_RECEIPTS_V view is an Oracle E-Business Suite database object owned by the APPS schema and classified under the PO – Purchasing product family. Its documentation describes it as "10SC ONLY – Retrofitted," indicating that it was introduced in a specific legacy or specialized release context and subsequently retrofitted into the standard Receiving (RCV) data model. Functionally, the view presents a consolidated, entry-oriented picture of receipts awaiting or undergoing processing in the Receiving open interface and receipt-entry flows. It exposes purchase order, requisition, shipment, item, and destination attributes in a single flattened structure, allowing receipt clerks, integration programs, and reporting tools to query receipt candidates without joining numerous base tables manually.

In Oracle EBS 12.1.1 and 12.2.2, the view supports the Receiving module's user interface layers and interface processing, providing a denormalized row set that reflects valid receipt sources and destinations. Because it is a view rather than a table, it does not store data; it derives its rows dynamically from its underlying base objects at query time.

Underlying Base Objects

Per the documented ETRM 12.2.2 metadata, RCV_ENTER_RECEIPTS_V references the following base objects:

The view therefore behaves as a union-style aggregator, channeling multiple receipt source types through a common column projection. This design permits a single query surface to retrieve PO, ASN, inventory, RMA, and internal requisition receipts together.

Key Columns

The projection exposes a wide set of identifying and descriptive columns, including:

The DESTINATION_TYPE_CODE column is particularly relevant for determining whether a receipt is destined to inventory, to an expense destination, or to another consuming location.

Common Use Cases and Queries

Typical applications include receipt-entry validation, interface loading, and destination-driven reporting. A representative query filtering by destination type is:

  • SELECT po_number, item_number, ordered_qty, destination_type_code, destination_subinventory FROM apps.rcv_enter_receipts_v WHERE destination_type_code = 'INVENTORY';
  • Querying receipts by source: SELECT receipt_source_code, po_number, vendor_id FROM apps.rcv_enter_receipts_v WHERE receipt_source_code = 'VENDOR';
  • Reporting pending inspections: SELECT po_number, item_number, inspection_required_flag FROM apps.rcv_enter_receipts_v WHERE inspection_required_flag = 'Y';

Because the view is not a base table, it should not be used for direct DML; it serves read-only reporting, interface extraction, and UI support within the Purchasing and Receiving modules.