Oracle Fusion · Data dictionary
WIE_WO_OPERATION_MATERIALS
SharedUsed in 2 subject areas15 reporting columns
Work in Process (WIE).
Likely primary key: WO_OPERATION_MATERIAL_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ALLOCATED_QUANTITY | ● | Allocated quantity. | |
| BASIS_TYPE | ● | Type of basis. | |
| CONTRIBUTE_TO_YIELD_FLAG | ● | Indicator (Y/N) for the contribute to yield. | |
| ENFORCE_INT_REQUIREMENTS | ● | Enforce int requirements. | |
| EXTENDED_QUANTITY | ● | Extended quantity. | |
| INCLUDE_IN_PLANNING_FLAG | ● | Indicator (Y/N) for the include in planning. | |
| ISSUED_QUANTITY | ● | Issued quantity. | |
| MATERIAL_SEQ_NUMBER | ● | Material seq number. | |
| PICKED_QUANTITY | ● | Picked quantity. | |
| QUANTITY | ● | Quantity. | |
| REQUIRED_DATE | ● | Required date. | |
| SUBSTITUTE_FLAG | ● | Indicator (Y/N) for the substitute. | |
| SUPPLY_TYPE | ● | Type of supply. | |
| WO_OPERATION_MATERIAL_ID | PK? | ● | Identifier for the wo operation material. |
| YIELD_FACTOR | ● | Yield factor. |
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 WIE_WO_OPERATION_MATERIALS?
We ship parameterized SQL, BICC config, and dbt models you own.