WSH_DELIVERY_DETAILS

-- ============================================================
-- Table  : WSH_DELIVERY_DETAILS — The atomic shipment line — one row per shippable unit of demand, tracking the source order line, item, warehouse, and the requested/picked/shipped quantity lifecycle through pick, stage, and ship confirm
-- Purpose: Column-selected read of WSH_DELIVERY_DETAILS — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + DELIVERY_DETAIL_ID
-- Caution: Lines split as they process (SPLIT_FROM_DELIVERY_DETAIL_ID points at the original) — one order line commonly fans out to several rows
-- 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_DETAIL_ID AS "Surrogate key of the shipment line",
  t.ORG_ID AS "The business unit associated to the row — one of the table's two org anchors",
  t.ORGANIZATION_ID AS "Ship-from inventory organization — the other org anchor",
  t.INVENTORY_ITEM_ID AS "Item being shipped",
  t.SOURCE_HEADER_ID AS "Source document header (a sales order header, most commonly)",
  t.SOURCE_LINE_ID AS "Source line id — polymorphic across order/WIP/PO sources, so no order edge is drawn",
  t.SOURCE_DOCUMENT_TYPE_ID AS "Which document type fed the row",
  t.RELEASED_STATUS AS "Line lifecycle status (ready, released, staged, shipped, backordered) — single-character codes, not enumerated in the dictionary",
  t.REQUESTED_QUANTITY AS "Quantity to ship",
  t.REQUESTED_QUANTITY_UOM AS "UOM of the quantity columns",
  t.PICKED_QUANTITY AS "Quantity picked",
  t.SHIPPED_QUANTITY AS "Quantity shipped, in the requested-quantity UOM",
  t.CANCELLED_QUANTITY AS "Quantity canceled by the source system",
  t.DATE_SCHEDULED AS "Scheduled date for the line",
  t.SHIP_TO_PARTY_ID AS "Ship-to customer party (TCA)",
  t.PARENT_LPN_ID AS "The license plate (container) the line is packed into — packing goes through LPNs, not container rows",
  t.SPLIT_FROM_DELIVERY_DETAIL_ID AS "The original line this row split from",
  t.TRACKING_NUMBER AS "Carrier tracking number for the line"
FROM <catalog>.<schema>.WSH_DELIVERY_DETAILS t
WHERE
  t.ORG_ID = <business_unit_id>  -- business unit — Fusion _ALL means BU, not the EBS operating unit; see quirks guide #all-means-bu
  AND t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- AND t.DELIVERY_DETAIL_ID = <DELIVERY_DETAIL_ID>
  -- AND t.DATE_SCHEDULED >= DATE '<DATE_FROM>'
  -- AND t.DATE_SCHEDULED <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.DELIVERY_DETAIL_ID;