Oracle Fusion · Data dictionary
WIS_WD_OPERATIONS_V
SharedUsed in 4 subject areas24 reporting columns
Work Instructions (WIS), denormalized view.
Likely primary key: WD_OPERATION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDL_MTL_AT_MANUAL_ISSUE | ● | Addl mtl at manual issue. | |
| AUTO_TRANSACT_FLAG | ● | Indicator (Y/N) for the auto transact. | |
| COUNT_POINT_FLAG | ● | Indicator (Y/N) for the count point. | |
| EFFECTIVE_FROM_DATE | ● | Effective from date. | |
| EFFECTIVE_TO_DATE | ● | Effective to date. | |
| FIXED_LEAD_TIME | ● | Fixed lead time. | |
| LEAD_TIME_PERCENT | ● | Lead time percentage. | |
| LEAD_TIME_UOM | ● | Lead time unit of measure. | |
| OPERATION_DESCRIPTION | ● | Description of the operation. | |
| OPERATION_NAME | ● | Name of the operation. | |
| OPERATION_SEQ_NUMBER | ● | Operation seq number. | |
| OPERATION_TYPE | ● | Type of operation. | |
| OPTION_DEPENDENT_FLAG | ● | Indicator (Y/N) for the option dependent. | |
| OP_COMPL_WITH_OPEN_EXCEPTIONS | ● | Op compl with open exceptions. | |
| OP_COMPL_WITH_UNDER_ISSUE | ● | Op compl with under issue. | |
| OP_YIELD_FACTOR | ● | Op yield factor. | |
| OSP_ITEM_ID | ● | Identifier for the osp item. | |
| PLANNING_PERCENT | ● | Planning percentage. | |
| REFERENCED_FLAG | ● | Indicator (Y/N) for the referenced. | |
| RESEQUENCE_FLAG | ● | Indicator (Y/N) for the resequence. | |
| SERIAL_TRACKING_FLAG | ● | Indicator (Y/N) for the serial tracking. | |
| SHIPPING_DOCUMENTS_FLAG | ● | Indicator (Y/N) for the shipping documents. | |
| VARIABLE_LEAD_TIME | ● | Variable lead time. | |
| WD_OPERATION_ID | PK? | ● | Identifier for the wd operation. |
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 - Cost Rollup Details Real Time
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Where Used Details Real Time
- Manufacturing - Work Definitions Real Time
Need the extract + dbt staging for WIS_WD_OPERATIONS_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table