WIE_WORK_ORDERS

Details

Schema: FUSION
Object owner: WIE
Object type: VIEW

Columns

Name
B_ROW_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WORK_ORDER_ID WORK_ORDER_NUMBER WORK_ORDER_DESCRIPTION WORK_METHOD_ID WORK_ORDER_TYPE WORK_ORDER_SUB_TYPE INVENTORY_ITEM_ID ITEM_REVISION ITEM_VERSION ITEM_STRUCTURE_NAME TRANSFORM_FROM_ITEM_ID 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 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

B_ROW_ID

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

WORK_ORDER_ID

WORK_ORDER_NUMBER

WORK_ORDER_DESCRIPTION

WORK_METHOD_ID

WORK_ORDER_TYPE

WORK_ORDER_SUB_TYPE

INVENTORY_ITEM_ID

ITEM_REVISION

ITEM_VERSION

ITEM_STRUCTURE_NAME

TRANSFORM_FROM_ITEM_ID

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

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 WWOB.ROWID B_ROW_ID, WWOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WWOB.ORGANIZATION_ID ORGANIZATION_ID, WWOB.WORK_ORDER_ID WORK_ORDER_ID, WWOB.WORK_ORDER_NUMBER WORK_ORDER_NUMBER, WWOT.WORK_ORDER_DESCRIPTION WORK_ORDER_DESCRIPTION, WWOB.WORK_METHOD_ID WORK_METHOD_ID, WWOB.WORK_ORDER_TYPE WORK_ORDER_TYPE, WWOB.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE, WWOB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, WWOB.ITEM_REVISION ITEM_REVISION, WWOB.ITEM_VERSION ITEM_VERSION, WWOB.ITEM_STRUCTURE_NAME ITEM_STRUCTURE_NAME, WWOB.TRANSFORM_FROM_ITEM_ID TRANSFORM_FROM_ITEM_ID, WWOB.WORK_DEFINITION_AS_OF_DATE WORK_DEFINITION_AS_OF_DATE, WWOB.WORK_DEFINITION_ID WORK_DEFINITION_ID, WWOB.WORK_DEFINITION_VERSION_ID WORK_DEFINITION_VERSION_ID, WWOB.WORK_ORDER_PRIORITY WORK_ORDER_PRIORITY, WWOB.WORK_ORDER_STATUS_ID WORK_ORDER_STATUS_ID, WWOB.SCHEDULING_METHOD SCHEDULING_METHOD, WWOB.PLANNED_START_QUANTITY PLANNED_START_QUANTITY, WWOB.NETTABLE_SUPPLY_QTY_OVERRIDE NETTABLE_SUPPLY_QTY_OVERRIDE, WWOB.UOM_CODE UOM_CODE, WWOB.PRIMARY_PRODUCT_QUANTITY PRIMARY_PRODUCT_QUANTITY, WWOB.PRIMARY_PRODUCT_UOM_CODE PRIMARY_PRODUCT_UOM_CODE, WWOB.FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG, WWOB.PLANNED_START_DATE PLANNED_START_DATE, WWOB.PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE, WWOB.ACTUAL_START_DATE ACTUAL_START_DATE, WWOB.ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE, WWOB.RELEASED_DATE RELEASED_DATE, WWOB.CLOSED_DATE CLOSED_DATE, WWOB.CANCELED_DATE CANCELED_DATE, WWOB.CANCELED_REASON CANCELED_REASON, WWOB.NEED_BY_DATE NEED_BY_DATE, WWOB.STATUS_CHANGE_REASON STATUS_CHANGE_REASON, WWOB.COMPLETED_QUANTITY COMPLETED_QUANTITY, WWOB.SCRAPPED_QUANTITY SCRAPPED_QUANTITY, WWOB.REJECTED_QUANTITY REJECTED_QUANTITY, WWOB.OVERCOMPL_TOLERANCE_TYPE OVERCOMPL_TOLERANCE_TYPE, WWOB.OVERCOMPL_TOLERANCE_VALUE OVERCOMPL_TOLERANCE_VALUE, WWOB.UNDERCOMPL_TOLERANCE_TYPE UNDERCOMPL_TOLERANCE_TYPE, WWOB.UNDERCOMPL_TOLERANCE_VALUE UNDERCOMPL_TOLERANCE_VALUE, WWOB.UNDER_COMPLETED_FLAG UNDER_COMPLETED_FLAG, WWOB.COMPL_SUBINVENTORY_CODE COMPL_SUBINVENTORY_CODE, WWOB.COMPL_LOCATOR_ID COMPL_LOCATOR_ID, WWOB.SUPPLY_TYPE SUPPLY_TYPE, WWOB.SERIAL_TRACKING_FLAG SERIAL_TRACKING_FLAG, WWOB.BACK_TO_BACK_FLAG BACK_TO_BACK_FLAG, WWOB.ORCHESTRATION_CODE ORCHESTRATION_CODE, WWOB.INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE, WWOB.SCO_SUPPLY_ORDER_ID SCO_SUPPLY_ORDER_ID, WWOB.CONTRACT_MFG_FLAG CONTRACT_MFG_FLAG, WWOB.CM_PO_HEADER_ID CM_PO_HEADER_ID, WWOB.CM_PO_LINE_ID CM_PO_LINE_ID, WWOB.CM_PO_LINE_LOC_ID CM_PO_LINE_LOC_ID, WWOB.SOURCE_SYSTEM_TYPE SOURCE_SYSTEM_TYPE, WWOB.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID, WWOB.SOURCE_HEADER_REF SOURCE_HEADER_REF, WWOB.SOURCE_HEADER_REF_ID SOURCE_HEADER_REF_ID, WWOB.SOURCE_LINE_REF SOURCE_LINE_REF, WWOB.SOURCE_LINE_REF_ID SOURCE_LINE_REF_ID, WWOB.ORDER_LESS_FLAG ORDER_LESS_FLAG, WWOB.MNT_FORECAST_ID MNT_FORECAST_ID, WWOB.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY, WWOB.PJC_PROJECT_ID PJC_PROJECT_ID, WWOB.PJC_PROJECT_NUMBER PJC_PROJECT_NUMBER, WWOB.PJC_TASK_ID PJC_TASK_ID, WWOB.PJC_TASK_NUMBER PJC_TASK_NUMBER, WWOB.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID, WWOB.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE, WWOB.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID, WWOB.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG, WWOB.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG, WWOB.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID, WWOB.PJC_CONTRACT_ID PJC_CONTRACT_ID, WWOB.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID, WWOB.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID, WWOB.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1, WWOB.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2, WWOB.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3, WWOB.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4, WWOB.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5, WWOB.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6, WWOB.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7, WWOB.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8, WWOB.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9, WWOB.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10, WWOB.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1, WWOB.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2, WWOB.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3, WWOB.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4, WWOB.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5, WWOB.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6, WWOB.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7, WWOB.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8, WWOB.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9, WWOB.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10, WWOB.IOT_SYNC_STATUS IOT_SYNC_STATUS, WWOB.PREASSIGN_LOT_FLAG PREASSIGN_LOT_FLAG, WWOB.RESEQUENCE_FLAG RESEQUENCE_FLAG, WWOB.MNT_COMPLETE_TO_INV_FLAG MNT_COMPLETE_TO_INV_FLAG, WWOB.MNT_INCLUDE_IN_PLANNING_FLAG MNT_INCLUDE_IN_PLANNING_FLAG, WWOB.MNT_OUT_OF_SEQUENCE_FLAG MNT_OUT_OF_SEQUENCE_FLAG, WWOB.MNT_TRANSFORM_TO_ITEM_ID MNT_TRANSFORM_TO_ITEM_ID, WWOB.MNT_ALLOW_MULTIPLE_ASSETS_FLAG MNT_ALLOW_MULTIPLE_ASSETS_FLAG, WWOB.MNT_MATCH_TO_RES_FLAG MNT_MATCH_TO_RES_FLAG, WWOB.MNT_MATCH_TO_RES_INST_FLAG MNT_MATCH_TO_RES_INST_FLAG, WWOB.CREATED_BY CREATED_BY, WWOB.CREATION_DATE CREATION_DATE, WWOB.LAST_UPDATED_BY LAST_UPDATED_BY, WWOB.LAST_UPDATE_DATE LAST_UPDATE_DATE, WWOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WWOB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WWOB.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WWOB.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WWOB.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WWOB.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WWOB.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WWOB.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WWOB.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WWOB.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WWOB.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WWOB.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WWOB.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WWOB.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WWOB.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WWOB.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WWOB.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WWOB.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WWOB.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WWOB.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WWOB.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WWOB.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WWOB.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WWOB.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WWOB.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WWOB.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WWOB.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WWOB.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WWOB.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WWOB.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WWOB.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WWOB.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WWOB.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WWOB.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WWOB.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WWOB.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WWOB.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WWOB.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WWOB.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WWOB.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WWOB.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WWOB.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, WWOB.REQUEST_ID REQUEST_ID, WWOB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, WWOB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM WIE_WORK_ORDERS_B WWOB, WIE_WORK_ORDERS_TL WWOT WHERE WWOT.WORK_ORDER_ID = WWOB.WORK_ORDER_ID AND WWOT.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

