POR_REQUISITION_HEADERS_ALL

-- ============================================================
-- Table  : POR_REQUISITION_HEADERS_ALL — Requisition headers — the requisition number, preparer, status, and justification; where demand enters procurement before it becomes a purchase order
-- Purpose: Column-selected read of POR_REQUISITION_HEADERS_ALL — auto-generated from field metadata
-- Grain  : One row per REQUISITION_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.REQUISITION_HEADER_ID AS "Surrogate key of the requisition",
  t.REQUISITION_NUMBER AS "The visible requisition number — a real column, not a flexfield segment; Oracle documents it only in non-unique indexes (even with REQ_BU_ID), so it is not a key here",
  t.REQ_BU_ID AS "Requisitioning business unit",
  t.PRC_BU_ID AS "Procurement business unit",
  t.PREPARER_ID AS "Employee who created the requisition",
  t.DESCRIPTION AS "Requisition description",
  t.DOCUMENT_STATUS AS "Requisition status — no AUTHORIZATION_STATUS in Fusion",
  t.APPROVED_DATE AS "Approval timestamp",
  t.SUBMISSION_DATE AS "When submitted for approval",
  t.JUSTIFICATION AS "Note to the approver",
  t.FUNDS_STATUS AS "Overall budgetary-control status",
  t.INTERFACE_SOURCE_CODE AS "Source system when loaded via requisition import"
FROM <catalog>.<schema>.POR_REQUISITION_HEADERS_ALL t
WHERE
  t.REQ_BU_ID = <REQ_BU_ID>  -- business unit — this table stripes by a NAMED BU column, not ORG_ID; see quirks guide #all-means-bu
  -- AND t.REQUISITION_HEADER_ID = <REQUISITION_HEADER_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.REQUISITION_HEADER_ID;