Search Results shipping_quantity




Overview
Explore in AI Chat

Overview

APPS.GML_OM_SHIP_DTL_VW is a public Oracle EBS view owned by the APPS schema and registered under FND Design Data as GMF.GML_OM_SHIP_DTL_VW. Its status is VALID in both 12.1.1 and 12.2.2. The view is explicitly documented as OBSOLETE and is described as selecting Order Management shipments and their related information from Oracle Process Manufacturing (OPM) Inventory transactions. Because it is a public view, Oracle classifies it as potentially useful for custom reporting or other data requirements, though the obsolete designation means it is not intended for new development and should be regarded as a compatibility or legacy reporting object rather than a supported integration interface.

For users searching on "shipping_quantity," this view is directly relevant: it exposes a SHIPPING_QUANTITY column alongside SHIPPING_QUANTITY_UOM, allowing shipped quantities to be reported against the originating OM order line and the associated delivery detail. The combination of delivery, order, item, and inventory transaction attributes makes the view useful where a single query must reconcile OM shipment activity against OPM inventory movement.

Underlying Base Objects

The view is defined over the following APPS synonyms, which resolve to the underlying base tables:

The view is not referenced by any other database object, confirming it sits at the top of the dependency chain as a reporting endpoint. Its joins align a WSH delivery detail with its assignment and delivery record, back to the originating OE order header and line, and out to the OPM inventory transaction pending row for the item and warehouse involved.

Key Columns

  • SHIPPING_QUANTITY — the shipped quantity for the delivery detail, expressed in SHIPPING_QUANTITY_UOM. This is the primary column for shipped-quantity reporting.
  • SHIPPING_QUANTITY_UOM — the unit of measure for the shipping quantity.
  • DELIVERY_ID, DELIVERY_DETAIL_ID — delivery header and detail identifiers.
  • SOURCE_HEADER_ID, SOURCE_LINE_ID — the originating OM order header and line identifiers.
  • ORDER_NUMBER, LINE_NUMBER — human-readable order and line references.
  • ITEM_ID, ORGN_CODE, WHSE_CODE — item and inventory organization/warehouse context.
  • IC_TRANS_QTY, TRANS_UM — OPM inventory transaction quantity and its transaction UOM.
  • NET_WEIGHT, WEIGHT_UOM_CODE — shipment net weight and its UOM.
  • FOB_CODE, UNIT_SELLING_PRICE — commercial shipping and pricing attributes.
  • COMPLETED_IND, GL_POSTED_IND — flags indicating completion and general ledger posting status.

Common Use Cases and Queries

Typical scenarios include reconciling OM shipments to OPM inventory transactions, reporting shipped quantity by order line or item, and auditing GL posting status for shipped deliveries. A basic shipped-quantity query follows:

  • SELECT order_number, line_number, item_id, shipping_quantity, shipping_quantity_uom FROM apps.gml_om_ship_dtl_vw ORDER BY order_number, line_number;
  • SELECT orgn_code, whse_code, SUM(shipping_quantity) total_shipped FROM apps.gml_om_ship_dtl_vw GROUP BY orgn_code, whse_code;
  • SELECT delivery_id, delivery_detail_id, ic_trans_qty, trans_um FROM apps.gml_om_ship_dtl_vw WHERE completed_ind = 1 AND gl_posted_ind = 0;

Because the view is obsolete, new customizations should generally query the underlying WSH, OE, and IC tables directly, or use supported OPM and OM APIs, treating GML_OM_SHIP_DTL_VW as a legacy convenience view only.