CST_XLA_WO_OP_MATERIALS

Details

Schema: FUSION
Object owner: CST
Object type: VIEW

Columns

Name
WO_OPERATION_MATERIAL_ID WO_OP_MATERIAL_TXN_ID WO_OP_MAT_ATTR_CATEGORY WO_OP_MAT_ATTRIBUTE_CHAR1 WO_OP_MAT_ATTRIBUTE_CHAR2 WO_OP_MAT_ATTRIBUTE_CHAR3 WO_OP_MAT_ATTRIBUTE_CHAR4 WO_OP_MAT_ATTRIBUTE_CHAR5 WO_OP_MAT_ATTRIBUTE_CHAR6 WO_OP_MAT_ATTRIBUTE_CHAR7 WO_OP_MAT_ATTRIBUTE_CHAR8 WO_OP_MAT_ATTRIBUTE_CHAR9 WO_OP_MAT_ATTRIBUTE_CHAR10 WO_OP_MAT_ATTRIBUTE_CHAR11 WO_OP_MAT_ATTRIBUTE_CHAR12 WO_OP_MAT_ATTRIBUTE_CHAR13 WO_OP_MAT_ATTRIBUTE_CHAR14 WO_OP_MAT_ATTRIBUTE_CHAR15 WO_OP_MAT_ATTRIBUTE_CHAR16 WO_OP_MAT_ATTRIBUTE_CHAR17 WO_OP_MAT_ATTRIBUTE_CHAR18 WO_OP_MAT_ATTRIBUTE_CHAR19 WO_OP_MAT_ATTRIBUTE_CHAR20

Name

WO_OPERATION_MATERIAL_ID

WO_OP_MATERIAL_TXN_ID

WO_OP_MAT_ATTR_CATEGORY

WO_OP_MAT_ATTRIBUTE_CHAR1

WO_OP_MAT_ATTRIBUTE_CHAR2

WO_OP_MAT_ATTRIBUTE_CHAR3

WO_OP_MAT_ATTRIBUTE_CHAR4

WO_OP_MAT_ATTRIBUTE_CHAR5

WO_OP_MAT_ATTRIBUTE_CHAR6

WO_OP_MAT_ATTRIBUTE_CHAR7

WO_OP_MAT_ATTRIBUTE_CHAR8

WO_OP_MAT_ATTRIBUTE_CHAR9

WO_OP_MAT_ATTRIBUTE_CHAR10

WO_OP_MAT_ATTRIBUTE_CHAR11

WO_OP_MAT_ATTRIBUTE_CHAR12

WO_OP_MAT_ATTRIBUTE_CHAR13

WO_OP_MAT_ATTRIBUTE_CHAR14

WO_OP_MAT_ATTRIBUTE_CHAR15

WO_OP_MAT_ATTRIBUTE_CHAR16

WO_OP_MAT_ATTRIBUTE_CHAR17

WO_OP_MAT_ATTRIBUTE_CHAR18

WO_OP_MAT_ATTRIBUTE_CHAR19

WO_OP_MAT_ATTRIBUTE_CHAR20

Query

SQL_Statement
SELECT WOM.WO_OPERATION_MATERIAL_ID WO_OPERATION_MATERIAL_ID, IMT.TRANSACTION_ID WO_OP_MATERIAL_TXN_ID, WOM.ATTRIBUTE_CATEGORY WO_OP_MAT_ATTR_CATEGORY, WOM.ATTRIBUTE_CHAR1 WO_OP_MAT_ATTRIBUTE_CHAR1, WOM.ATTRIBUTE_CHAR2 WO_OP_MAT_ATTRIBUTE_CHAR2, WOM.ATTRIBUTE_CHAR3 WO_OP_MAT_ATTRIBUTE_CHAR3, WOM.ATTRIBUTE_CHAR4 WO_OP_MAT_ATTRIBUTE_CHAR4, WOM.ATTRIBUTE_CHAR5 WO_OP_MAT_ATTRIBUTE_CHAR5, WOM.ATTRIBUTE_CHAR6 WO_OP_MAT_ATTRIBUTE_CHAR6, WOM.ATTRIBUTE_CHAR7 WO_OP_MAT_ATTRIBUTE_CHAR7, WOM.ATTRIBUTE_CHAR8 WO_OP_MAT_ATTRIBUTE_CHAR8, WOM.ATTRIBUTE_CHAR9 WO_OP_MAT_ATTRIBUTE_CHAR9, WOM.ATTRIBUTE_CHAR10 WO_OP_MAT_ATTRIBUTE_CHAR10, WOM.ATTRIBUTE_CHAR11 WO_OP_MAT_ATTRIBUTE_CHAR11, WOM.ATTRIBUTE_CHAR12 WO_OP_MAT_ATTRIBUTE_CHAR12, WOM.ATTRIBUTE_CHAR13 WO_OP_MAT_ATTRIBUTE_CHAR13, WOM.ATTRIBUTE_CHAR14 WO_OP_MAT_ATTRIBUTE_CHAR14, WOM.ATTRIBUTE_CHAR15 WO_OP_MAT_ATTRIBUTE_CHAR15, WOM.ATTRIBUTE_CHAR16 WO_OP_MAT_ATTRIBUTE_CHAR16, WOM.ATTRIBUTE_CHAR17 WO_OP_MAT_ATTRIBUTE_CHAR17, WOM.ATTRIBUTE_CHAR18 WO_OP_MAT_ATTRIBUTE_CHAR18, WOM.ATTRIBUTE_CHAR19 WO_OP_MAT_ATTRIBUTE_CHAR19, WOM.ATTRIBUTE_CHAR20 WO_OP_MAT_ATTRIBUTE_CHAR20 FROM INV_MATERIAL_TXNS IMT, WIE_WORK_ORDERS_B WO, WIE_WO_OPERATION_MATERIALS_V WOM WHERE IMT.INVENTORY_ITEM_ID = WOM.INVENTORY_ITEM_ID AND IMT.ORGANIZATION_ID = WOM.ORGANIZATION_ID AND IMT.TRANSACTION_SOURCE_TYPE_ID = 5 AND IMT.TRANSACTION_SOURCE_NAME = WO.WORK_ORDER_NUMBER AND WO.WORK_ORDER_ID = WOM.WORK_ORDER_ID

