Oracle Fusion · Data dictionary
WIS_WORK_DEFINITIONS
SharedUsed in 21 subject areas15 reporting columns
Work Instructions (WIS).
Likely primary key: WORK_DEFINITION_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Joins (inferred from key columns): ORGANIZATION_ID → INV_ORGANIZATION_DEFINITIONS_V
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| COSTING_PRIORITY | ● | Costing priority. | |
| INACTIVE_DATE | ● | Inactive date. | |
| MINIMUM_TRANSFER_QUANTITY | ● | Minimum transfer quantity. | |
| ORGANIZATION_ID | ● | Identifier for the organization. | |
| PREASSIGN_LOT_FLAG | ● | Indicator (Y/N) for the preassign lot. | |
| PRODUCTION_PRIORITY | ● | Production priority. | |
| QUANTITY | ● | Quantity. | |
| SERIAL_TRACKING_FLAG | ● | Indicator (Y/N) for the serial tracking. | |
| STATUS_CODE | ● | Code identifying the status. | |
| SYSTEM_GENERATED_FLAG | ● | Indicator (Y/N) for the system generated. | |
| TRANSFORM_FROM_ITEM_ID | ● | Identifier for the transform from item. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| WORK_DEFINITION_HEADER_NAME | ● | Name of the work definition header. | |
| WORK_DEFINITION_ID | PK? | ● | Identifier for the work definition. |
| WORK_DEFINITION_TYPE | ● | Type of work definition. |
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 Accounting Real Time
- Costing - Cost Rollup Details Real Time
- Costing - Supply Chain Cost Rollup Real Time
- Costing - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Maintenance Management - Work Requirement 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
- Product Genealogy - Genealogy Instance Real Time
- Product Genealogy - Genealogy Object Composition Real Time
- Product Genealogy - Genealogy Object Where Used Real Time
Need the extract + dbt staging for WIS_WORK_DEFINITIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table