Search Results rcv_enter_receipts_inventory_v




Overview
Explore in AI Chat

Overview

RCV_ENTER_RECEIPTS_INVENTORY_V is an Oracle E-Business Suite view owned by the APPS schema in the Purchasing (PO) product family. The ETRM metadata flags this object with the description "10SC ONLY - Retrofitted," indicating it originates from a customer-specific or release-specific retrofit rather than a standard shipped interface. In Oracle EBS 12.1.1 and 12.2.2, views in the RCV_ENTER_RECEIPTS_* family supply the Receiving open interface and the Enter Receipts user interface with a normalized, flat projection of shipment and receipt data. This particular view provides receipt entry data sourced from shipment lines destined for inventory-facing destinations, presenting the columns expected by the Receiving form and the receiving open interface staging logic. Because it consolidates joined attributes from shipment headers, shipment lines, item master, and organization definitions, it allows applications to query a single row per shipment line without repeating complex multi-table joins.

Underlying Base Objects

The documented base objects underlying this view are:

  • RCV_SHIPMENT_HEADERS (synonym) and RCV_SHIPMENT_LINES (synonym) — the primary transactional sources supplying receipt source code, shipment numbers, quantities shipped, item identifiers, requirement distribution, and destination information.
  • MTL_SYSTEM_ITEMS (synonym) and MTL_UNITS_OF_MEASURE (synonym) — supply item control attributes such as serial number control, lot control, revision quantity control, shelf life, location control, and UOM class.
  • ORG_ORGANIZATION_DEFINITIONS (view) — resolves organization names for the from/to organization identifiers carried on the shipment line.
  • RCV_ROUTING_HEADERS (view) — supplies the routing name associated with the routing header on the shipment line.
  • HR_LOCATIONS_ALL_TL (synonym) — provides the ship-to location code.
  • HR_GENERAL and HR_SECURITY (packages) — invoked for organization and security context resolution used in the view logic.
  • MTL_SUPPLY (synonym) — referenced within the view definition for supply or demand context.

The view text selects from a join of RCV_SHIPMENT_LINES (aliased RSL) and RCV_SHIPMENT_HEADERS (aliased RSH), left-joining MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE, ORG_ORGANIZATION_DEFINITIONS, and RCV_ROUTING_HEADERS. Numerous columns are populated with literal values or typed NULLs (for example, TO_NUMBER(NULL), TO_DATE(NULL)) to satisfy the fixed column signature expected by the consuming form or interface.

Key Columns

Common Use Cases and Queries

This view is typically queried when diagnosing receipt entry behavior, validating what data the Receiving form will present for a shipment line, or building custom reports that require shipment and item control attributes in a single row.

Sample query to inspect outstanding shipment lines for inventory destinations:

SELECT shipment_num, line_num, item_description, unit_of_measure,
       quantity_shipped, to_subinventory, organization_name,
       shelf_life_code, lot_control_code
FROM  apps.rcv_enter_receipts_inventory_v
WHERE  to_organization_id = :org_id
AND    shipment_num = :shipment_num;

A second common pattern filters on the item to review control attributes before receipt:

SELECT item_id, item_revision, serial_number_control_code,
       location_control_code, restrict_locators_code,
       restrict_subinventories_code
FROM  apps.rcv_enter_receipts_inventory_v
WHERE  item_id = :item_id
AND    to_organization_id = :org_id;

Because the view is marked "10SC ONLY - Retrofitted," organizations upgrading between 12.1.1 and 12.2.2 should confirm that the object remains present and valid in their instance, as retrofit views can be superseded by standard seeded views during upgrade. Where it is absent, equivalent data can be assembled directly from RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, and MTL_SYSTEM_ITEMS.