Oracle Fusion · Data dictionary
WIE_WORK_ORDERS_B
SharedUsed in 33 subject areas55 reporting columns
Work in Process (WIE), base table, language-neutral data (paired with _TL labels and the _VL view).
Likely primary key: WORK_ORDER_ID (inferred from Oracle naming conventions, verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTUAL_COMPLETION_DATE | ● | Actual completion date. | |
| ACTUAL_START_DATE | ● | Actual start date. | |
| BACK_TO_BACK_FLAG | ● | Indicator (Y/N) for the back to back. | |
| CANCELED_DATE | ● | Canceled date. | |
| CANCELED_REASON | ● | Canceled reason. | |
| CLOSED_DATE | ● | Closed date. | |
| COMPLETED_QUANTITY | ● | Completed quantity. | |
| COMPL_SUBINVENTORY_CODE | ● | Code identifying the compl subinventory. | |
| CONTRACT_MFG_FLAG | ● | Indicator (Y/N) for the contract manufacturing. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EXPEDITED_FLAG | ● | Indicator (Y/N) for the expedited. | |
| FIRM_PLANNED_FLAG | ● | Indicator (Y/N) for the firm planned. | |
| KANBAN_CARD_NUMBER | ● | Kanban card number. | |
| KANBAN_REPLENISHMENT_CYCLE_ID | ● | Identifier for the kanban replenishment cycle. | |
| MNT_ALLOW_MULTIPLE_ASSETS_FLAG | ● | Indicator (Y/N) for the mnt allow multiple assets. | |
| MNT_COMPLETE_TO_INV_FLAG | ● | Indicator (Y/N) for the mnt complete to inventory. | |
| MNT_FORECAST_ID | ● | Identifier for the mnt forecast. | |
| MNT_INCLUDE_IN_PLANNING_FLAG | ● | Indicator (Y/N) for the mnt include in planning. | |
| MNT_OUT_OF_SEQUENCE_FLAG | ● | Indicator (Y/N) for the mnt out of sequence. | |
| MNT_ROUTE_COMPLETION_CODE | ● | Code identifying the mnt route completion. | |
| MNT_ROUTE_HIERARCHY_ID | ● | Identifier for the mnt route hierarchy. | |
| MNT_ROUTE_SKIP_ALLOWED_FLAG | ● | Indicator (Y/N) for the mnt route skip allowed. | |
| MNT_TRANSFORM_TO_ITEM_ID | ● | Identifier for the mnt transform to item. | |
| NEED_BY_DATE | ● | Need by date. | |
| ORDER_LESS_FLAG | ● | Indicator (Y/N) for the order less. | |
| OVERCOMPL_TOLERANCE_TYPE | ● | Type of overcompl tolerance. | |
| OVERCOMPL_TOLERANCE_VALUE | ● | Overcompl tolerance value. | |
| PLANNED_COMPLETION_DATE | ● | Planned completion date. | |
| PLANNED_START_DATE | ● | Planned start date. | |
| PLANNED_START_QUANTITY | ● | Planned start quantity. | |
| PREASSIGN_LOT_FLAG | ● | Indicator (Y/N) for the preassign lot. | |
| PRIMARY_PRODUCT_QUANTITY | ● | Primary product quantity. | |
| PRIMARY_PRODUCT_UOM_CODE | ● | Code identifying the primary product unit of measure. | |
| REJECTED_QUANTITY | ● | Rejected quantity. | |
| RELEASED_DATE | ● | Released date. | |
| RESEQUENCE_FLAG | ● | Indicator (Y/N) for the resequence. | |
| SCHEDULING_METHOD | ● | Scheduling method. | |
| SCRAPPED_QUANTITY | ● | Scrapped quantity. | |
| SERIAL_TRACKING_FLAG | ● | Indicator (Y/N) for the serial tracking. | |
| SOURCE_HEADER_REF | ● | Source header reference. | |
| SOURCE_LINE_REF | ● | Source line reference. | |
| SOURCE_SYSTEM_ID | ● | Identifier for the source system. | |
| SOURCE_SYSTEM_TYPE | ● | Type of source system. | |
| SYNCH_WD_FLAG | ● | Indicator (Y/N) for the synch wd. | |
| UNDERCOMPL_TOLERANCE_TYPE | ● | Type of undercompl tolerance. | |
| UNDERCOMPL_TOLERANCE_VALUE | ● | Undercompl tolerance value. | |
| UNDER_COMPLETED_FLAG | ● | Indicator (Y/N) for the under completed. | |
| UOM_CODE | ● | Code identifying the unit of measure. | |
| VARIANCE_QUANTITY | ● | Variance quantity. | |
| WORK_ORDER_ID | PK? | ● | Identifier for the work order. |
| WORK_ORDER_NUMBER | ● | Work order number. | |
| WORK_ORDER_PRIORITY | ● | Work order priority. | |
| WORK_ORDER_SUB_TYPE | ● | Type of work order sub. | |
| WORK_ORDER_TYPE | ● | Type of work order. |
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 - Where Used Details Real Time
- Costing - Work Order Costs Real Time
- Distributed Order Orchestration - Fulfillment Lines Real Time
- Installed Base - Customer Asset History Real Time
- Installed Base - Customer Asset Real Time
- Installed Base - Meter Based Asset Usage Real Time
- Inventory - Kanban Activity Real Time
- Maintenance Management - Asset Equipment Qualification Real Time
- Maintenance Management - Asset Failure Analysis Real Time
- Maintenance Management - Asset History Real Time
- Maintenance Management - Asset Real Time
- Maintenance Management - Forecast Real Time
- Maintenance Management - Maintenance Exception Real Time
- Maintenance Management - Material Usage Real Time
- Maintenance Management - Purchased Item Usage Real Time
- Maintenance Management - Resource Usage Real Time
- Maintenance Management - Work Order Performance Real Time
- Manufacturing - Actual Production Real Time
Need the extract + dbt staging for WIE_WORK_ORDERS_B?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table