HZ_LOCATIONS

-- ============================================================
-- Table  : HZ_LOCATIONS — The physical address master — pure address rows with no party context; one location can serve many parties, customer sites, and supplier sites
-- Purpose: Column-selected read of HZ_LOCATIONS — auto-generated from field metadata
-- Grain  : One row per LOCATION_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.LOCATION_ID AS "Surrogate key of the address",
  t.ADDRESS1 AS "Address line 1 — the only mandatory line",
  t.ADDRESS2 AS "Address line 2",
  t.CITY AS "City",
  t.STATE AS "State — US-style; non-US addresses use PROVINCE",
  t.PROVINCE AS "Province — separate column from STATE; pick by country",
  t.POSTAL_CODE AS "Postal/ZIP code",
  t.COUNTY AS "County",
  t.COUNTRY AS "Country — the territory code, not a name",
  t.ADDRESS_STYLE AS "Address format style",
  t.VALIDATED_FLAG AS "Whether the address has been validated",
  t.ORIG_SYSTEM_REFERENCE AS "The legacy/source-system key",
  t.CREATED_BY_MODULE AS "Which application created the address"
FROM <catalog>.<schema>.HZ_LOCATIONS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.LOCATION_ID = <LOCATION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.LOCATION_ID;