PO_VENDORS

-- ============================================================
-- Table  : PO_VENDORS — The compatibility view legacy purchasing queries know suppliers by — resolves to the supplier master joined to its trading-community party; kept for the name, not the extraction path
-- Purpose: Column-selected read of PO_VENDORS — 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. APPS-schema view — land its base tables for extraction; see the table notes.
-- ============================================================
SELECT
  t.VENDOR_ID AS "The supplier id — identical to the supplier master's key",
  t.VENDOR_NAME AS "Supplier name, through the view",
  t.SEGMENT1 AS "The supplier number",
  t.VENDOR_TYPE_LOOKUP_CODE AS "Supplier type classification",
  t.ENABLED_FLAG AS "Whether the supplier is active",
  t.PARTY_ID AS "The trading-community party — exposed by the view's join"
FROM <catalog>.<schema>.PO_VENDORS 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;