OE_ORDER_HOLDS_ALL

-- ============================================================
-- Table  : OE_ORDER_HOLDS_ALL — Hold instances on orders and lines — one row per applied hold, pointing at the hold source that applied it and the release record once lifted; the "why isn't this line shipping" table
-- Purpose: Column-selected read of OE_ORDER_HOLDS_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + ORDER_HOLD_ID
-- Notes  : Auto-generated skeleton for Oracle EBS R12 data landed in your lakehouse. 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.ORDER_HOLD_ID AS "Surrogate key of the hold instance",
  t.ORG_ID AS "Operating unit",
  t.HEADER_ID AS "The held order",
  t.LINE_ID AS "The held line — NULL for order-level holds, so a line-only filter drops them",
  t.HOLD_SOURCE_ID AS "The hold source (criteria) that applied this hold",
  t.HOLD_RELEASE_ID AS "The release record once lifted — NULL while the hold is active",
  t.RELEASED_FLAG AS "N while the hold is active — the open-holds filter",
  t.CREDIT_PROFILE_LEVEL AS "Credit-check profile level for credit holds"
FROM <catalog>.<schema>.OE_ORDER_HOLDS_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.ORDER_HOLD_ID = <ORDER_HOLD_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.ORDER_HOLD_ID;