INV_TXN_REQUEST_LINES

-- ============================================================
-- Table  : INV_TXN_REQUEST_LINES — Movement request lines — each row requests moving a quantity of an item from a source to a destination subinventory (or account), individually statused, allocated (quantity detailed), and delivered
-- Purpose: Column-selected read of INV_TXN_REQUEST_LINES — auto-generated from field metadata
-- Grain  : One row per inventory org (ORGANIZATION_ID) + 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.LINE_ID AS "Movement-request-line surrogate key",
  t.HEADER_ID AS "Parent movement request",
  t.LINE_NUMBER AS "Line sequence within the request",
  t.ORGANIZATION_ID AS "Inventory organization of the line",
  t.INVENTORY_ITEM_ID AS "Item being moved",
  t.FROM_SUBINVENTORY_CODE AS "Source subinventory",
  t.FROM_LOCATOR_ID AS "Source locator",
  t.TO_SUBINVENTORY_CODE AS "Destination subinventory",
  t.TO_LOCATOR_ID AS "Destination locator",
  t.TO_ORGANIZATION_ID AS "Destination organization on cross-org moves",
  t.TO_ACCOUNT_ID AS "Destination account on account-issue lines",
  t.UOM_CODE AS "UOM for the quantity columns",
  t.QUANTITY AS "Requested quantity",
  t.QUANTITY_DETAILED AS "Quantity already allocated (pick-detailed)",
  t.QUANTITY_DELIVERED AS "Quantity actually delivered — open balance is QUANTITY minus this",
  t.DATE_REQUIRED AS "Line need date",
  t.LINE_STATUS AS "Line status — a numeric code",
  t.TRANSACTION_TYPE_ID AS "Transaction type governing the move"
FROM <catalog>.<schema>.INV_TXN_REQUEST_LINES t
WHERE
  t.ORGANIZATION_ID = <inventory_org_id>  -- inventory org, NOT the business unit — see quirks guide #item-org-striping
  -- 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>'  -- the column incremental BICC extracts key on
ORDER BY t.LINE_ID;