PO_DISTRIBUTIONS_ALL

-- ============================================================
-- Table  : PO_DISTRIBUTIONS_ALL — PO accounting distributions — how each shipment schedule's quantity charges out: destination type, receiving inventory org and subinventory, charge account (CCID), and the requisition distribution it fulfills
-- Purpose: Column-selected read of PO_DISTRIBUTIONS_ALL — auto-generated from field metadata
-- Grain  : One row per operating unit (ORG_ID) + PO_DISTRIBUTION_ID
-- Caution: Accounting grain — a shipment can split across several distributions, so joining lines to distributions multiplies quantities
-- 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.PO_DISTRIBUTION_ID AS "Surrogate key of the distribution",
  t.LINE_LOCATION_ID AS "The shipment schedule being distributed — a shipment can split across distributions",
  t.PO_LINE_ID AS "The document line (denormalized)",
  t.PO_HEADER_ID AS "The document header (denormalized)",
  t.ORG_ID AS "Operating unit",
  t.DISTRIBUTION_NUM AS "Distribution number within the shipment",
  t.DESTINATION_TYPE_CODE AS "Where the goods charge to — inventory, expense, or shop floor",
  t.DESTINATION_ORGANIZATION_ID AS "The receiving inventory org for the distribution",
  t.DESTINATION_SUBINVENTORY AS "Default putaway subinventory",
  t.CODE_COMBINATION_ID AS "The charge account (CCID) — the P2P tie to the general ledger",
  t.ACCRUAL_ACCOUNT_ID AS "The accrual account (CCID)",
  t.QUANTITY_ORDERED AS "Quantity on the distribution",
  t.QUANTITY_DELIVERED AS "Running total delivered against the distribution",
  t.QUANTITY_BILLED AS "Running total billed against the distribution",
  t.REQ_DISTRIBUTION_ID AS "The requisition distribution this fulfills — the req-to-PO accounting thread",
  t.WIP_ENTITY_ID AS "The WIP job an outside-processing distribution charges — the P2P tie to the shop floor"
FROM <catalog>.<schema>.PO_DISTRIBUTIONS_ALL t
WHERE
  t.ORG_ID = <operating_unit_id>  -- operating unit (MOAC does not filter extracts)
  -- AND t.PO_DISTRIBUTION_ID = <PO_DISTRIBUTION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- WHO watermark, bulk-stamped by batch jobs; see quirks guide #who-columns
ORDER BY t.PO_DISTRIBUTION_ID;