WIE_WO_OPERATION_MATERIALS

Details

Schema: FUSION
Object owner: WIE
Object type: VIEW

Columns

Name
ROW_ID WO_OPERATION_MATERIAL_ID OBJECT_VERSION_NUMBER ORGANIZATION_ID WO_OPERATION_ID WORK_ORDER_ID MATERIAL_SEQ_NUMBER MATERIAL_TYPE INVENTORY_ITEM_ID ITEM_REVISION QUANTITY_PER_PRODUCT BASIS_TYPE QUANTITY INVERSE_QUANTITY UOM_CODE REQUIRED_DATE YIELD_FACTOR INCLUDE_IN_PLANNING_FLAG SUPPLY_TYPE SUPPLY_SUBINVENTORY SUPPLY_LOCATOR_ID ISSUED_QUANTITY PRODUCED_QUANTITY PICKED_QUANTITY ALLOCATED_QUANTITY REMAINING_ALLOCATED_QUANTITY TIA_REF_LINE_ID TIA_REF_ENTITY WD_OPERATION_MATERIAL_ID REPAIR_TXN_CODE_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

ROW_ID

WO_OPERATION_MATERIAL_ID

OBJECT_VERSION_NUMBER

ORGANIZATION_ID

WO_OPERATION_ID

WORK_ORDER_ID

MATERIAL_SEQ_NUMBER

MATERIAL_TYPE

INVENTORY_ITEM_ID

ITEM_REVISION

QUANTITY_PER_PRODUCT

BASIS_TYPE

QUANTITY

INVERSE_QUANTITY

UOM_CODE

REQUIRED_DATE

YIELD_FACTOR

INCLUDE_IN_PLANNING_FLAG

SUPPLY_TYPE

SUPPLY_SUBINVENTORY

SUPPLY_LOCATOR_ID

ISSUED_QUANTITY

PRODUCED_QUANTITY

PICKED_QUANTITY

ALLOCATED_QUANTITY

REMAINING_ALLOCATED_QUANTITY

TIA_REF_LINE_ID

TIA_REF_ENTITY

WD_OPERATION_MATERIAL_ID

REPAIR_TXN_CODE_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 WOM.ROWID ROW_ID, WOM.WO_OPERATION_MATERIAL_ID WO_OPERATION_MATERIAL_ID, WOM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, WOM.ORGANIZATION_ID ORGANIZATION_ID, WOM.WO_OPERATION_ID WO_OPERATION_ID, WOM.WORK_ORDER_ID WORK_ORDER_ID, WOM.MATERIAL_SEQ_NUMBER MATERIAL_SEQ_NUMBER, WOM.MATERIAL_TYPE MATERIAL_TYPE, WOM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID, WOM.ITEM_REVISION ITEM_REVISION, WOM.QUANTITY_PER_PRODUCT QUANTITY_PER_PRODUCT, WOM.BASIS_TYPE BASIS_TYPE, WOM.QUANTITY QUANTITY, WOM.INVERSE_QUANTITY INVERSE_QUANTITY, WOM.UOM_CODE UOM_CODE, WOM.REQUIRED_DATE REQUIRED_DATE, WOM.YIELD_FACTOR YIELD_FACTOR, WOM.INCLUDE_IN_PLANNING_FLAG INCLUDE_IN_PLANNING_FLAG, WOM.SUPPLY_TYPE SUPPLY_TYPE, WOM.SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY, WOM.SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID, WOM.ISSUED_QUANTITY ISSUED_QUANTITY, WOM.PRODUCED_QUANTITY PRODUCED_QUANTITY, WOM.PICKED_QUANTITY PICKED_QUANTITY, WOM.ALLOCATED_QUANTITY ALLOCATED_QUANTITY, WOM.REMAINING_ALLOCATED_QUANTITY REMAINING_ALLOCATED_QUANTITY, WOM.TIA_REF_LINE_ID TIA_REF_LINE_ID, WOM.TIA_REF_ENTITY TIA_REF_ENTITY, WOM.WD_OPERATION_MATERIAL_ID WD_OPERATION_MATERIAL_ID, WOM.REPAIR_TXN_CODE_ID REPAIR_TXN_CODE_ID, WOM.CREATED_BY CREATED_BY, WOM.CREATION_DATE CREATION_DATE, WOM.LAST_UPDATED_BY LAST_UPDATED_BY, WOM.LAST_UPDATE_DATE LAST_UPDATE_DATE, WOM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, WOM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, WOM.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1, WOM.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2, WOM.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3, WOM.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4, WOM.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5, WOM.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6, WOM.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7, WOM.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8, WOM.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9, WOM.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10, WOM.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11, WOM.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12, WOM.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13, WOM.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14, WOM.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15, WOM.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16, WOM.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17, WOM.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18, WOM.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19, WOM.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20, WOM.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1, WOM.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2, WOM.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3, WOM.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4, WOM.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5, WOM.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6, WOM.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7, WOM.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8, WOM.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9, WOM.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10, WOM.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1, WOM.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2, WOM.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3, WOM.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4, WOM.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5, WOM.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1, WOM.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2, WOM.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3, WOM.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4, WOM.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5, WOM.REQUEST_ID REQUEST_ID, WOM.JOB_DEFINITION_NAME JOB_DEFINITION_NAME, WOM.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE FROM WIE_WO_OPERATION_MATERIALS WOM

