PO_LINES_ALL

-- ============================================================
-- Table  : PO_LINES_ALL — Purchasing document lines — the item, category, unit price, and ordered quantity per line across the same seven document types; shipment schedules and accounting live one and two levels down
-- Purpose: Column-selected read of PO_LINES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + PO_LINE_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_LINE_ID AS "Surrogate key of the document line",
  t.PO_HEADER_ID AS "The parent document header — unique with LINE_NUM",
  t.ORG_ID AS "Operating unit",
  t.LINE_NUM AS "Line number within the document",
  t.LINE_TYPE_ID AS "Line type — goods vs amount-based services",
  t.ITEM_ID AS "The item — this table's name for the item-master id; the org for the join comes from the shipment schedule",
  t.ITEM_REVISION AS "Item revision ordered",
  t.ITEM_DESCRIPTION AS "Item description as it appears on the document",
  t.CATEGORY_ID AS "Purchasing category — the category-spend rollup key",
  t.UNIT_MEAS_LOOKUP_CODE AS "Unit of measure, in its 25-character name form",
  t.QUANTITY AS "Total ordered quantity across the line's shipments",
  t.UNIT_PRICE AS "Unit price on the line",
  t.CLOSED_CODE AS "Line closure state",
  t.CANCEL_FLAG AS "Y when the line is cancelled"
FROM <catalog>.<schema>.PO_LINES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.PO_LINE_ID = <PO_LINE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.PO_LINE_ID;