HZ_PARTIES

-- ============================================================
-- Table  : HZ_PARTIES — The trading-community party master — one row per person, organization, or group before any commercial context; customers AND suppliers resolve back to a party here
-- Purpose: Column-selected read of HZ_PARTIES — auto-generated from field metadata
-- Grain  : One row per PARTY_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_ID AS "Surrogate key of the party — what customer accounts and the supplier master resolve to",
  t.PARTY_NUMBER AS "The unique party number users see",
  t.PARTY_NAME AS "The party's name — NOT unique; never a join or dedupe key",
  t.PARTY_TYPE AS "Organization, person, group, or relationship (per the data dictionary's comment)",
  t.STATUS AS "A = active, I = inactive — party merges can leave other single-letter states; verify beyond A/I on your instance",
  t.ORIG_SYSTEM_REFERENCE AS "The legacy/source-system key the party was created from",
  t.VALIDATED_FLAG AS "Whether the party has been validated",
  t.CREATED_BY_MODULE AS "Which application created the party",
  t.PERSON_FIRST_NAME AS "First name, on person-type parties",
  t.PERSON_LAST_NAME AS "Last name, on person-type parties",
  t.ADDRESS1 AS "Denormalized identifying-address line — a convenience copy, not the address master",
  t.COUNTRY AS "Identifying-address country (territory code)",
  t.SIC_CODE AS "Industry classification code",
  t.DUNS_NUMBER_C AS "D-U-N-S number, character form"
FROM <catalog>.<schema>.HZ_PARTIES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.PARTY_ID = <PARTY_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.PARTY_ID;