MTL_TXN_REQUEST_LINES

-- ============================================================
-- Table  : MTL_TXN_REQUEST_LINES — Move order lines — each row requests moving a quantity of an item from a source to a destination subinventory, individually statused, allocated (quantity detailed), and transacted (quantity delivered)
-- Purpose: Column-selected read of MTL_TXN_REQUEST_LINES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + 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.LINE_ID AS "Surrogate key of the move order line",
  t.HEADER_ID AS "The move order header — joins to MTL_TXN_REQUEST_HEADERS",
  t.ORGANIZATION_ID AS "Inventory organization",
  t.INVENTORY_ITEM_ID AS "Item to move",
  t.LINE_NUMBER AS "Line number within the move order",
  t.LINE_STATUS AS "Line status — the state that actually drives allocation and transaction",
  t.QUANTITY AS "Requested quantity",
  t.QUANTITY_DELIVERED AS "Quantity already transacted",
  t.QUANTITY_DETAILED AS "Quantity allocated (detailed) but not yet transacted",
  t.UOM_CODE AS "UOM of the requested quantity",
  t.FROM_SUBINVENTORY_CODE AS "Source subinventory",
  t.TO_SUBINVENTORY_CODE AS "Destination subinventory",
  t.LOT_NUMBER AS "Lot to move, when lot-specified",
  t.DATE_REQUIRED AS "When the line is required"
FROM <catalog>.<schema>.MTL_TXN_REQUEST_LINES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the operating unit — see quirks guide #two-orgs
  -- AND t.LINE_ID = <LINE_ID>
  -- AND t.DATE_REQUIRED >= DATE '<DATE_FROM>'
  -- AND t.DATE_REQUIRED <= 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.LINE_ID;