WWOB.ROWID B_ROW_ID,

WWOB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WWOB.ORGANIZATION_ID ORGANIZATION_ID,

WWOB.WORK_ORDER_ID WORK_ORDER_ID,

WWOB.WORK_ORDER_NUMBER WORK_ORDER_NUMBER,

WWOT.WORK_ORDER_DESCRIPTION WORK_ORDER_DESCRIPTION,

WWOB.WORK_METHOD_ID WORK_METHOD_ID,

WWOB.WORK_ORDER_TYPE WORK_ORDER_TYPE,

WWOB.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE,

WWOB.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

WWOB.ITEM_REVISION ITEM_REVISION,

WWOB.ITEM_VERSION ITEM_VERSION,

WWOB.ITEM_STRUCTURE_NAME ITEM_STRUCTURE_NAME,

WWOB.TRANSFORM_FROM_ITEM_ID TRANSFORM_FROM_ITEM_ID,

WWOB.WORK_DEFINITION_AS_OF_DATE WORK_DEFINITION_AS_OF_DATE,

WWOB.WORK_DEFINITION_ID WORK_DEFINITION_ID,

WWOB.WORK_DEFINITION_VERSION_ID WORK_DEFINITION_VERSION_ID,

WWOB.WORK_ORDER_PRIORITY WORK_ORDER_PRIORITY,

