PO_HEADERS_ALL

-- ============================================================
-- Table  : PO_HEADERS_ALL — Purchasing document headers — one row per purchase order or agreement (standard, blanket, contract), with supplier, buyer, currency, and the document status; striped by the procurement business unit
-- Purpose: Column-selected read of PO_HEADERS_ALL — auto-generated from field metadata
-- Grain  : One row per PO_HEADER_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.PO_HEADER_ID AS "Surrogate key of the purchasing document",
  t.SEGMENT1 AS "The visible PO number — a naming collision with flexfields, unique only with the document type plus SOLDTO_LE_ID (standard orders) or PRC_BU_ID (all other types), per Oracle's PO_HEADERS_U2 index; join on PO_HEADER_ID",
  t.PRC_BU_ID AS "Procurement business unit that owns the document — Fusion's named BU stripe",
  t.REQ_BU_ID AS "Requisitioning business unit the order was raised for",
  t.SOLDTO_LE_ID AS "Sold-to legal entity",
  t.BILLTO_BU_ID AS "Bill-to business unit — note the spelling, no underscore in BILLTO",
  t.TYPE_LOOKUP_CODE AS "Document type (standard, blanket, contract…)",
  t.DOCUMENT_STATUS AS "Header-level document status — there is no CLOSED_CODE in Fusion",
  t.VENDOR_ID AS "Supplier on the document",
  t.VENDOR_SITE_ID AS "Supplier site the document is placed against",
  t.AGENT_ID AS "Buyer on the document",
  t.CURRENCY_CODE AS "Document currency",
  t.RATE AS "Currency conversion rate",
  t.APPROVED_FLAG AS "Y when the current revision is approved",
  t.APPROVED_DATE AS "Last approval date",
  t.CLOSED_DATE AS "Date the document was closed",
  t.CANCEL_FLAG AS "Y when the document is cancelled",
  t.REVISION_NUM AS "Document revision counter"
FROM <catalog>.<schema>.PO_HEADERS_ALL t
WHERE
  t.PRC_BU_ID = <PRC_BU_ID>  -- business unit — this table stripes by a NAMED BU column, not ORG_ID; see quirks guide #all-means-bu
  -- 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>'  -- the column incremental BICC extracts key on
ORDER BY t.PO_HEADER_ID;