MNT_WORK_ORDERS

Details

Schema: FUSION
Object owner: MNT
Object type: VIEW

Columns

Name
WORK_ORDER_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WORK_ORDER_NUMBER WORK_METHOD_ID WORK_ORDER_TYPE WORK_ORDER_SUB_TYPE INVENTORY_ITEM_ID ITEM_REVISION ITEM_VERSION ITEM_STRUCTURE_NAME WORK_DEFINITION_AS_OF_DATE WORK_DEFINITION_ID WORK_DEFINITION_VERSION_ID WORK_ORDER_PRIORITY WORK_ORDER_STATUS_ID SCHEDULING_METHOD PLANNED_START_QUANTITY NETTABLE_SUPPLY_QTY_OVERRIDE UOM_CODE FIRM_PLANNED_FLAG PLANNED_START_DATE PLANNED_COMPLETION_DATE ACTUAL_START_DATE ACTUAL_COMPLETION_DATE RELEASED_DATE CLOSED_DATE CANCELED_DATE CANCELED_REASON STATUS_CHANGE_REASON COMPLETED_QUANTITY SCRAPPED_QUANTITY REJECTED_QUANTITY OVERCOMPL_TOLERANCE_TYPE OVERCOMPL_TOLERANCE_VALUE SUPPLY_TYPE COMPL_SUBINVENTORY_CODE COMPL_LOCATOR_ID SERIAL_TRACKING_FLAG BACK_TO_BACK_FLAG ORCHESTRATION_CODE INTERFACE_SOURCE_CODE SCO_SUPPLY_ORDER_ID CONTRACT_MFG_FLAG CM_PO_HEADER_ID CM_PO_LINE_ID CM_PO_LINE_LOC_ID ORDER_LESS_FLAG SOURCE_SYSTEM_TYPE SOURCE_SYSTEM_ID SOURCE_HEADER_REF SOURCE_HEADER_REF_ID SOURCE_LINE_REF SOURCE_LINE_REF_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR20 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER10 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP5 REQUEST_ID JOB_DEFINITION_NAME JOB_DEFINITION_PACKAGE

Name

WORK_ORDER_ID

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

WORK_ORDER_NUMBER

WORK_METHOD_ID

WORK_ORDER_TYPE

WORK_ORDER_SUB_TYPE

INVENTORY_ITEM_ID

ITEM_REVISION

ITEM_VERSION

ITEM_STRUCTURE_NAME

WORK_DEFINITION_AS_OF_DATE

WORK_DEFINITION_ID

WORK_DEFINITION_VERSION_ID

WORK_ORDER_PRIORITY

WORK_ORDER_STATUS_ID

SCHEDULING_METHOD

PLANNED_START_QUANTITY

NETTABLE_SUPPLY_QTY_OVERRIDE

UOM_CODE

FIRM_PLANNED_FLAG

PLANNED_START_DATE

PLANNED_COMPLETION_DATE

ACTUAL_START_DATE

ACTUAL_COMPLETION_DATE

RELEASED_DATE

CLOSED_DATE

CANCELED_DATE

CANCELED_REASON

STATUS_CHANGE_REASON

COMPLETED_QUANTITY

SCRAPPED_QUANTITY

REJECTED_QUANTITY

OVERCOMPL_TOLERANCE_TYPE

OVERCOMPL_TOLERANCE_VALUE

SUPPLY_TYPE

COMPL_SUBINVENTORY_CODE

COMPL_LOCATOR_ID

SERIAL_TRACKING_FLAG

BACK_TO_BACK_FLAG

ORCHESTRATION_CODE

INTERFACE_SOURCE_CODE

SCO_SUPPLY_ORDER_ID

CONTRACT_MFG_FLAG

CM_PO_HEADER_ID

CM_PO_LINE_ID

CM_PO_LINE_LOC_ID

ORDER_LESS_FLAG

SOURCE_SYSTEM_TYPE

SOURCE_SYSTEM_ID

SOURCE_HEADER_REF

SOURCE_HEADER_REF_ID

