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 (PO, requisition, or RMA), 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 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.SHIPMENT_LINE_ID AS "Surrogate key of the shipment line",
  t.SHIPMENT_HEADER_ID AS "The parent header — unique with LINE_NUM",
  t.LINE_NUM AS "Line number within the header",
  t.ITEM_ID AS "The item — this table's name for it; pairs with TO_ORGANIZATION_ID for item-master joins",
  t.QUANTITY_SHIPPED AS "Quantity on the ASN/shipment",
  t.QUANTITY_RECEIVED AS "Cumulative quantity received — a balance; events live in the transaction ledger",
  t.UNIT_OF_MEASURE AS "Transaction UOM, in its 25-character name form (not the 3-char code)",
  t.SHIPMENT_LINE_STATUS_CODE AS "Line status — expected, partially received, fully received, cancelled",
  t.SOURCE_DOCUMENT_CODE AS "What kind of document the line receives against — PO, requisition, RMA, or inventory",
  t.DESTINATION_TYPE_CODE AS "Where the goods are headed — receiving, inventory, expense, shop floor",
  t.PO_HEADER_ID AS "The PO being received, for PO-sourced lines",
  t.PO_LINE_ID AS "The PO line",
  t.PO_LINE_LOCATION_ID AS "The PO shipment schedule",
  t.REQUISITION_LINE_ID AS "The requisition line, for internal-order receipts",
  t.OE_ORDER_LINE_ID AS "The sales order line, for RMA (customer-return) receipts",
  t.TO_ORGANIZATION_ID AS "The receiving inventory org — the item-join org half",
  t.FROM_ORGANIZATION_ID AS "The shipping org, on internal shipments",
  t.TO_SUBINVENTORY AS "Default putaway subinventory"
FROM <catalog>.<schema>.RCV_SHIPMENT_LINES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.SHIPMENT_LINE_ID = <SHIPMENT_LINE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.SHIPMENT_LINE_ID;