PO_HEADERS_ALL

-- ============================================================
-- Table  : PO_HEADERS_ALL — Purchasing document headers — one row per purchase order, agreement, quotation, or RFQ (seven document types share the table), with supplier, buyer, currency, approval status, and closure state; operating-unit striped
-- Purpose: Column-selected read of PO_HEADERS_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + PO_HEADER_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.PO_HEADER_ID AS "Surrogate key of the purchasing document header",
  t.ORG_ID AS "Operating unit — PO numbers are unique only within it (plus document type)",
  t.SEGMENT1 AS "The PO number — a naming collision with key flexfields, not a flexfield; repeats across operating units",
  t.TYPE_LOOKUP_CODE AS "Document type — standard/blanket/contract families; decodes through the purchasing document-types table, not FND",
  t.AUTHORIZATION_STATUS AS "Approval status code — decodes through Purchasing's own lookup table (type 'AUTHORIZATION STATUS'), not the generic FND one",
  t.APPROVED_FLAG AS "Y once approved",
  t.APPROVED_DATE AS "Last approval date — the primary analysis date (nullable on unapproved documents)",
  t.CLOSED_CODE AS "Closure state — open, closed, closed for invoicing/receiving; Purchasing lookup type 'DOCUMENT STATE'",
  t.CLOSED_DATE AS "When the document closed",
  t.CANCEL_FLAG AS "Y when cancelled — the row persists",
  t.VENDOR_ID AS "The supplier — joins the supplier master",
  t.VENDOR_SITE_ID AS "The supplier site — OU-striped on the site table",
  t.AGENT_ID AS "The buyer",
  t.CURRENCY_CODE AS "Document currency",
  t.RATE AS "Currency conversion rate",
  t.COMMENTS AS "Header comments/description",
  t.FROM_HEADER_ID AS "The source document this one was created from (a quotation, for example)"
FROM <catalog>.<schema>.PO_HEADERS_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.PO_HEADER_ID = <PO_HEADER_ID>
  -- AND t.APPROVED_DATE >= DATE '<DATE_FROM>'
  -- AND t.APPROVED_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.PO_HEADER_ID;