Results for “rep_origin”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

WMS_DOCK_APPOINTMENTS_B is the base table underlying the Oracle Warehouse Management (WMS) dock assignment form in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the transactional record of dock door reservations for both inbound and outbound operations, capturing the assigned dock door (locator), the associated trip stop for outbound appointments, the appointment window (start and end times), and recurrence metadata for repetitive appointments. The table resides in the WMS schema and is classified as VALID in the ETRM repository.

From a Data Vault modeling perspective, the heuristic mined from the foreign key structure suggests this object behaves as a link. It resolves relationships between a dock door (via MTL_ITEM_LOCATIONS) and a trip stop (via WSH_TRIP_STOPS), with the appointment itself acting as the connecting transaction. Modelers designing a warehouse-layer representation may treat DOCK_APPOINTMENT_ID as the link surrogate while retaining the descriptive attributes as satellite content.

Key Information Stored

The table comprises 23 documented columns. The most operationally significant include:

• DOCK_APPOINTMENT_ID — the surrogate primary key, supported by unique index WMS_DOCK_APPOINTMENTS_B_U1. This is the sole documented business-key candidate.
• DOCK_ID — foreign key to MTL_ITEM_LOCATIONS, identifying the specific dock door locator reserved.
• TRIP_STOP — foreign key to WSH_TRIP_STOPS, linking the appointment to an outbound trip stop.
• ORGANIZATION_ID — the inventory organization owning the appointment.
• APPOINTMENT_TYPE — distinguishes inbound versus outbound dock usage.
• START_TIME and END_TIME — the scheduled appointment window.
• APPOINTMENT_STATUS — lifecycle state of the appointment.
• CARRIER and CARRIER_CODE — the carrier assigned to the movement.
• STAGING_LANE_ID — the staging lane associated with the appointment.
• SOURCE_TYPE, SOURCE_HEADER_ID, SOURCE_LINE_ID — polymorphic references back to the originating document.
• REP_START_DATE, REP_END_DATE, REP_ORIGIN, REP_FREQUENCY — recurrence controls for repetitive appointments.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS audit columns.

Common Use Cases and Queries

Typical reporting and integration scenarios include dock utilization analysis, outbound appointment scheduling, and carrier performance tracking. A representative query joins the base table to MTL_ITEM_LOCATIONS to resolve dock door names:

SELECT da.dock_appointment_id, mil.inventory_location_id,
       da.start_time, da.end_time, da.appointment_status
FROM   wms_dock_appointments_b da,
       mtl_item_locations mil
WHERE  da.dock_id = mil.inventory_location_id
AND    da.organization_id = :org_id
AND    da.start_time >= :from_date;

For outbound tracking, joining TRIP_STOP to WSH_TRIP_STOPS surfaces the trip and stop context. Repetitive appointment reporting filters on REP_FREQUENCY and REP_START_DATE/REP_END_DATE to project recurring dock demand. Source-document reconciliation uses SOURCE_TYPE with SOURCE_HEADER_ID and SOURCE_LINE_ID to trace appointments back to originating orders or shipments.

Related Objects

• WSH_TRIP_STOPS — referenced via WMS_DOCK_APPOINTMENTS_B.TRIP_STOP; supplies outbound trip stop context.
• MTL_ITEM_LOCATIONS — referenced via WMS_DOCK_APPOINTMENTS_B.DOCK_ID and ORGANIZATION_ID; defines the dock door locator.
• WMS_DOCK_APPOINTMENTS_TL — the translation table commonly paired with the _B base table for multilingual appointment descriptions.
• WSH_TRIPS — parent of trip stops, useful for trip-level aggregation.
• MTL_PARAMETERS — organization context for ORGANIZATION_ID.
• WMS_DockAppointment public API / dock assignment form — the UI and programmatic entry point that inserts and maintains rows in this table.
• INV_ORGANIZATION_DEFINITIONS / HR_ALL_ORGANIZATION_UNITS — resolve organization names for reporting.
• FND_USER — resolves CREATED_BY and LAST_UPDATED_BY audit references.