Search Results rcv_receipts_print_inv




Overview
Explore in AI Chat

Overview

RCV_RECEIPTS_PRINT_INV is an Oracle E-Business Suite view owned by the APPS schema and classified under the Purchasing (PO) product family. It is a specialized print view of receipts, designed to expose receiving information in a report-ready, denormalized layout for inventory-sourced receipt transactions. Unlike the operational base tables that store receiving data across normalized structures, this view flattens the receipt header, shipment line, transaction, and location details into a single row set suitable for printing, reporting, and reconciliation.

The view's defining characteristic is its restriction to receipts whose receipt source code is 'INVENTORY'. This means the view does not surface supplier-originated receipts in the same way as its non-inventory counterpart; it is deliberately scoped to inventory receipts processed through the receiving open interface and transaction tables. The view text selects a mix of real column values and literal placeholders (empty strings and NULL numbers) to preserve positional integrity expected by downstream printing routines. In Oracle EBS 12.1.1 and 12.2.2 the object carries a VALID status and is referenced in ETRM documentation under the PO module.

Underlying Base Objects

The view joins several documented base objects. RCV_SHIPMENT_HEADERS supplies header-level data such as receipt number, shipment number, expected receipt date, freight carrier, and packing slip. RCV_SHIPMENT_LINES provides line-level attributes including item, revision, category, vendor item number, quantity shipped, and quantity received. RCV_TRANSACTIONS contributes transaction details such as quantity, primary quantity, transaction date, subinventory, locator, and vendor lot number.

Supporting joins enrich the output: RCV_ROUTING_HEADERS supplies the routing name; PO_LOOKUP_CODES is referenced twice (aliased PLC1 and PLC2) to translate lookup codes into displayed fields; PER_ALL_PEOPLE_F resolves the receiver's first and last name; HR_LOCATIONS_ALL_TL provides location codes for both the receiver and shipment location; HR_ORGANIZATION_UNITS returns the organization name; and FINANCIALS_SYSTEM_PARAMS_ALL binds organizational or system parameters. Two references to WMS_LICENSE_PLATE_NUMBERS (WLPN1 and WLPN2) expose the license plate number and transfer license plate number. The view also indirectly relies on security and utility packages including FND_GLOBAL, HR_SECURITY, and HR_GENERAL, which govern data access and organizational filtering.

Key Columns

Common Use Cases and Queries

The view is typically used for printed receiving reports, inventory receipt reconciliation, and audit of goods received against shipments. A sample query filtering by receipt number:

  • SELECT receipt_num, shipment_num, item_description, quantity, primary_quantity, transaction_date FROM apps.rcv_receipts_print_inv WHERE receipt_num = :p_receipt_num;
  • SELECT shipment_num, vendor_item_num, license_plate_number, subinventory FROM apps.rcv_receipts_print_inv WHERE shipment_header_id = :p_header_id;
  • SELECT receipt_num, first_name, last_name, location_code, routing_name FROM apps.rcv_receipts_print_inv WHERE transaction_date BETWEEN :p_from AND :p_to;

Because the view restricts rows to inventory-sourced receipts and joins HR security tables, query results are subject to organization and user access restrictions enforced through HR_SECURITY and FND_GLOBAL. This makes it well suited for secured operational reporting rather than unrestricted data extraction.