Search Results requested_qty_uom

Overview

CLN_WSH_SS_SHIPITEMS_V is an APPS-owned database view in Oracle E-Business Suite that exposes delivery line detail at the shipment item level. It belongs to the CLN product family — Supply Chain Trading Connector for RosettaNet — which provides the integration framework used to exchange supply chain documents such as purchase orders, ship notices, and invoices with trading partners over the RosettaNet standard. Within that framework, this view serves as a reporting and integration surface that flattens Oracle Shipping execution data into a form suitable for outbound document generation, partner-facing shipment confirmations, and shipment-item analysis.

The view is documented as VALID in both EBS 12.1.1 and 12.2.2. Because it is a view rather than a table, it stores no data of its own; it materializes delivery line details on demand from the underlying Shipping, Inventory, and Purchasing entities. This makes it a read-only, low-maintenance access point that remains consistent with the transactional base tables.

Underlying Base Objects

ETRM metadata for 12.2.2 identifies the following referenced base objects: MTL_CATEGORY_SETS_VL (view), MTL_CUSTOMER_ITEMS (synonym), MTL_SYSTEM_ITEMS_KFV (synonym), PO_HAZARD_CLASSES_VL (view), WSH_DELIVERY_ASSIGNMENTS (synonym), WSH_DELIVERY_DETAILS (synonym), WSH_NEW_DELIVERIES (synonym), and WSH_SERIAL_NUMBERS (synonym).

• WSH_DELIVERY_DETAILS supplies the core delivery line attributes — requested and shipped quantities, weights, volumes, lot and serial references, packing instructions, and shipping instructions.
• WSH_DELIVERY_ASSIGNMENTS links delivery details to deliveries and provides parent delivery detail relationships.
• WSH_NEW_DELIVERIES supplies delivery header context such as delivery identifiers and organization identifiers.
• WSH_SERIAL_NUMBERS is the base object supporting the view's serial number column set, which is directly relevant to the user's search term "from_serial_number".
• MTL_SYSTEM_ITEMS_KFV resolves the concatenated item number and inventory item identifier.
• MTL_CUSTOMER_ITEMS maps internal items to customer-defined item numbers.
• MTL_CATEGORY_SETS_VL resolves category set names, including freight class and commodity code categories.
• PO_HAZARD_CLASSES_VL supplies hazard class codes and identifiers for regulated items.

Key Columns

The view exposes a broad set of shipment line attributes. Identity and linkage columns include DELIVERY_DETAIL_ID, SOURCE_LINE_ID, PARENT_DELIVERY_DETAIL_ID, DELIVERY_ID, ORG_ID, and CUSTOMER_ID. Item identification columns include ITEM_NUMBER (the concatenated segments from MTL_SYSTEM_ITEMS_KFV), INVENTORY_ITEM_ID, CUSTOMER_ITEM_ID, CUSTOMER_ITEM_NUMBER, ITEM_DESCRIPTION, and REVISION.

Quantity and fulfillment columns include REQUESTED_QTY, REQUESTED_QTY_UOM, SHIPPED_QTY, BACKORDERED_QTY, ORDERED_QTY, ORDERED_QTY_UOM, SRC_REQUESTED_QUANTITY, TOLERANCE_BELOW, and TOLERANCE_ABOVE. PARTIAL_SHIPMENT is derived with a DECODE against SHIP_SET_ID. Logistics columns include GROSS_WEIGHT, NET_WEIGHT, WEIGHT_UOM_CODE, VOLUME, VOLUME_UOM_CODE, CONTAINER_TYPE_CODE, CONTAINER_NAME, and COUNTRY_OF_ORIGIN.

Lot and serial tracking are represented through LOT_NUMBER and the WSH_SERIAL_NUMBERS-backed serial columns, which include the from/to serial number range used for serial-controlled shipment reporting. Compliance and handling columns include HAZARD_CLASS, HAZARD_CLASS_ID, FREIGHT_CLASS_CAT, COMMODITY_CODE_CAT, PACKING_INSTRUCTIONS, SHIPPING_INSTRUCTIONS, and SHIPMENT_PRIORITY_CODE (decoded from STANDARD, NORMAL, and HIGH into 01, 02, and 03 respectively).

Common Use Cases and Queries

Typical scenarios include generating RosettaNet ship notice payloads, reconciling shipped versus ordered quantities for partner confirmations, and auditing serial or lot controlled deliveries.

• Listing shipped items for a delivery, including serial ranges:

SELECT delivery_id, delivery_detail_id, item_number,
       shipped_qty, lot_number
FROM   apps.cln_wsh_ss_shipitems_v
WHERE  delivery_id = :p_delivery_id;

• Identifying backordered lines:

SELECT item_number, ordered_qty, shipped_qty, backordered_qty
FROM   apps.cln_wsh_ss_shipitems_v
WHERE  NVL(backordered_qty, 0) > 0;

• Reviewing compliance attributes for export documents:

SELECT item_number, hazard_class, country_of_origin,
       freight_class_cat, commodity_code_cat
FROM   apps.cln_wsh_ss_shipitems_v;

Because the view joins many base objects, queries should filter on DELIVERY_ID, ORG_ID, or DELIVERY_DETAIL_ID to limit execution cost.