Search Results container_uom_weight_code

Overview

APPS.WSH_LOAD_TENDER_CARGO_V is a Shipping Execution (WSH) view in Oracle E-Business Suite 12.1.1 and 12.2.2 that presents delivery cargo information in a denormalized, container-oriented structure suitable for load tendering and shipment reporting. The view flattens the relationship between a delivery, its assigned container instances, and the individual items packed within those containers into a single row per cargo combination. This design supports outbound integration with transportation management systems, carrier load-tender messages, and ad hoc reporting where the container-to-item hierarchy must be exposed without navigating the underlying assignment tables directly. The view is owned by the APPS schema and holds VALID status in the ETRM metadata. A distinctive feature is the computed CARGO_PK column, which concatenates the delivery identifier, container name, and item delivery detail identifier to produce a synthetic primary key for cargo records. The user search term item_serial_number maps directly to a column exposed by this view, making it a common entry point for serial-number-driven shipment queries.

Underlying Base Objects

The view is defined over three documented base objects, all referenced as synonyms in the APPS schema:

• WSH_NEW_DELIVERIES (WND) — supplies the delivery header, keyed by DELIVERY_ID.
• WSH_DELIVERY_ASSIGNMENTS (WDA) — links the delivery to its delivery details, joining DELIVERY_ID and DELIVERY_DETAIL_ID.
• WSH_DELIVERY_DETAILS (WDD1 and WDD2) — the same table is joined twice: once as WDD1 representing the container-level detail, and once as WDD2 representing the item-level detail.

Both joins to WSH_DELIVERY_DETAILS are outer joins ((+)), so deliveries without an assigned container or item detail still appear in the result set. The container alias WDD1 provides container attributes such as CONTAINER_NAME, SEAL_CODE, SERIAL_NUMBER, and weight/volume figures, while WDD2 provides item attributes including SERIAL_NUMBER (aliased as ITEM_SERIAL_NUMBER), ITEM_DESCRIPTION, hazard classification, and shipped/delivered quantities.

Key Columns

• CARGO_PK — synthetic key formed from delivery ID, container name, and item delivery detail ID.
• DELIVERY_ID — the delivery header identifier.
• CONTAINER_INSTANCE_ID / CONTAINER_NUMBER — the container's delivery detail ID and its human-readable name.
• SEAL_NUMBER / SERIAL_NUMBER — seal code and the container's own serial number.
• CONTAINER_TYPE / CONTAINER_DESCRIPTION / CONTAINER_QUANTITY / CONTAINER_QUANTITY_UOM — container classification, description, and shipped quantity with unit of measure.
• CONTAINER_GROSS_WEIGHT / CONTAINER_NET_WEIGHT / CONTAINER_UOM_WEIGHT_CODE — container weight measures and their UOM.
• ITEM_DETAIL_ID / ITEM_DESCRIPTION — the item-level delivery detail identifier and description.
• ITEM_SERIAL_NUMBER — the serial number of the packed item; this is the column returned by the user's item_serial_number search.
• ITEM_SHIPPED_QUANTITY / ITEM_DELIVERED_QUANTITY / ITEM_SHIP_QUANTITY_UOM — item quantities and UOM.
• ITEM_HAZARD_CODE / ITEM_CLASSIFICATION / ITEM_COUNTRY_OF_ORIGIN — regulatory and classification attributes.
• ITEM_CUST_PO_NUMBER — customer purchase order reference at item level.

Common Use Cases and Queries

The view is typically queried to report container contents, trace serially controlled items within shipments, and feed load-tender interfaces. A representative query retrieving items by serial number is:

• SELECT cargo_pk, delivery_id, container_number, item_detail_id, item_serial_number, item_shipped_quantity FROM wsh_load_tender_cargo_v WHERE item_serial_number = :serial_number;
• SELECT delivery_id, container_number, item_description, item_shipped_quantity FROM wsh_load_tender_cargo_v WHERE delivery_id = :delivery_id ORDER BY container_number;
• SELECT container_number, item_hazard_code, item_country_of_origin FROM wsh_load_tender_cargo_v WHERE delivery_id = :delivery_id AND item_hazard_code IS NOT NULL;

Because the view applies outer joins, queries should account for NULL container or item columns when a delivery has not yet been fully packed. Filtering on ITEM_SERIAL_NUMBER is the most direct way to locate a specific serially controlled unit across all deliveries and containers.