Oracle Fusion · Data dictionary
WIS_WD_OPERATION_MATERIALS_V
SharedUsed in 1 subject areas14 reporting columns
Work Instructions (WIS) — denormalized view.
Likely primary key: WD_OPERATION_MATERIAL_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADHOC_FLAG | ● | Indicator (Y/N) for the adhoc. | |
| BASIS_TYPE | ● | Type of basis. | |
| CONTRIBUTE_TO_YIELD_FLAG | ● | Indicator (Y/N) for the contribute to yield. | |
| DISABLE_DATE | ● | Disable date. | |
| EFFECTIVITY_DATE | ● | Effectivity date. | |
| ENFORCE_INT_REQUIREMENTS | ● | Enforce int requirements. | |
| INVERSE_MATERIAL_QUANTITY | ● | Inverse material quantity. | |
| MATERIAL_QUANTITY | ● | Material quantity. | |
| MATERIAL_SEQ_NUMBER | ● | Material seq number. | |
| SUPPLY_SUBINVENTORY_NAME | ● | Name of the supply subinventory. | |
| SUPPLY_TYPE | ● | Type of supply. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| WD_OPERATION_MATERIAL_ID | PK? | ● | Identifier for the wd 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 WIS_WD_OPERATION_MATERIALS_V?
We ship parameterized SQL, BICC config, and dbt models you own.