AP_SUPPLIERS

-- ============================================================
-- Table  : AP_SUPPLIERS — The R12 supplier master — one global row per supplier with the supplier number, type, and control flags, backed by the trading community architecture through its party id
-- Purpose: Column-selected read of AP_SUPPLIERS — auto-generated from field metadata
-- Grain  : One row per VENDOR_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_ID AS "Surrogate key of the supplier — what purchasing and receiving documents carry",
  t.SEGMENT1 AS "The supplier number — same flexfield naming collision as document numbers",
  t.VENDOR_NAME AS "Supplier name",
  t.PARTY_ID AS "The trading-community party behind the supplier — the TCA backbone link",
  t.VENDOR_TYPE_LOOKUP_CODE AS "Supplier type classification",
  t.ENABLED_FLAG AS "Whether the supplier is active",
  t.HOLD_FLAG AS "Whether new purchasing is held for the supplier",
  t.ONE_TIME_FLAG AS "One-time supplier marker",
  t.START_DATE_ACTIVE AS "Effectivity start date",
  t.END_DATE_ACTIVE AS "Effectivity end date — NULL while active",
  t.TERMS_ID AS "Default payment terms",
  t.INVOICE_CURRENCY_CODE AS "Default invoice currency"
FROM <catalog>.<schema>.AP_SUPPLIERS t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.VENDOR_ID = <VENDOR_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.VENDOR_ID;