AP_INVOICE_DISTRIBUTIONS_ALL

-- ============================================================
-- Table  : AP_INVOICE_DISTRIBUTIONS_ALL — Supplier invoice distributions — one row per GL-account allocation of an invoice line; the spend-to-account grain payables accounting posts from
-- Purpose: Column-selected read of AP_INVOICE_DISTRIBUTIONS_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + INVOICE_DISTRIBUTION_ID
-- Caution: Accounting grain — one line fans out across account rows and reversal pairs net to zero; exclude reversals or group by line before comparing to line amounts
-- 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.INVOICE_DISTRIBUTION_ID AS "Surrogate key of the distribution",
  t.ORG_ID AS "Operating unit",
  t.INVOICE_ID AS "The invoice",
  t.INVOICE_LINE_NUMBER AS "The parent invoice line",
  t.DISTRIBUTION_LINE_NUMBER AS "Distribution number within the line — completes the natural key",
  t.LINE_TYPE_LOOKUP_CODE AS "Distribution type — a lookup code, undecoded",
  t.DIST_CODE_COMBINATION_ID AS "The charge account (CCID) — the AP tie to the general ledger",
  t.AMOUNT AS "Distribution amount",
  t.BASE_AMOUNT AS "Amount in the ledger currency",
  t.QUANTITY_INVOICED AS "Quantity on the distribution",
  t.ACCOUNTING_DATE AS "The accounting date — the primary analysis date",
  t.PERIOD_NAME AS "The accounting period",
  t.PO_DISTRIBUTION_ID AS "The matched PO distribution",
  t.RCV_TRANSACTION_ID AS "The matched receiving transaction",
  t.POSTED_FLAG AS "Whether the distribution has been accounted",
  t.REVERSAL_FLAG AS "Marks reversal pairs that net to zero — exclude before summing"
FROM <catalog>.<schema>.AP_INVOICE_DISTRIBUTIONS_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.INVOICE_DISTRIBUTION_ID = <INVOICE_DISTRIBUTION_ID>
  -- AND t.ACCOUNTING_DATE >= DATE '<DATE_FROM>'
  -- AND t.ACCOUNTING_DATE <= DATE '<DATE_TO>'
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.INVOICE_DISTRIBUTION_ID;