Analytics Catalog/Data dictionary/WIS_WORK_DEFINITIONS
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
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)

Columns

ColumnKeyIn reportsDescription (inferred)
COSTING_PRIORITYCosting priority.
INACTIVE_DATEInactive date.
MINIMUM_TRANSFER_QUANTITYMinimum transfer quantity.
ORGANIZATION_IDIdentifier for the organization.
PREASSIGN_LOT_FLAGIndicator (Y/N) for the preassign lot.
PRODUCTION_PRIORITYProduction priority.
QUANTITYQuantity.
SERIAL_TRACKING_FLAGIndicator (Y/N) for the serial tracking.
STATUS_CODECode identifying the status.
SYSTEM_GENERATED_FLAGIndicator (Y/N) for the system generated.
TRANSFORM_FROM_ITEM_IDIdentifier for the transform from item.
UOM_CODECode identifying the unit of measure.
WORK_DEFINITION_HEADER_NAMEName of the work definition header.
WORK_DEFINITION_IDPK?Identifier for the work definition.
WORK_DEFINITION_TYPEType 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.

Need the extract + dbt staging for WIS_WORK_DEFINITIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us