HZ_CUST_SITE_USES_ALL

-- ============================================================
-- Table  : HZ_CUST_SITE_USES_ALL — Site uses — the business purposes (bill-to, ship-to, statements) assigned to each customer account site; the bottom TCA layer, and the id AR transactions actually point at
-- Purpose: Column-selected read of HZ_CUST_SITE_USES_ALL — auto-generated from field metadata
-- Grain  : One row per SITE_USE_ID + SET_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.SITE_USE_ID AS "Surrogate key of the site use — what AR transactions actually point at",
  t.SET_ID AS "Reference data set stripe — no ORG_ID on this table, and part of the documented unique key (SET_ID + SITE_USE_ID); see quirks #set-id",
  t.CUST_ACCT_SITE_ID AS "The account site the purpose is assigned to",
  t.SITE_USE_CODE AS "The business purpose — Bill-To, Ship-To, Statements, Market, and so on",
  t.PRIMARY_FLAG AS "Whether this is the account's primary site for the purpose",
  t.STATUS AS "Site-use status",  -- decode t.STATUS via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'CODE_STATUS', LANGUAGE-filtered)
  t.LOCATION AS "Site-use identifier string shown in transaction UIs",
  t.BILL_TO_SITE_USE_ID AS "For a ship-to use, the bill-to use it settles through (self-referencing)",
  t.PAYMENT_TERM_ID AS "Default payment terms at this site use",
  t.GSA_INDICATOR AS "US GSA agency indicator",
  t.START_DATE AS "Use validity start",
  t.END_DATE AS "Use validity end",
  t.ORIG_SYSTEM_REFERENCE AS "Legacy-system site-use key"
FROM <catalog>.<schema>.HZ_CUST_SITE_USES_ALL t
WHERE
  t.SET_ID = <SET_ID>  -- reference data set — the stripe that replaced the org stripe; one set or codes double-load; see quirks guide #set-id
  -- AND t.SITE_USE_ID = <SITE_USE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.SITE_USE_ID;