HZ_CUST_SITE_USES_ALL

-- ============================================================
-- Table  : HZ_CUST_SITE_USES_ALL — Site business purposes — one row per use (ship-to, bill-to, statements…) of an account site per operating unit; the SITE_USE_ID here is what order headers carry as SHIP_TO_ORG_ID and INVOICE_TO_ORG_ID
-- Purpose: Column-selected read of HZ_CUST_SITE_USES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + SITE_USE_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.SITE_USE_ID AS "Surrogate key of the use — the id order headers carry as SHIP_TO_ORG_ID / INVOICE_TO_ORG_ID",
  t.CUST_ACCT_SITE_ID AS "The account site the use belongs to — one site, many uses",
  t.SITE_USE_CODE AS "The business purpose — ship-to, bill-to, statements…; filter it or joins double-count",
  t.PRIMARY_FLAG AS "Whether this is the primary site for the purpose",
  t.STATUS AS "A = active, I = inactive",
  t.LOCATION AS "The human-facing site-use label (a text identifier, not the address table's key)",
  t.ORG_ID AS "Operating unit",
  t.BILL_TO_SITE_USE_ID AS "For ship-to uses, the associated bill-to use",
  t.PAYMENT_TERM_ID AS "Payment-terms default at the use level",
  t.TERRITORY_ID AS "Territory of the use",
  t.WAREHOUSE_ID AS "Default ship-from warehouse (an inventory org) for ship-to uses",
  t.GL_ID_REC AS "AutoAccounting receivable-account default (CCID)"
FROM <catalog>.<schema>.HZ_CUST_SITE_USES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.SITE_USE_ID = <SITE_USE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.SITE_USE_ID;