Search Results source_organization




Overview
Explore in AI Chat

Overview

POR_RCV_INTERNAL_RECEIPTS_V is a public APPS-owned database view in Oracle E-Business Suite, delivered under the ICX (Oracle iProcurement) product. Status is VALID in both 12.1.1 and 12.2.2. The view presents receiving transaction data as an internal receipt record, projecting receipt, requisition, purchase order, shipment, and inventory organization attributes through a single relational interface. In iProcurement it supports the display and reconciliation of internal receipts — receipts against internal requisitions that transfer material between inventory organizations — alongside externally sourced receipts.

The view is read-only and parameterless. Its most distinctive feature is the derived SOURCE_ORGANIZATION column, which resolves the name of the inventory organization supplying the internally requisitioned material. Because the underlying receiving tables (RCV_TRANSACTIONS, RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES) are shared with Oracle Purchasing and Oracle Inventory, the view serves as a flattened, presentation-oriented projection rather than a stored entity.

Underlying Base Objects

The documented view text selects from the RCV receiving tables and joins outward to requisition, item, and organization entities. ETRM 12.2.2 records the following referenced base objects:

Because HR_SECURITY is referenced, row visibility may be constrained by the organization security profile of the querying responsibility.

Key Columns

Common Use Cases and Queries

Typical applications include reconciling internal requisition receipts, reporting in-transit and delivered quantities between organizations, and auditing receipts against their source requisition and inventory destination.

SELECT transaction_id,
       receipt_num,
       source_organization,
       item_description,
       quantity,
       unit_of_measure,
       organization_id,
       subinventory
  FROM apps.por_rcv_internal_receipts_v
 WHERE source_organization = :p_source_org
   AND transaction_date >= :p_from_date;

For requisition-to-receipt matching:

SELECT requisition_header_id,
       requisition_line_id,
       line_num,
       receipt_num,
       quantity,
       source_organization
  FROM apps.por_rcv_internal_receipts_v
 WHERE requisition_header_id = :p_req_header_id
 ORDER BY line_num, transaction_date;

Because SOURCE_ORGANIZATION is resolved through organization security, queries should be executed from a responsibility whose security profile includes the supplying organizations to avoid incomplete results.