PO_LINES_ALL

-- ============================================================
-- Table  : PO_LINES_ALL — Purchasing document lines — the item, category, unit price, and ordered quantity per line; the line quantity is the rollup of its schedules one level down
-- Purpose: Column-selected read of PO_LINES_ALL — auto-generated from field metadata
-- Grain  : One row per PO_LINE_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_LINE_ID AS "Surrogate key of the line",
  t.PO_HEADER_ID AS "Parent purchasing document header",
  t.LINE_NUM AS "Visible line number",
  t.ITEM_ID AS "Item on the line — no inventory org here; resolve it through the schedule's ship-to org",
  t.ITEM_REVISION AS "Item revision",
  t.ITEM_DESCRIPTION AS "Line item description",
  t.CATEGORY_ID AS "Purchasing category",
  t.QUANTITY AS "Ordered quantity — the rollup of the line's schedules",
  t.UNIT_PRICE AS "Price per unit in document currency",
  t.AMOUNT AS "Budget amount — populated only for service-type lines",
  t.UOM_CODE AS "Unit of measure",
  t.LINE_TYPE_ID AS "Goods vs services line type",
  t.LINE_STATUS AS "Line status",
  t.CLOSED_DATE AS "When the line was closed",
  t.CANCEL_FLAG AS "Y when the line is cancelled",
  t.FROM_HEADER_ID AS "Source agreement/quotation header the line references",
  t.FROM_LINE_ID AS "Source agreement/quotation line",
  t.PRC_BU_ID AS "Procurement BU stripe, denormalized from the header"
FROM <catalog>.<schema>.PO_LINES_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_LINE_ID = <PO_LINE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.PO_LINE_ID;