SOURCE_LINE_REF

SOURCE_LINE_REF_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

ATTRIBUTE_CATEGORY

ATTRIBUTE_CHAR1

ATTRIBUTE_CHAR2

ATTRIBUTE_CHAR3

ATTRIBUTE_CHAR4

ATTRIBUTE_CHAR5

ATTRIBUTE_CHAR6

ATTRIBUTE_CHAR7

ATTRIBUTE_CHAR8

ATTRIBUTE_CHAR9

ATTRIBUTE_CHAR10

ATTRIBUTE_CHAR11

ATTRIBUTE_CHAR12

ATTRIBUTE_CHAR13

ATTRIBUTE_CHAR14

ATTRIBUTE_CHAR15

ATTRIBUTE_CHAR16

ATTRIBUTE_CHAR17

ATTRIBUTE_CHAR18

ATTRIBUTE_CHAR19

ATTRIBUTE_CHAR20

ATTRIBUTE_NUMBER1

ATTRIBUTE_NUMBER2

ATTRIBUTE_NUMBER3

ATTRIBUTE_NUMBER4

ATTRIBUTE_NUMBER5

ATTRIBUTE_NUMBER6

ATTRIBUTE_NUMBER7

ATTRIBUTE_NUMBER8

ATTRIBUTE_NUMBER9

ATTRIBUTE_NUMBER10

ATTRIBUTE_DATE1

ATTRIBUTE_DATE2

ATTRIBUTE_DATE3

ATTRIBUTE_DATE4

ATTRIBUTE_DATE5

ATTRIBUTE_TIMESTAMP1

ATTRIBUTE_TIMESTAMP2

ATTRIBUTE_TIMESTAMP3

ATTRIBUTE_TIMESTAMP4

ATTRIBUTE_TIMESTAMP5

REQUEST_ID

JOB_DEFINITION_NAME

JOB_DEFINITION_PACKAGE

Query

