HZ_PARTIES

-- ============================================================
-- Table  : HZ_PARTIES — The party master — one row per person, organization, or group in the trading community, with the party number, type, status, and a denormalized identifying address and primary contact point; the top of the four-layer customer model
-- Purpose: Column-selected read of HZ_PARTIES — auto-generated from field metadata
-- Grain  : One row per PARTY_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_ID AS "Surrogate key of the party — what customers, suppliers, and sites all resolve to",
  t.PARTY_NUMBER AS "The party's unique number",
  t.PARTY_NAME AS "The party's name — the customer or supplier display name reports actually want",
  t.PARTY_TYPE AS "Person, Organization, or Group",
  t.STATUS AS "Party status flag — values not enumerated in the dictionary",
  t.CATEGORY_CODE AS "User-defined party category",  -- decode t.CATEGORY_CODE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'CUSTOMER_CATEGORY', LANGUAGE-filtered)
  t.DUNS_NUMBER_C AS "D&B DUNS number — stored as text, not validated to nine digits",
  t.JGZZ_FISCAL_CODE AS "Tax / fiscal registration identifier",
  t.EMAIL_ADDRESS AS "Primary email — a denormalized copy of the contact point",
  t.PRIMARY_PHONE_NUMBER AS "Primary phone in local format — no country or area code",
  t.ADDRESS1 AS "First line of the denormalized identifying address",
  t.CITY AS "City of the identifying address",
  t.COUNTRY AS "Country of the identifying address (territory code)",
  t.VALIDATED_FLAG AS "Whether the party has been validated",
  t.ORIG_SYSTEM_REFERENCE AS "Legacy-system key the party was migrated under"
FROM <catalog>.<schema>.HZ_PARTIES t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.PARTY_ID = <PARTY_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.PARTY_ID;