1. Tables and Views for SCM
  2. CST_XLA_WO_OP_RESOURCES_V

CST_XLA_WO_OP_RESOURCES_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

CST_WORK_ORDER_OPERATION_ID

WO_OPERATION_RESOURCE_ID

WO_OPERATION_ID

RESOURCE_ID

WO_OP_RES_ATTRIBUTE_CATEGORY

WO_OP_RES_ATTRIBUTE_CHAR1

WO_OP_RES_ATTRIBUTE_CHAR2

WO_OP_RES_ATTRIBUTE_CHAR3

WO_OP_RES_ATTRIBUTE_CHAR4

WO_OP_RES_ATTRIBUTE_CHAR5

WO_OP_RES_ATTRIBUTE_CHAR6

WO_OP_RES_ATTRIBUTE_CHAR7

WO_OP_RES_ATTRIBUTE_CHAR8

WO_OP_RES_ATTRIBUTE_CHAR9

WO_OP_RES_ATTRIBUTE_CHAR10

WO_OP_RES_ATTRIBUTE_CHAR11

WO_OP_RES_ATTRIBUTE_CHAR12

WO_OP_RES_ATTRIBUTE_CHAR13

WO_OP_RES_ATTRIBUTE_CHAR14

WO_OP_RES_ATTRIBUTE_CHAR15

WO_OP_RES_ATTRIBUTE_CHAR16

WO_OP_RES_ATTRIBUTE_CHAR17

WO_OP_RES_ATTRIBUTE_CHAR18

WO_OP_RES_ATTRIBUTE_CHAR19

WO_OP_RES_ATTRIBUTE_CHAR20

Query

SQL_Statement

SELECT

cwop.cst_work_order_operation_id cst_work_order_operation_id,

wwop.wo_operation_resource_id wo_operation_resource_id,

wwop.wo_operation_id wo_operation_id,

wwop.resource_id resource_id,

wwop.attribute_category wo_op_res_attribute_category,

wwop.attribute_char1 wo_op_res_attribute_char1,

wwop.attribute_char2 wo_op_res_attribute_char2,

wwop.attribute_char3 wo_op_res_attribute_char3,

wwop.attribute_char4 wo_op_res_attribute_char4,

wwop.attribute_char5 wo_op_res_attribute_char5,

wwop.attribute_char6 wo_op_res_attribute_char6,

wwop.attribute_char7 wo_op_res_attribute_char7,

wwop.attribute_char8 wo_op_res_attribute_char8,

wwop.attribute_char9 wo_op_res_attribute_char9,

wwop.attribute_char10 wo_op_res_attribute_char10,

wwop.attribute_char11 wo_op_res_attribute_char11,

wwop.attribute_char12 wo_op_res_attribute_char12,

wwop.attribute_char13 wo_op_res_attribute_char13,

wwop.attribute_char14 wo_op_res_attribute_char14,

wwop.attribute_char15 wo_op_res_attribute_char15,

wwop.attribute_char16 wo_op_res_attribute_char16,

wwop.attribute_char17 wo_op_res_attribute_char17,

wwop.attribute_char18 wo_op_res_attribute_char18,

wwop.attribute_char19 wo_op_res_attribute_char19,

wwop.attribute_char20 wo_op_res_attribute_char20

FROM

wie_wo_operation_resources_v wwop,

cst_work_order_operations cwop,

wie_wo_operations_b wwo,

cst_work_orders cwo

WHERE

wwop.wo_operation_id = cwop.work_order_operation_id

AND cwop.cst_work_order_id = cwo.cst_work_order_id

AND cwo.external_system_ref_id = wwo.work_order_id

AND cwo.external_system_reference = 'FUSION'

AND wwo.wo_operation_id = wwop.wo_operation_id