HZ_PARTY_SITES

-- ============================================================
-- Table  : HZ_PARTY_SITES — Party sites — the reusable link from a party to a location, carrying the site number and the identifying-address flag; both customer account sites and supplier sites resolve their address through here
-- Purpose: Column-selected read of HZ_PARTY_SITES — auto-generated from field metadata
-- Grain  : One row per PARTY_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.PARTY_SITE_ID AS "Surrogate key of the party site",
  t.PARTY_ID AS "The party at this address",
  t.LOCATION_ID AS "The physical address — joins the location master",
  t.PARTY_SITE_NUMBER AS "The unique site number users see",
  t.PARTY_SITE_NAME AS "User-defined site name",
  t.STATUS AS "A = active, I = inactive",
  t.IDENTIFYING_ADDRESS_FLAG AS "Y marks the party's identifying (primary) address — the one denormalized onto the party row",
  t.ORIG_SYSTEM_REFERENCE AS "The legacy/source-system key",
  t.CREATED_BY_MODULE AS "Which application created the site"
FROM <catalog>.<schema>.HZ_PARTY_SITES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.PARTY_SITE_ID = <PARTY_SITE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.PARTY_SITE_ID;