HZ_CUST_ACCOUNTS

-- ============================================================
-- Table  : HZ_CUST_ACCOUNTS — The customer account — the commercial relationship layered over a party, and the id order headers actually carry as SOLD_TO_ORG_ID; one party, many accounts
-- 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 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.CUST_ACCOUNT_ID AS "Surrogate key of the account — the id order headers carry as SOLD_TO_ORG_ID",
  t.PARTY_ID AS "The party behind the account — one party can hold several accounts",
  t.ACCOUNT_NUMBER AS "The account number users see",
  t.ACCOUNT_NAME AS "Account description",
  t.STATUS AS "A = active, I = inactive (the CODE_STATUS lookup, per the data dictionary's comment)",
  t.CUSTOMER_TYPE AS "External vs internal customer",
  t.CUSTOMER_CLASS_CODE AS "Customer classification",
  t.SALES_CHANNEL_CODE AS "Sales channel of the account",
  t.ACCOUNT_ESTABLISHED_DATE AS "When the account was opened — the lifecycle analysis date",
  t.ACCOUNT_ACTIVATION_DATE AS "When the account was activated",
  t.ACCOUNT_TERMINATION_DATE AS "When the account was closed — NULL while active",
  t.STATUS_UPDATE_DATE AS "When the status last changed",
  t.ORIG_SYSTEM_REFERENCE AS "The legacy/source-system 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.ACCOUNT_ESTABLISHED_DATE >= DATE '<DATE_FROM>'
  -- AND t.ACCOUNT_ESTABLISHED_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.CUST_ACCOUNT_ID;