OE_HOLD_SOURCES_ALL

-- ============================================================
-- Table  : OE_HOLD_SOURCES_ALL — Hold source criteria — the entity a hold was applied against (a customer, an order, an item, a warehouse), stored as a generic entity code plus a polymorphic id, with the hold-until date
-- Purpose: Column-selected read of OE_HOLD_SOURCES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + HOLD_SOURCE_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.HOLD_SOURCE_ID AS "Surrogate key of the hold source",
  t.ORG_ID AS "Operating unit",
  t.HOLD_ID AS "The hold definition being applied",
  t.HOLD_ENTITY_CODE AS "What kind of entity is held — customer, order, item, warehouse…",
  t.HOLD_ENTITY_ID AS "The held entity's id — stored as text whatever the entity; cast before numeric joins",
  t.HOLD_UNTIL_DATE AS "Automatic expiry date of the hold, when set",
  t.RELEASED_FLAG AS "N while the source still applies its hold",
  t.HOLD_RELEASE_ID AS "The release record for the whole source, once released"
FROM <catalog>.<schema>.OE_HOLD_SOURCES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.HOLD_SOURCE_ID = <HOLD_SOURCE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.HOLD_SOURCE_ID;