RCV_SHIPMENT_LINES

-- ============================================================
-- Table  : RCV_SHIPMENT_LINES — Receipt/shipment lines — one row per item per shipment header with cumulative shipped and received quantities, line status, the source-document pointers, and the default putaway destination
-- Purpose: Column-selected read of RCV_SHIPMENT_LINES — auto-generated from field metadata
-- Grain  : One row per SHIPMENT_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.SHIPMENT_LINE_ID AS "Surrogate key of the shipment/receipt line",
  t.SHIPMENT_HEADER_ID AS "Parent shipment header",
  t.LINE_NUM AS "Line number within the shipment",
  t.ITEM_ID AS "Item on the line",
  t.ITEM_REVISION AS "Item revision",
  t.CATEGORY_ID AS "Item category",
  t.QUANTITY_SHIPPED AS "Net (cumulative) quantity shipped on the line — a running total, not an event",
  t.QUANTITY_RECEIVED AS "Net (cumulative) quantity received on the line",
  t.UOM_CODE AS "UOM of the line quantities",
  t.TO_ORGANIZATION_ID AS "Receiving inventory org — the item-join org half",
  t.FROM_ORGANIZATION_ID AS "Source org on in-transit lines",
  t.SHIPMENT_LINE_STATUS_CODE AS "EXPECTED / PARTIALLY RECEIVED / FULLY RECEIVED / CANCELLED",
  t.SOURCE_DOCUMENT_CODE AS "Which document type the line receives against",
  t.PO_HEADER_ID AS "PO header pointer",
  t.PO_LINE_ID AS "PO line pointer",
  t.PO_LINE_LOCATION_ID AS "PO schedule pointer",
  t.DESTINATION_TYPE_CODE AS "Destination type of the line",
  t.TO_SUBINVENTORY AS "Default destination subinventory"
FROM <catalog>.<schema>.RCV_SHIPMENT_LINES t
WHERE
  1 = 1  -- no automatic partition anchor on this table; the filters below are optional
  -- AND t.SHIPMENT_LINE_ID = <SHIPMENT_LINE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.SHIPMENT_LINE_ID;