PO_REQUISITION_HEADERS_ALL

-- ============================================================
-- Table  : PO_REQUISITION_HEADERS_ALL — Requisition headers — the requisition number, preparer, type (purchase vs internal), and approval status; where demand enters purchasing before it becomes a PO
-- Purpose: Column-selected read of PO_REQUISITION_HEADERS_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + REQUISITION_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.REQUISITION_HEADER_ID AS "Surrogate key of the requisition",
  t.ORG_ID AS "Operating unit",
  t.SEGMENT1 AS "The requisition number — the same naming collision as the PO number; not a flexfield",
  t.PREPARER_ID AS "Who prepared the requisition",
  t.TYPE_LOOKUP_CODE AS "Purchase vs internal requisition",
  t.AUTHORIZATION_STATUS AS "Approval status — Purchasing's own lookup ladder",
  t.DESCRIPTION AS "Requisition description",
  t.TRANSFERRED_TO_OE_FLAG AS "Y once an internal requisition was handed to Order Management as an internal sales order",
  t.CLOSED_CODE AS "Closure state",
  t.CANCEL_FLAG AS "Y when cancelled",
  t.INTERFACE_SOURCE_CODE AS "The system that created the requisition — planning, iProcurement, manual…",
  t.APPROVED_DATE AS "When the requisition was approved — the primary analysis date"
FROM <catalog>.<schema>.PO_REQUISITION_HEADERS_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.REQUISITION_HEADER_ID = <REQUISITION_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.REQUISITION_HEADER_ID;