SQL_Statement
SELECT wwo.work_order_id work_order_id, wwo.object_version_number object_version_number, wwo.organization_id organization_id, wwo.work_order_number work_order_number, wwo.work_method_id work_method_id, wwo.work_order_type work_order_type, wwo.work_order_sub_type work_order_sub_type, wwo.inventory_item_id inventory_item_id, wwo.item_revision item_revision, wwo.item_version item_version, wwo.item_structure_name item_structure_name, wwo.work_definition_as_of_date work_definition_as_of_date, wwo.work_definition_id work_definition_id, wwo.work_definition_version_iD work_definition_version_id, wwo.work_order_priority work_order_priority, wwo.work_order_status_id work_order_status_id, wwo.scheduling_method scheduling_method, wwo.planned_start_quantity planned_start_quantity, wwo.nettable_supply_qty_override nettable_supply_qty_override, wwo.uom_code uom_code, wwo.firm_planned_flag firm_planned_flag, wwo.planned_start_date planned_start_date, wwo.planned_completion_date planned_completion_date, wwo.actual_start_date actual_start_date, wwo.actual_completion_date actual_completion_date, wwo.released_date released_date, wwo.closed_date closed_date, wwo.canceled_date canceled_date, wwo.canceled_reason canceled_reason, wwo.status_change_reason status_change_reason, wwo.completed_quantity completed_quantity, wwo.scrapped_quantity scrapped_quantity, wwo.rejected_quantity rejected_quantity, wwo.overcompl_tolerance_type overcompl_tolerance_type, wwo.overcompl_tolerance_value overcompl_tolerance_value, wwo.supply_type supply_type, wwo.compl_subinventory_code compl_subinventory_code, wwo.compl_locator_id compl_locator_id, wwo.serial_tracking_flag serial_tracking_flag, wwo.back_to_back_flag back_to_back_flag, wwo.orchestration_code orchestration_code, wwo.interface_source_code interface_source_code, wwo.sco_supply_order_id sco_supply_order_id, wwo.contract_mfg_flag contract_mfg_flag, wwo.cm_po_header_id cm_po_header_id, wwo.cm_po_line_id cm_po_line_id, wwo.cm_po_line_loc_id cm_po_line_loc_id, wwo.order_less_flag order_less_flag, wwo.source_system_type source_system_type, wwo.source_system_id source_system_id, wwo.source_header_ref source_header_ref, wwo.source_header_ref_id source_header_ref_id, wwo.source_line_ref source_line_ref, wwo.source_line_ref_id source_line_ref_id, wwo.created_by created_by, wwo.creation_date creation_date, wwo.last_updated_by last_updated_by, wwo.last_update_date last_update_date, wwo.last_update_login last_update_login, wwo.attribute_category attribute_category, wwo.attribute_char1 attribute_char1, wwo.attribute_char2 attribute_char2, wwo.attribute_char3 attribute_char3, wwo.attribute_char4 attribute_char4, wwo.attribute_char5 attribute_char5, wwo.attribute_char6 attribute_char6, wwo.attribute_char7 attribute_char7, wwo.attribute_char8 attribute_char8, wwo.attribute_char9 attribute_char9, wwo.attribute_char10 attribute_char10, wwo.attribute_char11 attribute_char11, wwo.attribute_char12 attribute_char12, wwo.attribute_char13 attribute_char13, wwo.attribute_char14 attribute_char14, wwo.attribute_char15 attribute_char15, wwo.attribute_char16 attribute_char16, wwo.attribute_char17 attribute_char17, wwo.attribute_char18 attribute_char18, wwo.attribute_char19 attribute_char19, wwo.attribute_char20 attribute_char20, wwo.attribute_number1 attribute_number1, wwo.attribute_number2 attribute_number2, wwo.attribute_number3 attribute_number3, wwo.attribute_number4 attribute_number4, wwo.attribute_number5 attribute_number5, wwo.attribute_number6 attribute_number6, wwo.attribute_number7 attribute_number7, wwo.attribute_number8 attribute_number8, wwo.attribute_number9 attribute_number9, wwo.attribute_number10 attribute_number10, wwo.attribute_date1 attribute_date1, wwo.attribute_date2 attribute_date2, wwo.attribute_date3 attribute_date3, wwo.attribute_date4 attribute_date4, wwo.attribute_date5 attribute_date5, wwo.attribute_timestamp1 attribute_timestamp1, wwo.attribute_timestamp2 attribute_timestamp2, wwo.attribute_timestamp3 attribute_timestamp3, wwo.attribute_timestamp4 attribute_timestamp4, wwo.attribute_timestamp5 attribute_timestamp5, wwo.request_id request_id, wwo.job_definition_name job_definition_name, wwo.job_definition_package job_definition_package FROM wie_work_orders_vl wwo, wis_work_methods_b wwm WHERE wwo.work_method_id = wwm.work_method_id AND wwm.work_method_code = 'MAINTENANCE'

SQL_Statement

SELECT wwo.work_order_id work_order_id,

wwo.object_version_number object_version_number,

wwo.organization_id organization_id,

wwo.work_order_number work_order_number,

wwo.work_method_id work_method_id,

wwo.work_order_type work_order_type,

wwo.work_order_sub_type work_order_sub_type,

wwo.inventory_item_id inventory_item_id,

wwo.item_revision item_revision,

wwo.item_version item_version,

wwo.item_structure_name item_structure_name,

wwo.work_definition_as_of_date work_definition_as_of_date,

wwo.work_definition_id work_definition_id,

wwo.work_definition_version_iD work_definition_version_id,

wwo.work_order_priority work_order_priority,

wwo.work_order_status_id work_order_status_id,

wwo.scheduling_method scheduling_method,

wwo.planned_start_quantity planned_start_quantity,

wwo.nettable_supply_qty_override nettable_supply_qty_override,

wwo.uom_code uom_code,

wwo.firm_planned_flag firm_planned_flag,

wwo.planned_start_date planned_start_date,

wwo.planned_completion_date planned_completion_date,

wwo.actual_start_date actual_start_date,

wwo.actual_completion_date actual_completion_date,

