HZ_CUST_ACCOUNTS

-- ============================================================
-- Table  : HZ_CUST_ACCOUNTS — The customer account — the commercial (selling) relationship layered on a party; one party can carry several accounts, each with its own account number, status, and type
-- Purpose: Column-selected read of HZ_CUST_ACCOUNTS — auto-generated from field metadata
-- Grain  : One row per CUST_ACCOUNT_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.CUST_ACCOUNT_ID AS "Surrogate key of the customer account — the id AR calls the customer",
  t.PARTY_ID AS "The party this account belongs to",
  t.ACCOUNT_NUMBER AS "Customer account number",
  t.ACCOUNT_NAME AS "Account description — not the party name",
  t.STATUS AS "Account status — the A/I list EBS practitioners expect is not enumerated here",  -- decode t.STATUS via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'CODE_STATUS', LANGUAGE-filtered)
  t.CUSTOMER_TYPE AS "I for internal, R for revenue-generating external customers",  -- decode t.CUSTOMER_TYPE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'CUSTOMER_TYPE', LANGUAGE-filtered)
  t.CUSTOMER_CLASS_CODE AS "Customer classification (reseller, education, and so on)",
  t.ACCOUNT_ESTABLISHED_DATE AS "When the account relationship began",
  t.ACCOUNT_TERMINATION_DATE AS "When the account relationship ended",
  t.HOLD_BILL_FLAG AS "Whether bills receivable are on hold for the account",
  t.SELLING_PARTY_ID AS "The party selling to this account — an external-facing organization, not a BU or legal entity",
  t.ORIG_SYSTEM_REFERENCE AS "Legacy-system customer key"
FROM <catalog>.<schema>.HZ_CUST_ACCOUNTS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.CUST_ACCOUNT_ID = <CUST_ACCOUNT_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.CUST_ACCOUNT_ID;