Search Results from_interface




Overview
Explore in AI Chat

Overview

APPS.RCV_DISTRIBUTIONS_PRINT_INV is an Oracle E-Business Suite internal view that consolidates receiving distribution and delivery information for reporting, printing, and downstream warehouse processing. It is registered in the Applications schema (APPS) under the FND Design Data product code PO, with a status of VALID. The view is classified as "Oracle Internal Use Only": Oracle Corporation does not support direct access to application data through this object except from standard Oracle Applications programs. Developers and integrators should therefore treat it as a read-only reporting construct rather than a supported API surface.

The view presents delivery-centric shipment lines, combining receipt transaction details, on-hand/supply quantities, organizational context, and delivery destination attributes. Its most notable characteristic is that it exposes a denormalized destination model — person, location, and organization are stored as separate VARCHAR2 columns — which allows receiving and shipping reports to display human-readable destination values without additional joins. This denormalization is why the view is frequently encountered when users search for the attribute deliver_to_org.

Underlying Base Objects

The documented reference list for this view includes the following base objects:

Together these objects make the view a cross-functional join spanning Purchasing, Inventory, Human Resources, and Warehouse Management System data.

Key Columns

Common Use Cases and Queries

Typical scenarios include printing receiving distribution reports, reconciling outstanding versus delivered quantities by destination, and tracing deliveries to WIP or inventory destinations. The following query groups outstanding quantities by delivery organization and destination subinventory:

SELECT deliver_to_org,
       destination_subinventory,
       SUM(outstanding_quantity) outstanding_qty
FROM   apps.rcv_distributions_print_inv
WHERE  organization_id = :p_org_id
GROUP  BY deliver_to_org, destination_subinventory;

A second pattern lists pending deliverables for a given person or location:

SELECT document_num,
       deliver_to_person,
       deliver_to_location,
       deliver_transaction_type,
       delivery_date,
       quantity_delivered
FROM   apps.rcv_distributions_print_inv
WHERE  organization_id = :p_org_id
AND    NVL(delivery_date, SYSDATE) >= NVL(:p_from_date, SYSDATE);

Because the view is flagged Oracle Internal Use Only, these queries are appropriate for diagnostic and reporting purposes only. Oracle's supported approach is to obtain equivalent data through standard receiving and shipping program outputs or through the published receiving APIs, rather than by embedding direct references to RCV_DISTRIBUTIONS_PRINT_INV in custom application code.