PO_REQUISITION_LINES_ALL

-- ============================================================
-- Table  : PO_REQUISITION_LINES_ALL — Requisition lines — item, quantity, price, need-by date, destination inventory org, and sourcing suggestion per line; carries the link to the PO shipment autocreate built from it
-- Purpose: Column-selected read of PO_REQUISITION_LINES_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + REQUISITION_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.REQUISITION_LINE_ID AS "Surrogate key of the requisition line",
  t.REQUISITION_HEADER_ID AS "The parent requisition",
  t.ORG_ID AS "Operating unit",
  t.LINE_NUM AS "Line number within the requisition",
  t.ITEM_ID AS "The item requested — pairs with the destination org for item-master joins",
  t.ITEM_DESCRIPTION AS "Item description on the line",
  t.CATEGORY_ID AS "Purchasing category",
  t.UNIT_MEAS_LOOKUP_CODE AS "Unit of measure, name form",
  t.UNIT_PRICE AS "Unit price on the requisition line",
  t.QUANTITY AS "Requested quantity",
  t.QUANTITY_DELIVERED AS "Quantity delivered against the line",
  t.QUANTITY_CANCELLED AS "Quantity cancelled",
  t.SOURCE_TYPE_CODE AS "Supplier-sourced vs inventory-sourced (internal) line",
  t.DESTINATION_TYPE_CODE AS "Where the goods charge to — inventory, expense, shop floor",
  t.DESTINATION_ORGANIZATION_ID AS "The receiving inventory org — the org half of this table's item join",
  t.NEED_BY_DATE AS "When the requester needs the goods — the primary analysis date",
  t.LINE_LOCATION_ID AS "The PO shipment autocreate built from this line — NULL until then; the req-to-PO thread"
FROM <catalog>.<schema>.PO_REQUISITION_LINES_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.REQUISITION_LINE_ID = <REQUISITION_LINE_ID>
  -- AND t.NEED_BY_DATE >= DATE '<DATE_FROM>'
  -- AND t.NEED_BY_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_LINE_ID;