WWOB.WORK_ORDER_STATUS_ID WORK_ORDER_STATUS_ID,

WWOB.SCHEDULING_METHOD SCHEDULING_METHOD,

WWOB.PLANNED_START_QUANTITY PLANNED_START_QUANTITY,

WWOB.NETTABLE_SUPPLY_QTY_OVERRIDE NETTABLE_SUPPLY_QTY_OVERRIDE,

WWOB.UOM_CODE UOM_CODE,

WWOB.PRIMARY_PRODUCT_QUANTITY PRIMARY_PRODUCT_QUANTITY,

WWOB.PRIMARY_PRODUCT_UOM_CODE PRIMARY_PRODUCT_UOM_CODE,

WWOB.FIRM_PLANNED_FLAG FIRM_PLANNED_FLAG,

WWOB.PLANNED_START_DATE PLANNED_START_DATE,

WWOB.PLANNED_COMPLETION_DATE PLANNED_COMPLETION_DATE,

WWOB.ACTUAL_START_DATE ACTUAL_START_DATE,

WWOB.ACTUAL_COMPLETION_DATE ACTUAL_COMPLETION_DATE,

WWOB.RELEASED_DATE RELEASED_DATE,

WWOB.CLOSED_DATE CLOSED_DATE,

WWOB.CANCELED_DATE CANCELED_DATE,

WWOB.CANCELED_REASON CANCELED_REASON,

WWOB.NEED_BY_DATE NEED_BY_DATE,

WWOB.STATUS_CHANGE_REASON STATUS_CHANGE_REASON,

WWOB.COMPLETED_QUANTITY COMPLETED_QUANTITY,

WWOB.SCRAPPED_QUANTITY SCRAPPED_QUANTITY,

WWOB.REJECTED_QUANTITY REJECTED_QUANTITY,

WWOB.OVERCOMPL_TOLERANCE_TYPE OVERCOMPL_TOLERANCE_TYPE,

WWOB.OVERCOMPL_TOLERANCE_VALUE OVERCOMPL_TOLERANCE_VALUE,

