Oracle Fusion · Data dictionary
WIS_WD_VERSIONS
SharedUsed in 9 subject areas9 reporting columns
Work Instructions (WIS).
Primary key: not yet catalogued for WIS_WD_VERSIONS, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| APPROVAL_STATUS_CODE | ● | Code identifying the approval status. | |
| COMPLETION_SUBINVENTORY_NAME | ● | Name of the completion subinventory. | |
| COSTING_BATCH_OUTPUT_SIZE | ● | Costing batch output size. | |
| EFFECTIVE_FROM_DATE | ● | Effective from date. | |
| EFFECTIVE_TO_DATE | ● | Effective to date. | |
| MAXIMUM_BATCH_QUANTITY | ● | Maximum batch quantity. | |
| MINIMUM_BATCH_QUANTITY | ● | Minimum batch quantity. | |
| VERSION_NUMBER | ● | Version number. | |
| WORK_DEFINITION_VERSION_ID | ● | Identifier for the work definition version. |
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.
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Work Order Costs Real Time
- Manufacturing - Actual Production Real Time
- Manufacturing - Material Usage Real Time
- Manufacturing - Resource Usage Real Time
- Manufacturing - Work Definitions Real Time
- Manufacturing - Work Order Performance Real Time
- Manufacturing - Workstation Execution Activities Monitoring Real Time
- Manufacturing - Workstation Supervision Real Time
Need the extract + dbt staging for WIS_WD_VERSIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table