Results for “source_doc_unit_of_measure”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• RCV_TRANSACTIONS (synonym) — the driving receipt transaction row (RT), providing quantity, unit of measure, destination, locator, vendor, PO, and requisition references.
• RCV_SHIPMENT_HEADERS (synonym, RSH) and RCV_SHIPMENT_LINES (synonym, RSL) — receipt number, shipment number, packing slip, item, category, and receiving source.
• PO_REQUISITION_HEADERS (synonym, PRH) and PO_REQUISITION_LINES (synonym, PRL) — requisition segment, line number, and requisition quantity.
• HR_ALL_ORGANIZATION_UNITS_TL (synonym, OOD) — supplies OOD.NAME as SOURCE_ORGANIZATION.
• MTL_SYSTEM_ITEMS and MTL_UNITS_OF_MEASURE (synonyms) — item and unit-of-measure lookup.
• PER_ALL_PEOPLE_F, PER_PEOPLE_F, PO_SYSTEM_PARAMETERS (synonyms) — employee and system parameter resolution.
• Server-side packages: POR_RCV_TRANSACTION_SV (net delivered quantity), PO_INQ_SV (PO number derivation), HR_GENERAL, HR_PERSON_NAME, HR_SECURITY, and OE_ORDER_IMPORT_INTEROP_PUB.

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

Key Columns

• TRANSACTION_ID, TRANSACTION_TYPE, TRANSACTION_DATE — receipt transaction identity and classification.
• SOURCE_ORGANIZATION — name of the supplying inventory organization, derived from HR_ALL_ORGANIZATION_UNITS_TL.
• ORGANIZATION_ID, SUBINVENTORY, LOCATOR_ID — destination inventory context.
• QUANTITY, PRIMARY_UNIT_OF_MEASURE, UNIT_OF_MEASURE — received quantity and UOM, plus the net delivered quantity returned by POR_RCV_TRANSACTION_SV.
• PO_HEADER_ID, PO_LINE_ID, PO_LINE_LOCATION_ID, PO_DISTRIBUTION_ID, PO_REVISION_NUM, PO_UNIT_PRICE — purchasing document linkage.
• REQUISITION_HEADER_ID, REQUISITION_LINE_ID, LINE_NUM — internal requisition linkage.
• RECEIPT_NUM, SHIPMENT_NUM, PACKING_SLIP, RECEIPT_SOURCE_CODE — shipment-level identification.
• ITEM_ID, ITEM_DESCRIPTION, CATEGORY_ID, ITEM_REVISION — item detail.
• DELIVER_TO_PERSON_ID, DELIVER_TO_LOCATION_ID, VENDOR_ID, VENDOR_SITE_ID — delivery and supplier references.
• DESTINATION_TYPE_CODE, DESTINATION_CONTEXT — routing of the receipt destination.
• ATTRIBUTE1 … ATTRIBUTE15, ATTRIBUTE_CATEGORY — descriptive flexfield segments.
• PO_NUMBER — derived via PO_INQ_SV.GET_SO_NUMBER.

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.