INV_TRANSFER_ORDER_LINES

-- ============================================================
-- Table  : INV_TRANSFER_ORDER_LINES — Transfer order lines — the actionable grain carrying item, source and destination organizations, the requested/shipped/received/delivered quantity lifecycle, dates, and the transfer price
-- Purpose: Column-selected read of INV_TRANSFER_ORDER_LINES — auto-generated from field metadata
-- Grain  : One row per LINE_ID
-- Caution: Fulfillment is a quantity ladder — REQUESTED_QTY → SHIPPED_QTY → RECEIVED_QTY → DELIVERED_QTY — with no stored open-quantity column; open is arithmetic
-- 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 "Transfer-order-line surrogate key",
  t.HEADER_ID AS "Parent transfer order",
  t.LINE_NUMBER AS "Line sequence",
  t.INVENTORY_ITEM_ID AS "Item transferred",
  t.SOURCE_ORGANIZATION_ID AS "Shipping (supply) inventory organization",
  t.DESTINATION_ORGANIZATION_ID AS "Receiving (demand) inventory organization",
  t.DESTINATION_TYPE_LOOKUP AS "Whether material lands in inventory or expense",
  t.SOURCE_TYPE_LOOKUP AS "Originating process for the line",
  t.STATUS_LOOKUP AS "Line status — OPEN, CLOSED, or CANCELLED as a VARCHAR2 code",
  t.INTERFACE_STATUS_LOOKUP AS "Handoff state to orchestration/shipping (awaiting, interfaced, error)",
  t.QTY_UOM_CODE AS "UOM for the quantity ladder",
  t.REQUESTED_QTY AS "Quantity ordered — note the _QTY spelling",
  t.SHIPPED_QTY AS "Quantity shipped so far",
  t.RECEIVED_QTY AS "Quantity received at the destination",
  t.DELIVERED_QTY AS "Quantity put away into destination inventory",
  t.NEED_BY_DATE AS "Requested arrival date",
  t.SCHEDULED_SHIP_DATE AS "Planned ship date",
  t.UNIT_PRICE AS "Transfer price per unit, in the requesting org's currency"
FROM <catalog>.<schema>.INV_TRANSFER_ORDER_LINES t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.LINE_ID = <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.LINE_ID;