SQL_Statement

SELECT

WOM.ROWID ROW_ID,

WOM.WO_OPERATION_MATERIAL_ID WO_OPERATION_MATERIAL_ID,

WOM.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER,

WOM.ORGANIZATION_ID ORGANIZATION_ID,

WOM.WO_OPERATION_ID WO_OPERATION_ID,

WOM.WORK_ORDER_ID WORK_ORDER_ID,

WOM.MATERIAL_SEQ_NUMBER MATERIAL_SEQ_NUMBER,

WOM.MATERIAL_TYPE MATERIAL_TYPE,

WOM.INVENTORY_ITEM_ID INVENTORY_ITEM_ID,

WOM.ITEM_REVISION ITEM_REVISION,

WOM.QUANTITY_PER_PRODUCT QUANTITY_PER_PRODUCT,

WOM.BASIS_TYPE BASIS_TYPE,

WOM.QUANTITY QUANTITY,

WOM.INVERSE_QUANTITY INVERSE_QUANTITY,

WOM.UOM_CODE UOM_CODE,

WOM.REQUIRED_DATE REQUIRED_DATE,

WOM.YIELD_FACTOR YIELD_FACTOR,

WOM.INCLUDE_IN_PLANNING_FLAG INCLUDE_IN_PLANNING_FLAG,

WOM.SUPPLY_TYPE SUPPLY_TYPE,

WOM.SUPPLY_SUBINVENTORY SUPPLY_SUBINVENTORY,

WOM.SUPPLY_LOCATOR_ID SUPPLY_LOCATOR_ID,

WOM.ISSUED_QUANTITY ISSUED_QUANTITY,

WOM.PRODUCED_QUANTITY PRODUCED_QUANTITY,

WOM.PICKED_QUANTITY PICKED_QUANTITY,

WOM.ALLOCATED_QUANTITY ALLOCATED_QUANTITY,

WOM.REMAINING_ALLOCATED_QUANTITY REMAINING_ALLOCATED_QUANTITY,

WOM.TIA_REF_LINE_ID TIA_REF_LINE_ID,

WOM.TIA_REF_ENTITY TIA_REF_ENTITY,

WOM.WD_OPERATION_MATERIAL_ID WD_OPERATION_MATERIAL_ID,

WOM.REPAIR_TXN_CODE_ID REPAIR_TXN_CODE_ID,

WOM.CREATED_BY CREATED_BY,

WOM.CREATION_DATE CREATION_DATE,

WOM.LAST_UPDATED_BY LAST_UPDATED_BY,

