CST_XLA_WO_OP_MATERIALS_V

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

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_wo_operation_materials_v wom WHERE imt.transaction_source_type_id = 5 AND imt.transaction_source_id = wom.work_order_id AND imt.operation_seq_number_id = wom.wo_operation_id AND imt.inventory_item_id = wom.inventory_item_id AND imt.organization_id = wom.organization_id AND ( imt.material_seq_number IS NULL OR imt.material_seq_number = wom.material_seq_number )