SQL_Statement

SELECT

WOM.WO_OPERATION_MATERIAL_ID WO_OPERATION_MATERIAL_ID,

IMT.TRANSACTION_ID WO_OP_MATERIAL_TXN_ID,

WOM.ATTRIBUTE_CATEGORY WO_OP_MAT_ATTR_CATEGORY,

WOM.ATTRIBUTE_CHAR1 WO_OP_MAT_ATTRIBUTE_CHAR1,

WOM.ATTRIBUTE_CHAR2 WO_OP_MAT_ATTRIBUTE_CHAR2,

WOM.ATTRIBUTE_CHAR3 WO_OP_MAT_ATTRIBUTE_CHAR3,

WOM.ATTRIBUTE_CHAR4 WO_OP_MAT_ATTRIBUTE_CHAR4,

WOM.ATTRIBUTE_CHAR5 WO_OP_MAT_ATTRIBUTE_CHAR5,

WOM.ATTRIBUTE_CHAR6 WO_OP_MAT_ATTRIBUTE_CHAR6,

WOM.ATTRIBUTE_CHAR7 WO_OP_MAT_ATTRIBUTE_CHAR7,

WOM.ATTRIBUTE_CHAR8 WO_OP_MAT_ATTRIBUTE_CHAR8,

WOM.ATTRIBUTE_CHAR9 WO_OP_MAT_ATTRIBUTE_CHAR9,

WOM.ATTRIBUTE_CHAR10 WO_OP_MAT_ATTRIBUTE_CHAR10,

WOM.ATTRIBUTE_CHAR11 WO_OP_MAT_ATTRIBUTE_CHAR11,

WOM.ATTRIBUTE_CHAR12 WO_OP_MAT_ATTRIBUTE_CHAR12,

WOM.ATTRIBUTE_CHAR13 WO_OP_MAT_ATTRIBUTE_CHAR13,

WOM.ATTRIBUTE_CHAR14 WO_OP_MAT_ATTRIBUTE_CHAR14,

WOM.ATTRIBUTE_CHAR15 WO_OP_MAT_ATTRIBUTE_CHAR15,

WOM.ATTRIBUTE_CHAR16 WO_OP_MAT_ATTRIBUTE_CHAR16,

WOM.ATTRIBUTE_CHAR17 WO_OP_MAT_ATTRIBUTE_CHAR17,

WOM.ATTRIBUTE_CHAR18 WO_OP_MAT_ATTRIBUTE_CHAR18,

WOM.ATTRIBUTE_CHAR19 WO_OP_MAT_ATTRIBUTE_CHAR19,

WOM.ATTRIBUTE_CHAR20 WO_OP_MAT_ATTRIBUTE_CHAR20

FROM

INV_MATERIAL_TXNS IMT,

WIE_WORK_ORDERS_B WO,

WIE_WO_OPERATION_MATERIALS_V WOM

WHERE IMT.INVENTORY_ITEM_ID = WOM.INVENTORY_ITEM_ID

AND IMT.ORGANIZATION_ID = WOM.ORGANIZATION_ID

AND IMT.TRANSACTION_SOURCE_TYPE_ID = 5

AND IMT.TRANSACTION_SOURCE_NAME = WO.WORK_ORDER_NUMBER

AND WO.WORK_ORDER_ID = WOM.WORK_ORDER_ID