WIE_WORK_ORDERS

Details

Schema: FUSION
Object owner: WIE
Object type: VIEW

Columns

Name
ROW_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WORK_ORDER_ID WORK_ORDER_NUMBER WORK_ORDER_DESCRIPTION WORK_METHOD_ID WORK_METHOD_CODE WORK_ORDER_TYPE WORK_ORDER_SUB_TYPE INVENTORY_ITEM_ID ITEM_REVISION TRANSFORM_FROM_ITEM_ID WORK_DEFINITION_AS_OF_DATE WORK_DEFINITION_ID WORK_DEFINITION_VERSION_ID WORK_ORDER_PRIORITY WORK_ORDER_STATUS_ID USER_STATUS_CODE SYSTEM_STATUS_CODE SCHEDULING_METHOD PLANNED_START_QUANTITY NETTABLE_SUPPLY_QTY_OVERRIDE UOM_CODE PRIMARY_PRODUCT_QUANTITY PRIMARY_PRODUCT_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 NEED_BY_DATE STATUS_CHANGE_REASON COMPLETED_QUANTITY SCRAPPED_QUANTITY REJECTED_QUANTITY OVERCOMPL_TOLERANCE_TYPE OVERCOMPL_TOLERANCE_VALUE UNDERCOMPL_TOLERANCE_TYPE UNDERCOMPL_TOLERANCE_VALUE UNDER_COMPLETED_FLAG COMPL_SUBINVENTORY_CODE COMPL_LOCATOR_ID SUPPLY_TYPE 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 SOURCE_SYSTEM_TYPE SOURCE_SYSTEM_ID SOURCE_HEADER_REF SOURCE_HEADER_REF_ID SOURCE_LINE_REF SOURCE_LINE_REF_ID ORDER_LESS_FLAG MNT_FORECAST_ID PJC_CONTEXT_CATEGORY PJC_PROJECT_ID PJC_PROJECT_NUMBER PJC_TASK_ID PJC_TASK_NUMBER PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_ITEM_DATE PJC_ORGANIZATION_ID PJC_BILLABLE_FLAG PJC_CAPITALIZABLE_FLAG PJC_WORK_TYPE_ID PJC_CONTRACT_ID PJC_CONTRACT_LINE_ID PJC_FUNDING_ALLOCATION_ID PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE10 IOT_SYNC_STATUS PREASSIGN_LOT_FLAG RESEQUENCE_FLAG MNT_COMPLETE_TO_INV_FLAG MNT_INCLUDE_IN_PLANNING_FLAG MNT_OUT_OF_SEQUENCE_FLAG MNT_TRANSFORM_TO_ITEM_ID MNT_ALLOW_MULTIPLE_ASSETS_FLAG MNT_MATCH_TO_RES_FLAG MNT_MATCH_TO_RES_INST_FLAG 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

ROW_ID

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

WORK_ORDER_ID

WORK_ORDER_NUMBER

WORK_ORDER_DESCRIPTION

WORK_METHOD_ID

WORK_METHOD_CODE

WORK_ORDER_TYPE

WORK_ORDER_SUB_TYPE

INVENTORY_ITEM_ID

ITEM_REVISION

TRANSFORM_FROM_ITEM_ID

WORK_DEFINITION_AS_OF_DATE

WORK_DEFINITION_ID

WORK_DEFINITION_VERSION_ID

WORK_ORDER_PRIORITY

WORK_ORDER_STATUS_ID

USER_STATUS_CODE

SYSTEM_STATUS_CODE

SCHEDULING_METHOD

PLANNED_START_QUANTITY

NETTABLE_SUPPLY_QTY_OVERRIDE

UOM_CODE

PRIMARY_PRODUCT_QUANTITY

PRIMARY_PRODUCT_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

NEED_BY_DATE

STATUS_CHANGE_REASON

COMPLETED_QUANTITY

SCRAPPED_QUANTITY

REJECTED_QUANTITY

OVERCOMPL_TOLERANCE_TYPE

OVERCOMPL_TOLERANCE_VALUE

UNDERCOMPL_TOLERANCE_TYPE

UNDERCOMPL_TOLERANCE_VALUE

UNDER_COMPLETED_FLAG

COMPL_SUBINVENTORY_CODE

COMPL_LOCATOR_ID

SUPPLY_TYPE

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

SOURCE_SYSTEM_TYPE

SOURCE_SYSTEM_ID

SOURCE_HEADER_REF

SOURCE_HEADER_REF_ID

SOURCE_LINE_REF

SOURCE_LINE_REF_ID

ORDER_LESS_FLAG

MNT_FORECAST_ID

PJC_CONTEXT_CATEGORY

PJC_PROJECT_ID

PJC_PROJECT_NUMBER

PJC_TASK_ID

PJC_TASK_NUMBER

PJC_EXPENDITURE_TYPE_ID

PJC_EXPENDITURE_ITEM_DATE

PJC_ORGANIZATION_ID

PJC_BILLABLE_FLAG

PJC_CAPITALIZABLE_FLAG

PJC_WORK_TYPE_ID

