Results for “shipitem_attribute_category”
17 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
WSH_STND_SHIPITEMS_V is a standard Oracle Shipping Execution (WSH) view owned by the APPS schema. It presents the shipping item details associated with a delivery, exposing line-level shipment attributes such as item, requested quantity, unit of measure, packaging, hazardous material classification, weight/volume, and descriptive flexfield context. The name and structure indicate its role as a "standalone" ship-items view used in shipping documentation, packing slip and bill-of-lading style reports, and integration extracts where delivery content must be reported without the transactional overhead of the base shipping tables.
The view is published and valid within both Oracle EBS 12.1.1 and 12.2.2. It is most frequently referenced in shipping-confirmation and shipping-document reports, and it is the object typically queried when a user searches for the column requested_qty_uom — the requested quantity and its unit of measure for a given shipped or staged delivery line.
Underlying Base Objects
The view is defined over the WSH Shipping core tables plus several reference and lookup views. The documented base objects are:
- WSH_DELIVERY_DETAILS — the primary delivery line table supplying item, requested/shipped quantity and UOM, weights, volumes, tolerances, and attributes (aliased WDD).
- WSH_DELIVERY_ASSIGNMENTS_V — the assignment view supplying parent delivery detail and delivery identifiers (aliased WDA).
- WSH_NEW_DELIVERIES — the delivery header providing customer and delivery context.
- WSH_SERIAL_NUMBERS and MTL_SERIAL_NUMBERS_TEMP — serial number sources.
- MTL_SYSTEM_ITEMS_KFV — the concatenated-segment key flexfield view used to derive the item number with client-aware formatting.
- MTL_CUSTOMER_ITEMS — the customer item cross-reference.
- MTL_CATEGORY_SETS_VL — category set names for freight class and commodity code.
- PO_HAZARD_CLASSES_VL — hazard class descriptions.
- FND_ID_FLEX_STRUCTURES_VL — flexfield structure definition used in item-number segment handling.
- OE_SETS — supporting set/grouping functionality.
The item number is formatted using the key flexfield concatenated segments, with DECODE/SUBSTR logic keyed on the client identifier and the segment delimiter.
Key Columns
- ITEM_NUMBER — the item key flexfield segments, trimmed for client-specific display.
- REQUESTED_QTY / REQUESTED_QTY_UOM — the quantity requested for the delivery line and its unit of measure. This is the column pair surfaced by the user's search term requested_qty_uom.
- SHIPPED_QTY — quantity actually shipped.
- ORDERED_QTY / ORDERED_QTY_UOM — source requested quantity and UOM from the originating order line.
- FREIGHT_CLASS_CAT, COMMODITY_CODE_CAT, HAZARD_CLASS — category and hazard classifications.
- VOLUME / VOLUME_UOM_CODE, NET_WEIGHT / WEIGHT_UOM_CODE — physical shipment measurements.
- TOLERANCE_BELOW / TOLERANCE_ABOVE — shipping tolerance thresholds.
- LOAD_SEQUENCE_NUMBER, SUBINVENTORY, LOT_NUMBER, PREFERRED_GRADE — staging and lot attributes.
- DELIVERY_DETAIL_ID, DELIVERY_ID, SOURCE_LINE_ID, PARENT_DELIVERY_DETAIL_ID — the join keys linking back to delivery and source documents.
- SHIPITEM_ATTRIBUTE1..10 and SHIPITEM_ATTRIBUTE_CATEGORY — descriptive flexfield context for the shipping item.
Common Use Cases and Queries
WSH_STND_SHIPITEMS_V is used for packing slip, bill-of-lading, and shipping-confirmation reports, and for integration extracts feeding external carriers or warehouse systems. A typical query joins the view to deliveries to report requested quantities per item.
- A user seeking requested_qty_uom queries the view directly for delivery content.
- Reports list item, requested quantity, UOM, and shipped quantity by delivery.
- Extracts pull hazard class, freight class, and commodity code for carrier documentation.
- Weight and volume columns drive shipment rating and manifesting.
Sample query:
SELECT si.delivery_id,
si.item_number,
si.requested_qty,
si.requested_qty_uom,
si.shipped_qty,
si.freight_class_cat,
si.hazard_class
FROM apps.wsh_stnd_shipitems_v si
WHERE si.delivery_id = :p_delivery_id
ORDER BY si.load_sequence_number;
Because the view exposes the item-number formatting, requested/shipped UOM columns, and physical measurements in a single row per delivery detail, it is a preferred reporting source over the normalized base tables when the objective is shipment-level documentation.
-
View: WSH_STND_SHIPITEMS_V 12.2.2
APPS.WSH_STND_SHIPITEMS_V·↳ FND_ID_FLEX_STRUCTURES_VL·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·Explore WSH module →
-
View: WSH_SS_SHIPITEMS_V 12.2.2
APPS.WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_ITM_SHIPITEMS_V 12.2.2
Temporary Table to return WSH_SS_SHIPITEMS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_SS_SHIPITEMS_V 12.1.1
APPS.WSH_SS_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
View: WSH_ITM_SHIPITEMS_V 12.1.1
Temporary Table to return WSH_SS_SHIPITEMS_V along with Dummy Records to avoid problems in Retreiving Data while using XSU.
APPS.WSH_ITM_SHIPITEMS_V·↳ MTL_CATEGORY_SETS_VL·↳ MTL_CUSTOMER_ITEMS·↳ MTL_SYSTEM_ITEMS_KFV·Explore WSH module →
-
eTRM - WSH Tables and Views 12.2.2
Stores hierarchy for zones. Each region component of a zone has a record in this table.
-
eTRM - WSH Tables and Views 12.1.1
Stores hierarchy for zones. Each region component of a zone has a record in this table.