HZ_CUST_ACCT_SITES_ALL

-- ============================================================
-- Table  : HZ_CUST_ACCT_SITES_ALL — Customer account sites — one row binding an account to a party site (address) within one operating unit, with the bill-to/ship-to capability flags
-- Purpose: Column-selected read of HZ_CUST_ACCT_SITES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + CUST_ACCT_SITE_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.CUST_ACCT_SITE_ID AS "Surrogate key of the account site",
  t.CUST_ACCOUNT_ID AS "The account the site belongs to",
  t.PARTY_SITE_ID AS "The party site (address assignment) behind this account site",
  t.ORG_ID AS "Operating unit — the same address appears once per OU that uses it",
  t.STATUS AS "A = active, I = inactive",
  t.BILL_TO_FLAG AS "Whether the site can bill (Y/N/P)",
  t.SHIP_TO_FLAG AS "Whether the site can receive shipments",
  t.MARKET_FLAG AS "Marketing-site marker",
  t.CUSTOMER_CATEGORY_CODE AS "Site-level customer category",
  t.TERRITORY AS "Territory of the site",
  t.ORIG_SYSTEM_REFERENCE AS "The legacy/source-system key"
FROM <catalog>.<schema>.HZ_CUST_ACCT_SITES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.CUST_ACCT_SITE_ID = <CUST_ACCT_SITE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CUST_ACCT_SITE_ID;