WIE_WORK_ORDERS_V
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 |
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 |