Search Results pos_receipt_headers_v




Overview
Explore in AI Chat

Overview

POS_RECEIPT_HEADERS_V is an APPS-owned database view in the Oracle E-Business Suite Purchasing (PO) module. It exposes a consolidated, denormalized projection of receipt header information drawn primarily from the receiving transaction table RCV_SHIPMENT_HEADERS, augmented with descriptive attributes resolved through joins to supplier, organization, location, and employee reference objects. The view does not store data; it is a query-only construct that presents receipt activity in a form suitable for reporting, inquiry screens, and integration extracts.

Because Oracle EBS stores receipt headers using surrogate identifiers (numeric foreign keys, coded lookup values), raw table queries return codes rather than business-meaningful text. POS_RECEIPT_HEADERS_V resolves those identifiers into human-readable values such as vendor name, supplier site code, ship-to location code, and receiver name, and it derives the SOURCE_ORG and SOURCE_TYPE attributes that describe the origin of the receipt. The view filters out rows where RECEIPT_NUM is null, so only fully identified receipt headers are surfaced. This makes it a reliable foundation for receipts-by-source and receipts-by-supplier analysis in a 12.1.1 or 12.2.2 environment.

Underlying Base Objects

The view is defined over the following documented objects in the APPS schema:

Referenced package-level dependencies include FND_GLOBAL, HR_GENERAL, and HR_SECURITY; these typically support organization and security context resolution. All non-driving joins are outer joins, ensuring receipt headers are returned even when a referenced vendor, site, location, or employee record is absent.

Key Columns

Common Use Cases and Queries

Typical uses include receipts reporting by source organization, supplier performance analysis, and inbound shipment tracking. A representative query listing receipts with their source organization is:

  • SELECT RECEIPT_NUM, RECEIPT_DATE, SOURCE_TYPE, SUPPLIER, SOURCE_ORG, SHIP_TO_LOCATION FROM APPS.POS_RECEIPT_HEADERS_V WHERE SOURCE_ORG = :org_name ORDER BY RECEIPT_DATE DESC;

Filtering by supplier and date range supports vendor receipt history extracts:

  • SELECT RECEIPT_NUM, RECEIPT_DATE, VENDOR, SUPPLIER_SITE, SOURCE_ORG FROM APPS.POS_RECEIPT_HEADERS_V WHERE VENDOR = :vendor AND RECEIPT_DATE BETWEEN :from_date AND :to_date;

Because SOURCE_ORG resolves the organization name rather than its ID, users should apply ORG_ORGANIZATION_DEFINITIONS to obtain the ORGANIZATION_ID when integration targets require numeric keys. Note that the view enforces no organization security by itself; callers in a multi-org context should restrict results using session-appropriate organization filters.