DOO_LINES_ALL

-- ============================================================
-- Table  : DOO_LINES_ALL — Sales order lines — the middle tier between the header and the fulfillment lines, carrying the item, ordered/shipped/fulfilled quantities, selling price, and line status
-- Purpose: Column-selected read of DOO_LINES_ALL — auto-generated from field metadata
-- Grain  : One row per business unit (ORG_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 "Surrogate key of the order line",
  t.HEADER_ID AS "Parent orchestration order header",
  t.LINE_NUMBER AS "Line number used with fulfillment systems",
  t.ORG_ID AS "The business unit owning the line",
  t.INVENTORY_ITEM_ID AS "Item on the line",
  t.INVENTORY_ORGANIZATION_ID AS "The item-master inventory organization — pairs with the item id for item joins",
  t.ORDERED_QTY AS "Quantity ordered",
  t.ORDERED_UOM AS "UOM for the ordered quantity",
  t.SHIPPED_QTY AS "Quantity shipped on the line",
  t.FULFILLED_QTY AS "Quantity used to fulfill the line",
  t.CANCELED_QTY AS "Quantity canceled",
  t.STATUS_CODE AS "Orchestration order line status",
  t.OPEN_FLAG AS "Y while the line is not closed or canceled",
  t.CANCELED_FLAG AS "Y when the line is canceled",
  t.ON_HOLD AS "Line not accepting further processing",
  t.UNIT_SELLING_PRICE AS "Unit price the buyer paid",
  t.EXTENDED_AMOUNT AS "Monetary amount for the line quantity",
  t.FULFILLMENT_DATE AS "Date the line was fulfilled"
FROM <catalog>.<schema>.DOO_LINES_ALL t
WHERE
  t.ORG_ID = <business_unit_id>  -- business unit — Fusion _ALL means BU, not the EBS operating unit; see quirks guide #all-means-bu
  -- AND t.LINE_ID = <LINE_ID>
  -- AND t.FULFILLMENT_DATE >= DATE '<DATE_FROM>'
  -- AND t.FULFILLMENT_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.LINE_ID;