WWOB.UNDERCOMPL_TOLERANCE_TYPE UNDERCOMPL_TOLERANCE_TYPE,

WWOB.UNDERCOMPL_TOLERANCE_VALUE UNDERCOMPL_TOLERANCE_VALUE,

WWOB.UNDER_COMPLETED_FLAG UNDER_COMPLETED_FLAG,

WWOB.COMPL_SUBINVENTORY_CODE COMPL_SUBINVENTORY_CODE,

WWOB.COMPL_LOCATOR_ID COMPL_LOCATOR_ID,

WWOB.SUPPLY_TYPE SUPPLY_TYPE,

WWOB.SERIAL_TRACKING_FLAG SERIAL_TRACKING_FLAG,

WWOB.BACK_TO_BACK_FLAG BACK_TO_BACK_FLAG,

WWOB.ORCHESTRATION_CODE ORCHESTRATION_CODE,

WWOB.INTERFACE_SOURCE_CODE INTERFACE_SOURCE_CODE,

WWOB.SCO_SUPPLY_ORDER_ID SCO_SUPPLY_ORDER_ID,

WWOB.CONTRACT_MFG_FLAG CONTRACT_MFG_FLAG,

WWOB.CM_PO_HEADER_ID CM_PO_HEADER_ID,

WWOB.CM_PO_LINE_ID CM_PO_LINE_ID,

WWOB.CM_PO_LINE_LOC_ID CM_PO_LINE_LOC_ID,

WWOB.SOURCE_SYSTEM_TYPE SOURCE_SYSTEM_TYPE,

WWOB.SOURCE_SYSTEM_ID SOURCE_SYSTEM_ID,

WWOB.SOURCE_HEADER_REF SOURCE_HEADER_REF,

WWOB.SOURCE_HEADER_REF_ID SOURCE_HEADER_REF_ID,

WWOB.SOURCE_LINE_REF SOURCE_LINE_REF,

WWOB.SOURCE_LINE_REF_ID SOURCE_LINE_REF_ID,

WWOB.ORDER_LESS_FLAG ORDER_LESS_FLAG,

WWOB.MNT_FORECAST_ID MNT_FORECAST_ID,

WWOB.PJC_CONTEXT_CATEGORY PJC_CONTEXT_CATEGORY,

WWOB.PJC_PROJECT_ID PJC_PROJECT_ID,

WWOB.PJC_PROJECT_NUMBER PJC_PROJECT_NUMBER,

WWOB.PJC_TASK_ID PJC_TASK_ID,

WWOB.PJC_TASK_NUMBER PJC_TASK_NUMBER,

WWOB.PJC_EXPENDITURE_TYPE_ID PJC_EXPENDITURE_TYPE_ID,

WWOB.PJC_EXPENDITURE_ITEM_DATE PJC_EXPENDITURE_ITEM_DATE,

WWOB.PJC_ORGANIZATION_ID PJC_ORGANIZATION_ID,

WWOB.PJC_BILLABLE_FLAG PJC_BILLABLE_FLAG,

WWOB.PJC_CAPITALIZABLE_FLAG PJC_CAPITALIZABLE_FLAG,

WWOB.PJC_WORK_TYPE_ID PJC_WORK_TYPE_ID,

WWOB.PJC_CONTRACT_ID PJC_CONTRACT_ID,

WWOB.PJC_CONTRACT_LINE_ID PJC_CONTRACT_LINE_ID,

WWOB.PJC_FUNDING_ALLOCATION_ID PJC_FUNDING_ALLOCATION_ID,

WWOB.PJC_RESERVED_ATTRIBUTE1 PJC_RESERVED_ATTRIBUTE1,

WWOB.PJC_RESERVED_ATTRIBUTE2 PJC_RESERVED_ATTRIBUTE2,

WWOB.PJC_RESERVED_ATTRIBUTE3 PJC_RESERVED_ATTRIBUTE3,

WWOB.PJC_RESERVED_ATTRIBUTE4 PJC_RESERVED_ATTRIBUTE4,

WWOB.PJC_RESERVED_ATTRIBUTE5 PJC_RESERVED_ATTRIBUTE5,

WWOB.PJC_RESERVED_ATTRIBUTE6 PJC_RESERVED_ATTRIBUTE6,

