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.
Problems that run through this table