Oracle Fusion · Data dictionary
PO_DISTRIBUTIONS_DRAFT_ALL
ProcurementUsed in 2 subject areas12 reporting columns
Purchasing (PO) — transaction table (rows scoped across all operating units).
Likely primary key: PO_DISTRIBUTION_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| AMOUNT_ORDERED | ● | Amount ordered. | |
| BUDGET_DATE | ● | Budget date. | |
| CO_AMOUNT_CANCELLED | ● | Co amount cancelled. | |
| CO_QUANTITY_CANCELLED | ● | Co quantity cancelled. | |
| DISTRIBUTION_NUM | ● | Distribution number. | |
| FUNDS_STATUS | ● | Status of the funds. | |
| PO_DISTRIBUTION_ID | PK? | ● | Identifier for the purchase order distribution. |
| QUANTITY_ORDERED | ● | Quantity ordered. | |
| RATE | ● | Rate. | |
| REASON_FOR_CHANGE | ● | Reason for change. | |
| REQ_HEADER_REFERENCE_NUM | ● | Req header reference number. | |
| REQ_LINE_REFERENCE_NUM | ● | Req line reference number. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for PO_DISTRIBUTIONS_DRAFT_ALL?
We ship parameterized SQL, BICC config, and dbt models you own.