HZ_PARTY_SITES

-- ============================================================
-- Table  : HZ_PARTY_SITES — Party sites — the link between a party and a location, carrying the site number, name, addressee, and mailstop; one party can have many sites and one location can serve many parties
-- 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 Fusion Cloud data landed in your lakehouse by a BICC extract — there is no SQL path to the SaaS database. Column names follow Oracle's table documentation — if your landed data still carries PVO attribute headers, map names first; see quirks #pvo-drift. 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 the site belongs to",
  t.LOCATION_ID AS "The physical address record the site points at",
  t.PARTY_SITE_NUMBER AS "Unique site number",
  t.PARTY_SITE_NAME AS "User-defined site name",
  t.STATUS AS "Site status flag",
  t.IDENTIFYING_ADDRESS_FLAG AS "Whether this is the party's identifying address — the row denormalized onto the party master",
  t.OVERALL_PRIMARY_FLAG AS "The party's primary address regardless of context",
  t.ADDRESSEE AS "Addressee line printed above the address",
  t.START_DATE_ACTIVE AS "Site effective-from date",
  t.END_DATE_ACTIVE AS "Site effective-to date",
  t.ORIG_SYSTEM_REFERENCE AS "Legacy-system site key"
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>'  -- the column incremental BICC extracts key on
ORDER BY t.PARTY_SITE_ID;