Search Results stock_locator_control_code

Overview

WSHFV_PACKED_CONTAINER is an APPS-owned view in the Oracle E-Business Suite Order Entry (OE) product family, classified as "Retrofitted" in the ETRM repository. It presents a denormalized, reporting-oriented projection of packed container data held in WSH_PACKED_CONTAINERS, enriched with item master attributes from MTL_SYSTEM_ITEMS and organization-level inventory control settings from MTL_PARAMETERS. The view also joins WSH_DELIVERIES to resolve the human-readable delivery name. This design allows shipping, order management, and inventory reporting to obtain container contents, weights, lot/serial information, and control flags without writing multi-table joins against the underlying shipping execution tables. It is commonly consumed by reports, concurrent programs, and integration extracts that need packed container detail alongside item and organization control semantics.

Underlying Base Objects

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

• WSH_PACKED_CONTAINERS — the driving table, supplying container identity, hierarchy (sequence and parent sequence), packed quantity, gross weight, weight UOM, subinventory, revision, lot and serial attributes, and interface statuses.
• MTL_SYSTEM_ITEMS — joined on inventory item ID and organization ID to supply the item description, primary UOM, and the control code flags (subinventory restriction, revision, lot, serial, locator).
• MTL_PARAMETERS — outer-joined on organization ID to provide organization code, stock locator control, and notably NEGATIVE_INV_RECEIPT_CODE.
• WSH_DELIVERIES — outer-joined on delivery ID to supply DELIVERY_NAME.

The MTL_PARAMETERS and WSH_DELIVERIES joins are outer joins (+), so containers without a resolved delivery or organization parameter row are still returned.

Key Columns

• CONTAINER_ID, DELIVERY_ID, DELIVERY_NAME — container and delivery identity.
• CONTAINER_INVENTORY_ITEM_ID, DESCRIPTION, PRIMARY_UOM_CODE — the packed item and its stocking UOM.
• PACKED_QUANTITY — quantity packed into the container (alias of PC.QUANTITY).
• SEQUENCE_NUMBER, PARENT_SEQUENCE_NUMBER — container hierarchy for nested packing.
• GROSS_WEIGHT, WEIGHT_UOM_CODE — weight and its unit of measure.
• ORGANIZATION_ID, ORGANIZATION_CODE — owning inventory organization.
• SUBINVENTORY, REVISION, LOT_NUMBER, SERIAL_NUMBER, MASTER_SERIAL_NUMBER — inventory tracking attributes.
• SUBINV_RESTRICTED_FLAG, REVISION_CONTROL_FLAG, LOT_CONTROL_FLAG, SERIAL_NUMBER_CONTROL_FLAG — DECODE-derived Y/N flags reflecting item control settings.
• NEGATIVE_INV_RECEIPT_CODE — the organization's negative inventory receipt setting from MTL_PARAMETERS, relevant to the user's search term.
• INVENTORY_INTERFACED_STATUS, RECEIVABLE_INTERFACED_STATUS — interface progress indicators for inventory and receivables processing.
• Audit columns — CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, PROGRAM_ID, REQUEST_ID.

Common Use Cases and Queries

Typical uses include delivery content verification, weight reconciliation for shipping manifests, serial/lot traceability, and checking interface status before downstream processing. A representative query lists packed containers for a delivery with organization receipt settings:

• SELECT container_id, delivery_name, description, packed_quantity, gross_weight, weight_uom_code FROM wshfv_packed_container WHERE delivery_id = :p_delivery_id;
• SELECT container_id, organization_code, negative_inv_receipt_code, lot_number, serial_number FROM wshfv_packed_container WHERE organization_id = :p_org_id AND serial_number IS NOT NULL;
• SELECT container_id, inventory_interfaced_status, receivable_interfaced_status FROM wshfv_packed_container WHERE delivery_id = :p_delivery_id AND inventory_interfaced_status <> 'Y';

Because the view joins item and organization masters, all queries return control flags that would otherwise require additional lookups, making it well suited to ad-hoc reporting and integration extracts.