WWOB.PJC_RESERVED_ATTRIBUTE7 PJC_RESERVED_ATTRIBUTE7,

WWOB.PJC_RESERVED_ATTRIBUTE8 PJC_RESERVED_ATTRIBUTE8,

WWOB.PJC_RESERVED_ATTRIBUTE9 PJC_RESERVED_ATTRIBUTE9,

WWOB.PJC_RESERVED_ATTRIBUTE10 PJC_RESERVED_ATTRIBUTE10,

WWOB.PJC_USER_DEF_ATTRIBUTE1 PJC_USER_DEF_ATTRIBUTE1,

WWOB.PJC_USER_DEF_ATTRIBUTE2 PJC_USER_DEF_ATTRIBUTE2,

WWOB.PJC_USER_DEF_ATTRIBUTE3 PJC_USER_DEF_ATTRIBUTE3,

WWOB.PJC_USER_DEF_ATTRIBUTE4 PJC_USER_DEF_ATTRIBUTE4,

WWOB.PJC_USER_DEF_ATTRIBUTE5 PJC_USER_DEF_ATTRIBUTE5,

WWOB.PJC_USER_DEF_ATTRIBUTE6 PJC_USER_DEF_ATTRIBUTE6,

WWOB.PJC_USER_DEF_ATTRIBUTE7 PJC_USER_DEF_ATTRIBUTE7,

WWOB.PJC_USER_DEF_ATTRIBUTE8 PJC_USER_DEF_ATTRIBUTE8,

WWOB.PJC_USER_DEF_ATTRIBUTE9 PJC_USER_DEF_ATTRIBUTE9,

WWOB.PJC_USER_DEF_ATTRIBUTE10 PJC_USER_DEF_ATTRIBUTE10,

WWOB.IOT_SYNC_STATUS IOT_SYNC_STATUS,

WWOB.PREASSIGN_LOT_FLAG PREASSIGN_LOT_FLAG,

WWOB.RESEQUENCE_FLAG RESEQUENCE_FLAG,

WWOB.MNT_COMPLETE_TO_INV_FLAG MNT_COMPLETE_TO_INV_FLAG,

WWOB.MNT_INCLUDE_IN_PLANNING_FLAG MNT_INCLUDE_IN_PLANNING_FLAG,

WWOB.MNT_OUT_OF_SEQUENCE_FLAG MNT_OUT_OF_SEQUENCE_FLAG,

WWOB.MNT_TRANSFORM_TO_ITEM_ID MNT_TRANSFORM_TO_ITEM_ID,

WWOB.MNT_ALLOW_MULTIPLE_ASSETS_FLAG MNT_ALLOW_MULTIPLE_ASSETS_FLAG,

WWOB.MNT_MATCH_TO_RES_FLAG MNT_MATCH_TO_RES_FLAG,

WWOB.MNT_MATCH_TO_RES_INST_FLAG MNT_MATCH_TO_RES_INST_FLAG,

WWOB.CREATED_BY CREATED_BY,

WWOB.CREATION_DATE CREATION_DATE,

WWOB.LAST_UPDATED_BY LAST_UPDATED_BY,

WWOB.LAST_UPDATE_DATE LAST_UPDATE_DATE,

WWOB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

WWOB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

WWOB.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

WWOB.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

WWOB.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

WWOB.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

WWOB.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

WWOB.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

WWOB.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

WWOB.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

WWOB.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

WWOB.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

WWOB.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

WWOB.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

WWOB.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

WWOB.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

WWOB.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

WWOB.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

WWOB.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

WWOB.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

WWOB.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

WWOB.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

WWOB.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

WWOB.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

WWOB.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

WWOB.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

WWOB.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

WWOB.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

WWOB.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

WWOB.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

WWOB.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

WWOB.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

WWOB.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

WWOB.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

WWOB.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

WWOB.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

WWOB.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

WWOB.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

WWOB.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

WWOB.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

WWOB.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

WWOB.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

WWOB.REQUEST_ID REQUEST_ID,

WWOB.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

WWOB.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE

FROM

WIE_WORK_ORDERS_B WWOB,

WIE_WORK_ORDERS_TL WWOT

WHERE

WWOT.WORK_ORDER_ID = WWOB.WORK_ORDER_ID AND WWOT.LANGUAGE = USERENV('LANG')