PJC_CONTRACT_ID

PJC_CONTRACT_LINE_ID

PJC_FUNDING_ALLOCATION_ID

PJC_RESERVED_ATTRIBUTE1

PJC_RESERVED_ATTRIBUTE2

PJC_RESERVED_ATTRIBUTE3

PJC_RESERVED_ATTRIBUTE4

PJC_RESERVED_ATTRIBUTE5

PJC_RESERVED_ATTRIBUTE6

PJC_RESERVED_ATTRIBUTE7

PJC_RESERVED_ATTRIBUTE8

PJC_RESERVED_ATTRIBUTE9

PJC_RESERVED_ATTRIBUTE10

PJC_USER_DEF_ATTRIBUTE1

PJC_USER_DEF_ATTRIBUTE2

PJC_USER_DEF_ATTRIBUTE3

PJC_USER_DEF_ATTRIBUTE4

PJC_USER_DEF_ATTRIBUTE5

PJC_USER_DEF_ATTRIBUTE6

PJC_USER_DEF_ATTRIBUTE7

PJC_USER_DEF_ATTRIBUTE8

PJC_USER_DEF_ATTRIBUTE9

PJC_USER_DEF_ATTRIBUTE10

IOT_SYNC_STATUS

PREASSIGN_LOT_FLAG

RESEQUENCE_FLAG

MNT_COMPLETE_TO_INV_FLAG

MNT_INCLUDE_IN_PLANNING_FLAG

MNT_OUT_OF_SEQUENCE_FLAG

MNT_TRANSFORM_TO_ITEM_ID

MNT_ALLOW_MULTIPLE_ASSETS_FLAG

MNT_MATCH_TO_RES_FLAG

MNT_MATCH_TO_RES_INST_FLAG

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.B_ROW_ID ROW_ID, WWO.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WWO.ORGANIZATION_ID ORGANIZATION_ID, WWO.WORK_ORDER_ID WORK_ORDER_ID, WWO.WORK_ORDER_NUMBER WORK_ORDER_NUMBER, WWO.WORK_ORDER_DESCRIPTION WORK_ORDER_DESCRIPTION, WWO.WORK_METHOD_ID WORK_METHOD_ID, WWM.WORK_METHOD_CODE WORK_METHOD_CODE, 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.TRANSFORM_FROM_ITEM_ID TRANSFORM_FROM_ITEM_ID, 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, WWS.WO_STATUS_CODE USER_STATUS_CODE, WWS.WO_SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE, 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.PRIMARY_PRODUCT_QUANTITY PRIMARY_PRODUCT_QUANTITY, WWO.PRIMARY_PRODUCT_UOM_CODE PRIMARY_PRODUCT_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.NEED_BY_DATE NEED_BY_DATE, 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.UNDERCOMPL_TOLERANCE_TYPE UNDERCOMPL_TOLERANCE_TYPE, WWO.UNDERCOMPL_TOLERANCE_VALUE UNDERCOMPL_TOLERANCE_VALUE, WWO.UNDER_COMPLETED_FLAG UNDER_COMPLETED_FLAG, WWO.COMPL_SUBINVENTORY_CODE COMPL_SUBINVENTORY_CODE, WWO.COMPL_LOCATOR_ID COMPL_LOCATOR_ID, WWO.SUPPLY_TYPE SUPPLY_TYPE, 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.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.ORDER_LESS_FLAG ORDER_LESS_FLAG, WWO.MNT_FORECAST_ID MNT_FORECAST_ID, WWO.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, WWO.PJC_PROJECT_ID PJC_PROJECT_ID, WWO.PJC_PROJECT_NUMBER PJC_PROJECT_NUMBER, WWO.PJC_TASK_ID PJC_TASK_ID, WWO.PJC_TASK_NUMBER PJC_TASK_NUMBER, WWO.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, WWO.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE, WWO.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID, WWO.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, WWO.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, WWO.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, WWO.PJC_CONTRACT_ID PJC_CONTRACT_ID, WWO.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID, WWO.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, WWO.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1, WWO.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2, WWO.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3, WWO.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4, WWO.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5, WWO.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6, WWO.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7, WWO.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8, WWO.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9, WWO.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10, WWO.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1, WWO.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2, WWO.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3, WWO.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4, WWO.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5, WWO.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6, WWO.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7, WWO.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8, WWO.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9, WWO.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10, WWO.IOT_SYNC_STATUS IOT_SYNC_STATUS, WWO.PREASSIGN_LOT_FLAG PREASSIGN_LOT_FLAG, WWO.RESEQUENCE_FLAG RESEQUENCE_FLAG, WWO.MNT_COMPLETE_TO_INV_FLAG MNT_COMPLETE_TO_INV_FLAG, WWO.MNT_INCLUDE_IN_PLANNING_FLAG MNT_INCLUDE_IN_PLANNING_FLAG, WWO.MNT_OUT_OF_SEQUENCE_FLAG MNT_OUT_OF_SEQUENCE_FLAG, WWO.MNT_TRANSFORM_TO_ITEM_ID MNT_TRANSFORM_TO_ITEM_ID, WWO.MNT_ALLOW_MULTIPLE_ASSETS_FLAG MNT_ALLOW_MULTIPLE_ASSETS_FLAG, WWO.MNT_MATCH_TO_RES_FLAG MNT_MATCH_TO_RES_FLAG, WWO.MNT_MATCH_TO_RES_INST_FLAG MNT_MATCH_TO_RES_INST_FLAG, 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, WIE_WO_STATUSES_VL WWS, WIS_WORK_METHODS_VL WWM WHERE WWS.WO_STATUS_ID = WWO.WORK_ORDER_STATUS_ID AND WWM.WORK_METHOD_ID = WWO.WORK_METHOD_ID

