CST_COST_DISTRIBUTION_LINES

-- ============================================================
-- Table  : CST_COST_DISTRIBUTION_LINES — The debit and credit lines under each cost distribution — per cost element, with entered and ledger amounts and both the user-entered and final SLA-derived GL accounts
-- Purpose: Column-selected read of CST_COST_DISTRIBUTION_LINES — auto-generated from field metadata
-- Grain  : One row per DISTRIBUTION_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.DISTRIBUTION_LINE_ID AS "Surrogate key of the debit/credit line",
  t.DISTRIBUTION_ID AS "Parent distribution header",
  t.LINE_NUMBER AS "Line number within the distribution",
  t.ACCOUNTING_LINE_TYPE AS "Accounting line type",
  t.DR_CR_SIGN AS "Debit or credit indicator",
  t.COST_ELEMENT_ID AS "The cost element — the element grain lives here, not on the header",
  t.TRANSACTION_COST_ID AS "The receipt cost row behind the line",
  t.ENTERED_CURRENCY_AMOUNT AS "Amount in the transaction currency",
  t.ENTERED_CURRENCY_CODE AS "Transaction currency",
  t.LEDGER_AMOUNT AS "Amount in the base/ledger currency",
  t.CODE_COMBINATION_ID AS "User-entered GL account",
  t.SLA_CODE_COMBINATION_ID AS "Final SLA-derived GL account — reconcile GL against this one",
  t.GL_DATE AS "Accounting date",
  t.EVENT_ID AS "Subledger accounting event"
FROM <catalog>.<schema>.CST_COST_DISTRIBUTION_LINES t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.DISTRIBUTION_LINE_ID = <DISTRIBUTION_LINE_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.DISTRIBUTION_LINE_ID;