Search Results wsh_ss_containers_v




Overview
Explore in AI Chat

Overview

WSH_SS_CONTAINERS_V is a Shipping Execution (WSH) reporting view owned by the APPS schema and defined with VALID status in Oracle E-Business Suite 12.1.1 and 12.2.2. It presents container and packing information associated with outbound delivery details, exposing container identifiers, seal codes, container type codes, weights, volumes, dimensions, and descriptive item attributes in a single denormalized result set. The view is intended primarily for reporting, label printing, and inbound integration queries where container-level shipment data must be retrieved without navigating the full normalized delivery detail model.

Because the view joins delivery assignments to delivery details and enriches the result with item, location, category, and hazard information, it is frequently used to answer operational questions such as which containers are assigned to a delivery, what their declared gross and net weights are, and how the container contents are categorized. Note that the view does not expose a FILL_PERCENT column; users searching for "fill_percent" will not find that attribute here. Fill percentage is derived at the application layer from volume or weight capacity versus actual loaded quantity rather than being stored on the container record itself.

Underlying Base Objects

The view is defined over the following documented base objects:

The DISTINCT clause in the view text indicates that the join path can produce duplicate rows through assignment or category relationships, and the view suppresses those duplicates.

Key Columns

  • CONTAINER_NAME, SEAL_CODE, CONTAINER_TYPE_CODE — container identity and type classification.
  • ITEM_NUMBER, ITEM_DESCRIPTION — the item packed into the container.
  • DELIVERY_DETAIL_ID, PARENT_DELIVERY_DETAIL_ID, DELIVERY_ID — the delivery hierarchy keys.
  • GROSS_WEIGHT, NET_WEIGHT, WEIGHT_UOM_CODE — declared weights for the container.
  • VOLUME, VOLUME_UOM_CODE — declared container volume; combined with ITEM dimensions, these are the inputs from which fill percentage is typically computed externally.
  • UNIT_HEIGHT, UNIT_LENGTH, UNIT_WIDTH, DIMENSION_UOM_CODE — item dimension attributes from the item master.
  • LOT_NUMBER, REVISION, FROM_SERIAL_NUMBER, TO_SERIAL_NUMBER — lot and serial traceability.
  • SHIP_FROM_LOCATION, DELIVER_TO_LOCATION_ID, ORG_ID, CUSTOMER_ID — organizational and location context.
  • CATEGORY_SET_NAME, HAZARD_CLASS — classification and dangerous-goods information.
  • CONTAINER_ATTRIBUTE1 … CONTAINER_ATTRIBUTE15 — descriptive flexfield columns.

Common Use Cases and Queries

Typical uses include container label generation, freight documentation, load planning reports, and inbound extracts into a warehouse or transportation system. A representative query filtering by delivery and calculating an approximate fill ratio from volume follows:

  • SELECT container_name, item_number, gross_weight, net_weight, volume, volume_uom_code, unit_length, unit_width, unit_height FROM apps.wsh_ss_containers_v WHERE delivery_id = :p_delivery_id ORDER BY container_name;
  • SELECT container_name, item_number, lot_number, from_serial_number, to_serial_number, seal_code FROM apps.wsh_ss_containers_v WHERE org_id = :p_org AND ship_from_location = :p_loc;
  • SELECT container_name, item_number, volume, hazard_class, category_set_name FROM apps.wsh_ss_containers_v WHERE customer_id = :p_customer AND container_type_code = :p_type;

Because FILL_PERCENT is not a column in this view, any report requiring fill percentage must derive it — for example, by comparing packed volume against the container item's unit dimensions or a capacity attribute — rather than selecting it directly from WSH_SS_CONTAINERS_V.