WOM.LAST_UPDATE_DATE LAST_UPDATE_DATE,

WOM.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN,

WOM.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY,

WOM.ATTRIBUTE_CHAR1 ATTRIBUTE_CHAR1,

WOM.ATTRIBUTE_CHAR2 ATTRIBUTE_CHAR2,

WOM.ATTRIBUTE_CHAR3 ATTRIBUTE_CHAR3,

WOM.ATTRIBUTE_CHAR4 ATTRIBUTE_CHAR4,

WOM.ATTRIBUTE_CHAR5 ATTRIBUTE_CHAR5,

WOM.ATTRIBUTE_CHAR6 ATTRIBUTE_CHAR6,

WOM.ATTRIBUTE_CHAR7 ATTRIBUTE_CHAR7,

WOM.ATTRIBUTE_CHAR8 ATTRIBUTE_CHAR8,

WOM.ATTRIBUTE_CHAR9 ATTRIBUTE_CHAR9,

WOM.ATTRIBUTE_CHAR10 ATTRIBUTE_CHAR10,

WOM.ATTRIBUTE_CHAR11 ATTRIBUTE_CHAR11,

WOM.ATTRIBUTE_CHAR12 ATTRIBUTE_CHAR12,

WOM.ATTRIBUTE_CHAR13 ATTRIBUTE_CHAR13,

WOM.ATTRIBUTE_CHAR14 ATTRIBUTE_CHAR14,

WOM.ATTRIBUTE_CHAR15 ATTRIBUTE_CHAR15,

WOM.ATTRIBUTE_CHAR16 ATTRIBUTE_CHAR16,

WOM.ATTRIBUTE_CHAR17 ATTRIBUTE_CHAR17,

WOM.ATTRIBUTE_CHAR18 ATTRIBUTE_CHAR18,

WOM.ATTRIBUTE_CHAR19 ATTRIBUTE_CHAR19,

WOM.ATTRIBUTE_CHAR20 ATTRIBUTE_CHAR20,

WOM.ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER1,

WOM.ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER2,

WOM.ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER3,

WOM.ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER4,

WOM.ATTRIBUTE_NUMBER5 ATTRIBUTE_NUMBER5,

WOM.ATTRIBUTE_NUMBER6 ATTRIBUTE_NUMBER6,

WOM.ATTRIBUTE_NUMBER7 ATTRIBUTE_NUMBER7,

WOM.ATTRIBUTE_NUMBER8 ATTRIBUTE_NUMBER8,

WOM.ATTRIBUTE_NUMBER9 ATTRIBUTE_NUMBER9,

WOM.ATTRIBUTE_NUMBER10 ATTRIBUTE_NUMBER10,

WOM.ATTRIBUTE_DATE1 ATTRIBUTE_DATE1,

WOM.ATTRIBUTE_DATE2 ATTRIBUTE_DATE2,

WOM.ATTRIBUTE_DATE3 ATTRIBUTE_DATE3,

WOM.ATTRIBUTE_DATE4 ATTRIBUTE_DATE4,

WOM.ATTRIBUTE_DATE5 ATTRIBUTE_DATE5,

WOM.ATTRIBUTE_TIMESTAMP1 ATTRIBUTE_TIMESTAMP1,

WOM.ATTRIBUTE_TIMESTAMP2 ATTRIBUTE_TIMESTAMP2,

WOM.ATTRIBUTE_TIMESTAMP3 ATTRIBUTE_TIMESTAMP3,

WOM.ATTRIBUTE_TIMESTAMP4 ATTRIBUTE_TIMESTAMP4,

WOM.ATTRIBUTE_TIMESTAMP5 ATTRIBUTE_TIMESTAMP5,

WOM.REQUEST_ID REQUEST_ID,

WOM.JOB_DEFINITION_NAME JOB_DEFINITION_NAME,

WOM.JOB_DEFINITION_PACKAGE JOB_DEFINITION_PACKAGE

FROM

WIE_WO_OPERATION_MATERIALS WOM