SQL_Statement

SELECT

WWO.B_ROW_ID ROW_ID,

WWO.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WWO.ORGANIZATION_ID ORGANIZATION_ID,

WWO.WORK_ORDER_ID WORK_ORDER_ID,

WWO.WORK_ORDER_NUMBER WORK_ORDER_NUMBER,

WWO.WORK_ORDER_DESCRIPTION WORK_ORDER_DESCRIPTION,

WWO.WORK_METHOD_ID WORK_METHOD_ID,

WWM.WORK_METHOD_CODE WORK_METHOD_CODE,

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.TRANSFORM_FROM_ITEM_ID TRANSFORM_FROM_ITEM_ID,

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,

WWS.WO_STATUS_CODE USER_STATUS_CODE,

WWS.WO_SYSTEM_STATUS_CODE SYSTEM_STATUS_CODE,

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.PRIMARY_PRODUCT_QUANTITY PRIMARY_PRODUCT_QUANTITY,

WWO.PRIMARY_PRODUCT_UOM_CODE PRIMARY_PRODUCT_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.NEED_BY_DATE NEED_BY_DATE,

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.UNDERCOMPL_TOLERANCE_TYPE UNDERCOMPL_TOLERANCE_TYPE,

WWO.UNDERCOMPL_TOLERANCE_VALUE UNDERCOMPL_TOLERANCE_VALUE,

WWO.UNDER_COMPLETED_FLAG UNDER_COMPLETED_FLAG,

WWO.COMPL_SUBINVENTORY_CODE COMPL_SUBINVENTORY_CODE,

WWO.COMPL_LOCATOR_ID COMPL_LOCATOR_ID,

WWO.SUPPLY_TYPE SUPPLY_TYPE,

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.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.ORDER_LESS_FLAG ORDER_LESS_FLAG,

WWO.MNT_FORECAST_ID MNT_FORECAST_ID,

WWO.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY,

WWO.PJC_PROJECT_ID PJC_PROJECT_ID,

WWO.PJC_PROJECT_NUMBER PJC_PROJECT_NUMBER,

WWO.PJC_TASK_ID PJC_TASK_ID,

WWO.PJC_TASK_NUMBER PJC_TASK_NUMBER,

WWO.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID,

WWO.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE,

WWO.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID,

WWO.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG,

WWO.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG,

WWO.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID,

WWO.PJC_CONTRACT_ID PJC_CONTRACT_ID,

WWO.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID,

WWO.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID,

WWO.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1,

WWO.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2,

WWO.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3,

WWO.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4,

WWO.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5,

WWO.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6,

WWO.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7,

WWO.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8,

WWO.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9,

WWO.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10,

WWO.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1,

WWO.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2,

WWO.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3,

WWO.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4,

WWO.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5,

WWO.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6,

WWO.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7,

WWO.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8,

WWO.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9,

WWO.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10,

WWO.IOT_SYNC_STATUS IOT_SYNC_STATUS,

WWO.PREASSIGN_LOT_FLAG PREASSIGN_LOT_FLAG,

WWO.RESEQUENCE_FLAG RESEQUENCE_FLAG,

WWO.MNT_COMPLETE_TO_INV_FLAG MNT_COMPLETE_TO_INV_FLAG,

WWO.MNT_INCLUDE_IN_PLANNING_FLAG MNT_INCLUDE_IN_PLANNING_FLAG,

WWO.MNT_OUT_OF_SEQUENCE_FLAG MNT_OUT_OF_SEQUENCE_FLAG,

WWO.MNT_TRANSFORM_TO_ITEM_ID MNT_TRANSFORM_TO_ITEM_ID,

WWO.MNT_ALLOW_MULTIPLE_ASSETS_FLAG MNT_ALLOW_MULTIPLE_ASSETS_FLAG,

WWO.MNT_MATCH_TO_RES_FLAG MNT_MATCH_TO_RES_FLAG,

WWO.MNT_MATCH_TO_RES_INST_FLAG MNT_MATCH_TO_RES_INST_FLAG,

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,

WIE_WO_STATUSES_VL WWS,

WIS_WORK_METHODS_VL WWM

WHERE WWS.WO_STATUS_ID = WWO.WORK_ORDER_STATUS_ID

AND WWM.WORK_METHOD_ID = WWO.WORK_METHOD_ID