Search Results master_container_id

Overview

The APPS.WSH_PACKED_CONTAINERS_V view is a reporting and integration construct within the Oracle E-Business Suite Order Entry (OE) module. It exposes packing container information maintained by the Warehouse Management (WSH) application, presenting container-level detail such as quantities, weights, volumes, parent-child container relationships, and inventory item attributes. The view is defined over the WSH_PACKED_CONTAINERS base table and enriches each container record with descriptive and control attributes drawn from the MTL_SYSTEM_ITEMS and MTL_PARAMETERS tables.

Because it joins container data to the inventory item master and organization parameters, the view is particularly useful for reporting scenarios that require both packing structure (for example, parent container, master container, and sequence) and the associated item and organization control settings. This makes it valuable across shipping, order fulfillment, and logistics reporting where container contents must be reconciled against item and warehouse definitions.

Underlying Base Objects

The view is defined over three documented base objects, all exposed through APPS synonyms:

• WSH_PACKED_CONTAINERS — the primary table holding the packed container records, aliased as PC. This supplies container identifiers, delivery associations, quantities, weights, volumes, serial and lot details, and descriptive flexfield attributes.
• MTL_SYSTEM_ITEMS — the inventory item master, aliased as MSI. It supplies item description, primary unit of measure, fill controls, volumetric attributes, and control codes for subinventories, revisions, lots, serials, and locators.
• MTL_PARAMETERS — the organization parameters table, aliased as ORG. It supplies organization-level stock locator and negative inventory receipt control settings.

The join links container records to items by inventory item ID and organization ID, and links to organization parameters by organization ID using an outer join (ORG.ORGANIZATION_ID(+) = MSI.ORGANIZATION_ID), ensuring container rows are retained even where organization parameters are absent.

Key Columns

• CONTAINER_ID — unique identifier for the packed container; the primary key of the underlying table.
• DELIVERY_ID — the delivery to which the container belongs.
• PARENT_CONTAINER_ID / MASTER_CONTAINER_ID — hierarchy pointers. master_container_id identifies the top-level container in the packing hierarchy, while parent_container_id identifies the immediate parent, enabling nested container structures to be reconstructed.
• PARENT_SEQUENCE_NUMBER / SEQUENCE_NUMBER — ordering positions within the packing structure.
• GROSS_WEIGHT, NET_WEIGHT, TARE, WEIGHT_UOM_CODE — weight measures. TARE is computed as gross weight minus net weight.
• VOLUME, VOLUME_UOM_CODE, FILL_PERCENT — volumetric data, including fill percentage against item capacity.
• CONTAINER_INVENTORY_ITEM_ID, DESCRIPTION, PRIMARY_UOM_CODE — item identity and description for the container item.
• LOT_NUMBER, REVISION, SERIAL_NUMBER, MASTER_SERIAL_NUMBER — tracking attributes, with control flags derived from item master codes.
• ORGANIZATION_ID, SUBINVENTORY, INVENTORY_LOCATION_ID, INVENTORY_STATUS — inventory placement and status details.
• ATTRIBUTE1 through ATTRIBUTE15 — descriptive flexfield columns carried through from the base table.
• CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY — standard audit columns.

Common Use Cases and Queries

A frequent requirement is to retrieve all containers belonging to a master container, which supports hierarchy reporting and manifest generation:

• List containers for a specific master container:

SELECT container_id, parent_container_id, master_container_id,
       sequence_number, quantity, gross_weight, net_weight
  FROM apps.wsh_packed_containers_v
 WHERE master_container_id = :master_container_id
 ORDER BY sequence_number;

• Summarize total weight and volume per delivery for shipment planning:

SELECT delivery_id, SUM(gross_weight) total_gross, SUM(volume) total_volume
  FROM apps.wsh_packed_containers_v
 GROUP BY delivery_id;

• Identify containers with serial or lot control for compliance reporting:

SELECT container_id, delivery_id, serial_number, lot_number, revision
  FROM apps.wsh_packed_containers_v
 WHERE serial_number IS NOT NULL
    OR lot_number IS NOT NULL;

These queries leverage the view's combination of packing hierarchy, measurement, and item control data, making it suitable for reporting, integration, and reconciliation tasks without requiring callers to assemble the underlying three-table join themselves.