POZ_SUPPLIER_SITES_ALL_M

-- ============================================================
-- Table  : POZ_SUPPLIER_SITES_ALL_M — Supplier sites — the transactable endpoints purchase orders and payments point at, one row per supplier address per procurement business unit, with purchasing/pay/RFQ purpose flags and payment defaults
-- Purpose: Column-selected read of POZ_SUPPLIER_SITES_ALL_M — auto-generated from field metadata
-- Grain  : One row per VENDOR_SITE_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.VENDOR_SITE_ID AS "Site surrogate key — what document tables join on",
  t.VENDOR_ID AS "Owning supplier",
  t.PARTY_SITE_ID AS "TCA party site — the underlying address record",
  t.VENDOR_SITE_CODE AS "Site name/code shown to users",
  t.PRC_BU_ID AS "Procurement BU that owns this site row — the same address repeats per BU",
  t.PURCHASING_SITE_FLAG AS "Site can receive purchase orders",
  t.PAY_SITE_FLAG AS "Site can receive payments",
  t.RFQ_ONLY_SITE_FLAG AS "Site limited to RFQs",
  t.PRIMARY_PAY_SITE_FLAG AS "Default pay site for the supplier",
  t.INACTIVE_DATE AS "Site end-dated after this date",
  t.HOLD_FLAG AS "Purchasing hold on the site",
  t.PURCHASING_HOLD_REASON AS "Why new purchase orders are blocked",
  t.TERMS_ID AS "Default payment terms",
  t.INVOICE_CURRENCY_CODE AS "Default invoice currency",
  t.MATCH_OPTION AS "Default invoice match to PO vs receipt"
FROM <catalog>.<schema>.POZ_SUPPLIER_SITES_ALL_M t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.VENDOR_SITE_ID = <VENDOR_SITE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.VENDOR_SITE_ID;