WSH_DELIVERY_ASSIGNMENTS

-- ============================================================
-- Table  : WSH_DELIVERY_ASSIGNMENTS — The assignment bridge between shipment lines and deliveries — also the carrier of the packing hierarchy through its parent-detail pointer; a line reaches its delivery only through this table
-- Purpose: Column-selected read of WSH_DELIVERY_ASSIGNMENTS — auto-generated from field metadata
-- Grain  : One row per DELIVERY_ASSIGNMENT_ID
-- Notes  : Auto-generated skeleton for Oracle Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. Dates are real DATE/TIMESTAMP columns — no conversion needed. WHO audit columns omitted (see the quirks guide); the optional LAST_UPDATE_DATE watermark filter supports incremental extracts.
-- ============================================================
SELECT
  t.DELIVERY_ASSIGNMENT_ID AS "Surrogate key of the assignment",
  t.DELIVERY_ID AS "The delivery the line is assigned to — NULL while unassigned, so LEFT JOIN",
  t.DELIVERY_DETAIL_ID AS "The shipment line being assigned",
  t.PARENT_DELIVERY_ID AS "Parent delivery, when nested",
  t.PARENT_DELIVERY_DETAIL_ID AS "The container/LPN row this line is packed under — the packing hierarchy lives here",
  t.ACTIVE_FLAG AS "Whether this assignment is currently active"
FROM <catalog>.<schema>.WSH_DELIVERY_ASSIGNMENTS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.DELIVERY_ASSIGNMENT_ID = <DELIVERY_ASSIGNMENT_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.DELIVERY_ASSIGNMENT_ID;