wwo.released_date released_date,

wwo.closed_date closed_date,

wwo.canceled_date canceled_date,

wwo.canceled_reason canceled_reason,

wwo.status_change_reason status_change_reason,

wwo.completed_quantity completed_quantity,

wwo.scrapped_quantity scrapped_quantity,

wwo.rejected_quantity rejected_quantity,

wwo.overcompl_tolerance_type overcompl_tolerance_type,

wwo.overcompl_tolerance_value overcompl_tolerance_value,

wwo.supply_type supply_type,

wwo.compl_subinventory_code compl_subinventory_code,

wwo.compl_locator_id compl_locator_id,

wwo.serial_tracking_flag serial_tracking_flag,

wwo.back_to_back_flag back_to_back_flag,

wwo.orchestration_code orchestration_code,

wwo.interface_source_code interface_source_code,

wwo.sco_supply_order_id sco_supply_order_id,

wwo.contract_mfg_flag contract_mfg_flag,

wwo.cm_po_header_id cm_po_header_id,

wwo.cm_po_line_id cm_po_line_id,

wwo.cm_po_line_loc_id cm_po_line_loc_id,

wwo.order_less_flag order_less_flag,

wwo.source_system_type source_system_type,

wwo.source_system_id source_system_id,

wwo.source_header_ref source_header_ref,

wwo.source_header_ref_id source_header_ref_id,

wwo.source_line_ref source_line_ref,

wwo.source_line_ref_id source_line_ref_id,

wwo.created_by created_by,

wwo.creation_date creation_date,

wwo.last_updated_by last_updated_by,

wwo.last_update_date last_update_date,

wwo.last_update_login last_update_login,

wwo.attribute_category attribute_category,

wwo.attribute_char1 attribute_char1,

wwo.attribute_char2 attribute_char2,

wwo.attribute_char3 attribute_char3,

wwo.attribute_char4 attribute_char4,

wwo.attribute_char5 attribute_char5,

wwo.attribute_char6 attribute_char6,

wwo.attribute_char7 attribute_char7,

wwo.attribute_char8 attribute_char8,

wwo.attribute_char9 attribute_char9,

wwo.attribute_char10 attribute_char10,

wwo.attribute_char11 attribute_char11,

wwo.attribute_char12 attribute_char12,

wwo.attribute_char13 attribute_char13,

wwo.attribute_char14 attribute_char14,

wwo.attribute_char15 attribute_char15,

wwo.attribute_char16 attribute_char16,

wwo.attribute_char17 attribute_char17,

wwo.attribute_char18 attribute_char18,

wwo.attribute_char19 attribute_char19,

wwo.attribute_char20 attribute_char20,

wwo.attribute_number1 attribute_number1,

wwo.attribute_number2 attribute_number2,

wwo.attribute_number3 attribute_number3,

wwo.attribute_number4 attribute_number4,

wwo.attribute_number5 attribute_number5,

wwo.attribute_number6 attribute_number6,

wwo.attribute_number7 attribute_number7,

wwo.attribute_number8 attribute_number8,

wwo.attribute_number9 attribute_number9,

wwo.attribute_number10 attribute_number10,

wwo.attribute_date1 attribute_date1,

wwo.attribute_date2 attribute_date2,

wwo.attribute_date3 attribute_date3,

wwo.attribute_date4 attribute_date4,

wwo.attribute_date5 attribute_date5,

wwo.attribute_timestamp1 attribute_timestamp1,

wwo.attribute_timestamp2 attribute_timestamp2,

wwo.attribute_timestamp3 attribute_timestamp3,

wwo.attribute_timestamp4 attribute_timestamp4,

wwo.attribute_timestamp5 attribute_timestamp5,

wwo.request_id request_id,

wwo.job_definition_name job_definition_name,

wwo.job_definition_package job_definition_package

FROM wie_work_orders_vl wwo,

wis_work_methods_b wwm

WHERE wwo.work_method_id = wwm.work_method_id

AND wwm.work_method_code = 'MAINTENANCE'