AP_INVOICE_DISTRIBUTIONS_ALL

-- ============================================================
-- Table  : AP_INVOICE_DISTRIBUTIONS_ALL — Payables invoice distributions — the accounting grain under each line: one row per charged GL account with the amount, accounting date, period, and posted state; where AP spend meets the ledger
-- Purpose: Column-selected read of AP_INVOICE_DISTRIBUTIONS_ALL — auto-generated from field metadata
-- Grain  : One row per business unit (ORG_ID) + INVOICE_DISTRIBUTION_ID
-- Caution: Accounting grain — a line can split across several distributions, so joining lines to distributions multiplies line amounts
-- 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.INVOICE_DISTRIBUTION_ID AS "Surrogate key of the distribution",
  t.INVOICE_ID AS "The invoice",
  t.INVOICE_LINE_NUMBER AS "The invoice line — pairs with INVOICE_ID for the composite line join",
  t.ORG_ID AS "The business unit owning the distribution",
  t.DISTRIBUTION_LINE_NUMBER AS "Distribution number within the invoice",
  t.LINE_TYPE_LOOKUP_CODE AS "Distribution type",  -- decode t.LINE_TYPE_LOOKUP_CODE via FND_LOOKUP_VALUES (LOOKUP_TYPE = 'INVOICE DISTRIBUTION TYPE', LANGUAGE-filtered)
  t.DIST_CODE_COMBINATION_ID AS "The charged GL account (CCID)",
  t.ACCOUNTING_DATE AS "Date the distribution is accounted",
  t.PERIOD_NAME AS "Accounting period",
  t.AMOUNT AS "Distribution amount in invoice currency",
  t.BASE_AMOUNT AS "Amount in ledger currency, for foreign-currency invoices",
  t.POSTED_FLAG AS "Y accounted, N not — page-documented",
  t.REVERSAL_FLAG AS "Part of a reversal pair — net, don't count",
  t.PO_DISTRIBUTION_ID AS "Matched PO distribution",
  t.RCV_TRANSACTION_ID AS "Matched receiving transaction",
  t.SET_OF_BOOKS_ID AS "The LEDGER — legacy column name, required here"
FROM <catalog>.<schema>.AP_INVOICE_DISTRIBUTIONS_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.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>'  -- the column incremental BICC extracts key on
ORDER BY t.INVOICE_DISTRIBUTION_ID;