Search Results wsh_delivery_details




Here's a detailed description of the WSH_DELIVERY_DETAILS table in Oracle E-Business Suite (EBS):

Table Name: WSH_DELIVERY_DETAILS

Purpose:
The WSH_DELIVERY_DETAILS table stores detailed information about individual delivery lines within a delivery in the Shipping and Transportation module of Oracle EBS.

Key Columns:
1. DELIVERY_DETAIL_ID (Primary Key)
- Unique identifier for each delivery detail record
- Typically a sequenced number

2. DELIVERY_ID
- Links to the parent delivery in WSH_DELIVERIES table
- Establishes relationship between delivery header and details

3. ORGANIZATION_ID
- Identifies the inventory organization associated with the delivery
- References HR_OPERATING_UNITS

4. INVENTORY_ITEM_ID
- Specific item being shipped
- Links to MTL_SYSTEM_ITEMS table

5. REQUESTED_QUANTITY
- Original quantity requested for delivery

6. SHIPPED_QUANTITY
- Actual quantity shipped

7. PICK_SLIP_NUMBER
- Reference to pick slip used for this delivery detail

8. SOURCE_HEADER_ID
- Links to source order header (e.g., Sales Order)

9. SOURCE_LINE_ID
- Links to specific source order line

10. TRACKING_NUMBER
- Shipping carrier tracking information

11. STATUS_CODE
- Current status of delivery detail (e.g., Picked, Shipped)

12. SHIP_METHOD_CODE
- Shipping method used for this delivery detail

Important Characteristics:
- Part of Oracle Shipping (WSH) module
- Supports complex shipping and logistics processes
- Tracks detailed shipping information
- Integrates with Order Management and Inventory

Typical Use Cases:
- Tracking individual item shipments
- Managing partial deliveries
- Generating shipping documentation
- Tracking inventory movement

Relationships:
- Connected to WSH_DELIVERIES (header)
- Connected to OE_ORDER_LINES (source)
- Connected to MTL_SYSTEM_ITEMS (product)

This table is crucial for comprehensive shipping and logistics tracking in Oracle E-Business Suite.