AP_SUPPLIER_SITES_ALL

-- ============================================================
-- Table  : AP_SUPPLIER_SITES_ALL — Supplier sites — the purchasing/pay/RFQ site records per supplier, one row per site per operating unit, with the site code and control flags; where supplier data meets MOAC striping
-- Purpose: Column-selected read of AP_SUPPLIER_SITES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + VENDOR_SITE_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.VENDOR_SITE_ID AS "Surrogate key of the supplier site",
  t.VENDOR_ID AS "The supplier the site belongs to",
  t.ORG_ID AS "Operating unit — the same supplier gets one site row per OU (see quirks guide)",
  t.VENDOR_SITE_CODE AS "The site code users see",
  t.LOCATION_ID AS "The TCA location that actually holds the address — the address columns here are legacy",
  t.PARTY_SITE_ID AS "The trading-community party site behind this row",
  t.PURCHASING_SITE_FLAG AS "Whether POs may be placed against the site",
  t.PAY_SITE_FLAG AS "Whether invoices may be paid to the site",
  t.RFQ_ONLY_SITE_FLAG AS "RFQ-only site marker",
  t.INACTIVE_DATE AS "When the site was inactivated — NULL while active",
  t.TERMS_ID AS "Payment terms at the site level",
  t.INVOICE_CURRENCY_CODE AS "Invoice currency at the site level"
FROM <catalog>.<schema>.AP_SUPPLIER_SITES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.VENDOR_SITE_ID = <VENDOR_SITE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.VENDOR_SITE_ID;