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.

Need the extract + dbt staging for WIE_WORK_ORDERS_B?

We ship parameterized SQL, BICC config, and dbt models you own.

Talk to us