Search Results wms_dock_appointments_b




Overview
Explore in AI Chat

Overview

The WMS_DOCK_APPOINTMENTS_B table is a core data object within the Oracle E-Business Suite Warehouse Management System (WMS) module, serving as the base table for the dock assignment form. Its primary role is to manage and store scheduled appointments for dock doors, a critical component of warehouse logistics and transportation planning. This table facilitates the efficient scheduling of inbound and outbound shipments by linking specific dock doors (locators) to scheduled trip stops within a defined time window. It is essential for coordinating warehouse resources, optimizing dock utilization, and ensuring timely loading and unloading operations in both Oracle EBS 12.1.1 and 12.2.2 environments.

Key Information Stored

The table stores the fundamental data required to define a dock appointment. The primary identifier is the DOCK_APPOINTMENT_ID. Key transactional columns include DOCK_ID, which references a specific dock door from the MTL_ITEM_LOCATIONS table, and TRIP_STOP, which links to the WSH_TRIP_STOPS table to associate the appointment with a specific stop on a transportation trip. The table also captures the temporal boundaries of the appointment through START_TIME and END_TIME columns. Additional columns, implied by the description's mention of "repetitive information," likely support recurring appointments, while ORGANIZATION_ID provides the necessary inventory organization context for the dock door.

Common Use Cases and Queries

A primary use case is generating reports on dock door utilization and appointment schedules for warehouse managers. This involves querying the table to view all appointments for a given date range or specific dock. Another common scenario is validating appointment availability before scheduling a new shipment, often performed by integrated forms or APIs. Sample SQL to find appointments for a specific dock on a given day would be:

  • SELECT dock_appointment_id, trip_stop, start_time, end_time FROM wms_dock_appointments_b WHERE dock_id = :dock_id AND TRUNC(start_time) = :appt_date;

For integration with transportation schedules, a join to WSH_TRIP_STOBS is typical to pull trip details associated with dock appointments, supporting outbound load planning.

Related Objects

The table maintains defined foreign key relationships with other central EBS tables, establishing its integration points within the application architecture. The documented relationships are:

  • WSH_TRIP_STOPS: The TRIP_STOP column in WMS_DOCK_APPOINTMENTS_B references this table, linking the dock appointment to a specific stop on a transportation trip managed by the Shipping Execution module.
  • MTL_ITEM_LOCATIONS: A composite foreign key relationship exists where the DOCK_ID and ORGANIZATION_ID columns in WMS_DOCK_APPOINTMENTS_B reference the corresponding columns in this table. This validates that the appointed dock door is a valid locator within the specified inventory organization.

The table's primary key, DOCK_APPOINTMENT_ID, is likely referenced by other WMS entities or transactional interfaces, though these are not specified in the provided metadata.