PO_DISTRIBUTIONS_ALL

-- ============================================================
-- Table  : PO_DISTRIBUTIONS_ALL — PO accounting distributions — how each schedule's quantity charges out: destination type and org, deliver-to, the GL charge account, project costing columns, and the requisition distribution it fulfills
-- Purpose: Column-selected read of PO_DISTRIBUTIONS_ALL — auto-generated from field metadata
-- Grain  : One row per PO_DISTRIBUTION_ID
-- Caution: Accounting grain — a schedule can split across several distributions, so joining schedules to distributions multiplies quantities
-- 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.PO_DISTRIBUTION_ID AS "Surrogate key of the distribution",
  t.LINE_LOCATION_ID AS "Parent schedule",
  t.PO_LINE_ID AS "Parent line (denormalized)",
  t.PO_HEADER_ID AS "Parent header (denormalized)",
  t.DISTRIBUTION_NUM AS "Visible distribution number",
  t.QUANTITY_ORDERED AS "Quantity allocated to this distribution",
  t.QUANTITY_DELIVERED AS "Quantity delivered against it",
  t.QUANTITY_BILLED AS "Quantity invoiced against it",
  t.QUANTITY_CANCELLED AS "Quantity cancelled",
  t.DESTINATION_TYPE_CODE AS "Inventory vs expense destination",
  t.DESTINATION_ORGANIZATION_ID AS "Final destination organization — resolves through the HR org master",
  t.DESTINATION_SUBINVENTORY AS "Target subinventory for inventory destinations",
  t.DELIVER_TO_PERSON_ID AS "The requester the goods are delivered to",
  t.CODE_COMBINATION_ID AS "GL charge account — the only PO level carrying GL accounts",
  t.REQ_DISTRIBUTION_ID AS "Source requisition distribution — the system link back to the requisition",
  t.PJC_PROJECT_ID AS "Project-costing project — note the PJC_ prefix",
  t.RATE AS "Currency conversion rate"
FROM <catalog>.<schema>.PO_DISTRIBUTIONS_ALL t
WHERE
  1 = 1  -- no partition column on this table; the filters below are optional
  -- AND t.PO_DISTRIBUTION_ID = <PO_DISTRIBUTION_ID>
  -- AND t.LAST_UPDATE_DATE >= TIMESTAMP '<watermark>'  -- the column incremental BICC extracts key on
ORDER BY t.PO_DISTRIBUTION_ID;