Search Results shipment_quantity




Overview
Explore in AI Chat

Overview

PO_SOURCE_SHIPMENT_NUM_V is an Oracle E-Business Suite PL/SQL view owned by the APPS schema and defined within the Purchasing (PO) product family. Its ETRM description is recorded simply as "10SC ONLY - Retrofitted," indicating that the object originated as a customer-specific or release-specific retrofit rather than as a core, universally shipped Purchasing view. The view is marked VALID at the 12.1.1 and 12.2.2 code levels and surfaces shipment-level scheduling information from planned purchase order line locations, joined to HR location and inventory organization descriptors.

The distinct purpose of the view is to present open, unfulfilled shipment quantity for planned shipments. It excludes shipments that are cancelled or finally closed and applies a HAVING clause so that only rows with a positive remaining quantity are returned. Because the search term "quantity_cancelled" appears in the underlying selection logic, the view is frequently consulted when users need to reconcile original shipment quantities against cancellations and downstream sub-shipment consumption. This makes it useful for reporting, interface extraction, and reconciliation queries where a calculated open-quantity figure is required without reimplementing the cancellation arithmetic.

Underlying Base Objects

The documented referenced base objects are FINANCIALS_SYSTEM_PARAMS_ALL (synonym), HR_GENERAL (package), HR_LOCATIONS (view), HR_SECURITY (package), ORG_ORGANIZATION_DEFINITIONS (view), PO_LINE_LOCATIONS (synonym), and PO_LINE_LOCATIONS_ALL (synonym). The view text is built around a self-join of the line location tables: PO_LINE_LOCATIONS_ALL alias PLL2 is joined to PO_LINE_LOCATIONS alias PLL on PLL.LINE_LOCATION_ID = PLL2.SOURCE_SHIPMENT_ID (+), an outer join that captures sub-shipments referencing a parent planned shipment.

ORG_ORGANIZATION_DEFINITIONS supplies the organization code and name, joined on PLL.SHIP_TO_ORGANIZATION_ID and constrained through FINANCIALS_SYSTEM_PARAMS_ALL on set of books and operating unit. HR_LOCATIONS provides the LOCATION_CODE for the ship-to location. HR_GENERAL and HR_SECURITY participate indirectly, typically through the HR_LOCATIONS view and the organization definitions view, which incorporate security predicates; their inclusion in the reference list reflects the dependency chain rather than direct use in the visible SELECT list. The inclusion of both PO_LINE_LOCATIONS and PO_LINE_LOCATIONS_ALL synonyms reflects inheritance from the two underlying tables.

Key Columns

  • SHIPMENT_NUM — the shipment number on the purchase order line location.
  • LOCATION_CODE — ship-to location code from HR_LOCATIONS.
  • ORGANIZATION — concatenated organization code and name.
  • QUANTITY — the net open shipment quantity, computed as (QUANTITY − NVL(QUANTITY_CANCELLED,0)) less the summed net quantity of child sub-shipments.
  • SHIPMENT_QUANTITY — the shipment quantity net of cancellations, before subtracting sub-shipment consumption.
  • QUANTITY_CANCELLED — appears in the arithmetic; the cancelled portion is removed from both parent and child quantities.
  • UNIT_MEAS_LOOKUP_CODE — unit of measure for the primary quantity.
  • SECONDARY_QUANTITY — the secondary UOM open quantity, calculated with the same cancellation and sub-shipment logic.
  • LINE_LOCATION_ID, PO_LINE_ID, SHIP_TO_LOCATION_ID, SHIP_TO_ORGANIZATION_ID, ORG_ID — identifying keys for joins and reporting.
  • PREFERRED_GRADE — grade attribute carried from the line location.

Common Use Cases and Queries

Typical use is to list open planned shipment quantities by organization and ship-to location, optionally filtering to a single shipment or operating unit.

SELECT shipment_num, organization, location_code,
       quantity, shipment_quantity, unit_meas_lookup_code
FROM   apps.po_source_shipment_num_v
WHERE  org_id = :p_org_id
ORDER  BY organization, shipment_num;

A common reconciliation query compares remaining quantity against the original shipment quantity to expose cancellations and sub-shipment drawdown:

SELECT shipment_num, shipment_quantity, quantity AS remaining,
       shipment_quantity - quantity AS consumed_or_cancelled
FROM   apps.po_source_shipment_num_v
WHERE  line_location_id = :p_line_location_id;

Because the view already filters cancelled and finally closed shipments and enforces a positive remaining quantity, it is well suited to feeding interface programs and open-shipment dashboards without additional WHERE conditions. Users must nonetheless note the "10SC ONLY" designation and validate availability in their specific instance before relying on it in production reporting.