POR_REQUISITION_LINES_ALL

-- ============================================================
-- Table  : POR_REQUISITION_LINES_ALL — Requisition lines — item, quantity, price, need-by date, destination org, and suggested supplier per line; carries the keys of the resulting PO header, line, and schedule once sourced
-- Purpose: Column-selected read of POR_REQUISITION_LINES_ALL — auto-generated from field metadata
-- Grain  : One row per REQUISITION_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.REQUISITION_LINE_ID AS "Surrogate key of the requisition line",
  t.REQUISITION_HEADER_ID AS "Parent requisition header",
  t.LINE_NUMBER AS "Visible line number",
  t.ITEM_ID AS "Requested item",
  t.ITEM_DESCRIPTION AS "Item description",
  t.CATEGORY_ID AS "Purchasing category",
  t.QUANTITY AS "Requested quantity",
  t.UNIT_PRICE AS "Unit price in functional currency",
  t.UOM_CODE AS "Unit of measure",
  t.NEED_BY_DATE AS "Internal need-by date",
  t.DESTINATION_TYPE_CODE AS "Inventory vs expense destination",
  t.DESTINATION_ORGANIZATION_ID AS "Destination inventory organization — the org half of the line's item join",
  t.REQUESTER_ID AS "Person the goods are for",
  t.VENDOR_ID AS "Suggested or assigned supplier",
  t.SOURCE_TYPE_CODE AS "Internal vs external source of supply",
  t.PO_HEADER_ID AS "The resulting PO header — NULL until sourced",
  t.LINE_LOCATION_ID AS "The resulting PO schedule — NULL until sourced",
  t.LINE_STATUS AS "Requisition line status"
FROM <catalog>.<schema>.POR_REQUISITION_LINES_ALL t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- 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>'  -- the column incremental BICC extracts key on
ORDER BY t.REQUISITION_LINE_ID;