1. Tables and Views for SCM
  2. CST_XLA_WO_OPERATIONS_V

CST_XLA_WO_OPERATIONS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

CST_WORK_ORDER_OPERATION_ID

WORK_ORDER_OPERATION_ID

OPERATION_SEQUENCE

WORK_CENTER_ID

WORK_CENTER_CODE

WOO_ATTRIBUTE_CATEGORY

WOO_ATTRIBUTE_CHAR1

WOO_ATTRIBUTE_CHAR2

WOO_ATTRIBUTE_CHAR3

WOO_ATTRIBUTE_CHAR4

WOO_ATTRIBUTE_CHAR5

WOO_ATTRIBUTE_CHAR6

WOO_ATTRIBUTE_CHAR7

WOO_ATTRIBUTE_CHAR8

WOO_ATTRIBUTE_CHAR9

WOO_ATTRIBUTE_CHAR10

WOO_ATTRIBUTE_CHAR11

WOO_ATTRIBUTE_CHAR12

WOO_ATTRIBUTE_CHAR13

WOO_ATTRIBUTE_CHAR14

WOO_ATTRIBUTE_CHAR15

WOO_ATTRIBUTE_CHAR16

WOO_ATTRIBUTE_CHAR17

WOO_ATTRIBUTE_CHAR18

WOO_ATTRIBUTE_CHAR19

WOO_ATTRIBUTE_CHAR20

WOO_ATTRIBUTE_NUMBER1

WOO_ATTRIBUTE_NUMBER2

WOO_ATTRIBUTE_NUMBER3

WOO_ATTRIBUTE_NUMBER4

WOO_ATTRIBUTE_NUMBER5

WOO_ATTRIBUTE_NUMBER6

WOO_ATTRIBUTE_NUMBER7

WOO_ATTRIBUTE_NUMBER8

WOO_ATTRIBUTE_NUMBER9

WOO_ATTRIBUTE_NUMBER10

WOO_ATTRIBUTE_DATE1

WOO_ATTRIBUTE_DATE2

WOO_ATTRIBUTE_DATE3

WOO_ATTRIBUTE_DATE4

WOO_ATTRIBUTE_DATE5

WOO_ATTRIBUTE_TIMESTAMP1

WOO_ATTRIBUTE_TIMESTAMP2

WOO_ATTRIBUTE_TIMESTAMP3

WOO_ATTRIBUTE_TIMESTAMP4

WOO_ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT cwoo.cst_work_order_operation_id cst_work_order_operation_id,

cwoo.work_order_operation_id work_order_operation_id,

cwoo.operation_seq_number operation_sequence,

wwc.work_center_id work_center_id,

wwc.work_center_code work_center_code,

wwoo.attribute_category woo_attribute_category,

wwoo.attribute_char1 woo_attribute_char1,

wwoo.attribute_char2 woo_attribute_char2,

wwoo.attribute_char3 woo_attribute_char3,

wwoo.attribute_char4 woo_attribute_char4,

wwoo.attribute_char5 woo_attribute_char5,

wwoo.attribute_char6 woo_attribute_char6,

wwoo.attribute_char7 woo_attribute_char7,

wwoo.attribute_char8 woo_attribute_char8,

wwoo.attribute_char9 woo_attribute_char9,

wwoo.attribute_char10 woo_attribute_char10,

wwoo.attribute_char11 woo_attribute_char11,

wwoo.attribute_char12 woo_attribute_char12,

wwoo.attribute_char13 woo_attribute_char13,

wwoo.attribute_char14 woo_attribute_char14,

wwoo.attribute_char15 woo_attribute_char15,

wwoo.attribute_char16 woo_attribute_char16,

wwoo.attribute_char17 woo_attribute_char17,

wwoo.attribute_char18 woo_attribute_char18,

wwoo.attribute_char19 woo_attribute_char19,

wwoo.attribute_char20 woo_attribute_char20,

wwoo.attribute_number1 woo_attribute_number1,

wwoo.attribute_number2 woo_attribute_number2,

wwoo.attribute_number3 woo_attribute_number3,

wwoo.attribute_number4 woo_attribute_number4,

wwoo.attribute_number5 woo_attribute_number5,

wwoo.attribute_number6 woo_attribute_number6,

wwoo.attribute_number7 woo_attribute_number7,

wwoo.attribute_number8 woo_attribute_number8,

wwoo.attribute_number9 woo_attribute_number9,

wwoo.attribute_number10 woo_attribute_number10,

wwoo.attribute_date1 woo_attribute_date1,

wwoo.attribute_date2 woo_attribute_date2,

wwoo.attribute_date3 woo_attribute_date3,

wwoo.attribute_date4 woo_attribute_date4,

wwoo.attribute_date5 woo_attribute_date5,

wwoo.attribute_timestamp1 woo_attribute_timestamp1,

wwoo.attribute_timestamp2 woo_attribute_timestamp2,

wwoo.attribute_timestamp3 woo_attribute_timestamp3,

wwoo.attribute_timestamp4 woo_attribute_timestamp4,

wwoo.attribute_timestamp5 woo_attribute_timestamp5

FROM cst_work_order_operations cwoo,

wis_work_centers_vl wwc,

wie_wo_operations_v wwoo

WHERE cwoo.work_center_id = wwc.work_center_id

AND wwoo.wo_operation_id(+) = cwoo.work_order_operation_id