DOO_HOLD_INSTANCES

-- ============================================================
-- Table  : DOO_HOLD_INSTANCES — Hold instances — one row per hold applied to an orchestration order, order line, or fulfillment line, with who applied and released it and when; the "why isn't this line shipping" table
-- Purpose: Column-selected read of DOO_HOLD_INSTANCES — auto-generated from field metadata
-- Grain  : One row per HOLD_INSTANCE_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.HOLD_INSTANCE_ID AS "Surrogate key of the hold instance",
  t.HOLD_CODE_ID AS "The hold-code definition this instance applies",
  t.DOO_HEADER_ID AS "Order header the hold targets — note the DOO_ prefix, unlike sibling tables",
  t.DOO_LINE_ID AS "Order line the hold targets",
  t.FULFILL_LINE_ID AS "Fulfillment line the hold targets",
  t.ACTIVE_FLAG AS "Whether the hold is currently active — released holds remain as history",
  t.APPLY_DATE AS "When the hold was placed",
  t.RELEASE_DATE AS "When the hold was released — NULL while active",
  t.APPLY_USER_ID AS "User who requested the hold",
  t.RELEASE_USER_ID AS "User who released the hold",
  t.APPLY_SYSTEM AS "System that requested the hold",
  t.HOLD_RELEASE_REASON_CODE AS "Reason code recorded at release",
  t.HOLD_COMMENTS AS "Comments entered when applying the hold"
FROM <catalog>.<schema>.DOO_HOLD_INSTANCES t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.HOLD_INSTANCE_ID = <HOLD_INSTANCE_ID>
  -- AND t.APPLY_DATE >= DATE '<DATE_FROM>'
  -- AND t.APPLY_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.HOLD_INSTANCE_ID;