1. Tables and Views for SCM
  2. CST_XLA_WORK_ORDERS_V

CST_XLA_WORK_ORDERS_V

Details

  • Schema: FUSION

  • Object owner: CST

  • Object type: VIEW

Columns

Name

CST_WORK_ORDER_ID

EXTERNAL_SYSTEM_REFERENCE

WO_EXTERNAL_SYSTEM_REF_ID

WORK_ORDER_NUMBER

INV_ORG_ID

PRIMARY_OUTPUT_ITEM_ID

WORK_METHOD_ID

WORK_ORDER_TYPE

WORK_ORDER_SUB_TYPE

WORK_ORDER_LESS_FLAG

WORK_METHOD_CODE

WO_ATTRIBUTE_CATEGORY

WO_ATTRIBUTE_CHAR1

WO_ATTRIBUTE_CHAR2

WO_ATTRIBUTE_CHAR3

WO_ATTRIBUTE_CHAR4

WO_ATTRIBUTE_CHAR5

WO_ATTRIBUTE_CHAR6

WO_ATTRIBUTE_CHAR7

WO_ATTRIBUTE_CHAR8

WO_ATTRIBUTE_CHAR9

WO_ATTRIBUTE_CHAR10

WO_ATTRIBUTE_CHAR11

WO_ATTRIBUTE_CHAR12

WO_ATTRIBUTE_CHAR13

WO_ATTRIBUTE_CHAR14

WO_ATTRIBUTE_CHAR15

WO_ATTRIBUTE_CHAR16

WO_ATTRIBUTE_CHAR17

WO_ATTRIBUTE_CHAR18

WO_ATTRIBUTE_CHAR19

WO_ATTRIBUTE_CHAR20

WO_ATTRIBUTE_NUMBER1

WO_ATTRIBUTE_NUMBER2

WO_ATTRIBUTE_NUMBER3

WO_ATTRIBUTE_NUMBER4

WO_ATTRIBUTE_NUMBER5

WO_ATTRIBUTE_NUMBER6

WO_ATTRIBUTE_NUMBER7

WO_ATTRIBUTE_NUMBER8

WO_ATTRIBUTE_NUMBER9

WO_ATTRIBUTE_NUMBER10

WO_ATTRIBUTE_DATE1

WO_ATTRIBUTE_DATE2

WO_ATTRIBUTE_DATE3

WO_ATTRIBUTE_DATE4

WO_ATTRIBUTE_DATE5

WO_ATTRIBUTE_TIMESTAMP1

WO_ATTRIBUTE_TIMESTAMP2

WO_ATTRIBUTE_TIMESTAMP3

WO_ATTRIBUTE_TIMESTAMP4

WO_ATTRIBUTE_TIMESTAMP5

Query

SQL_Statement

SELECT /*+ NO_MERGE */ cwo.cst_work_order_id cst_work_order_id,

cwo.external_system_reference external_system_reference,

cwo.external_system_ref_id wo_external_system_ref_id,

cwo.work_order_number work_order_number,

cwo.inventory_organization_id inv_org_id,

cwo.inventory_item_id primary_output_item_id,

cwo.work_method_id work_method_id,

wwv.work_order_type work_order_type,

wwv.work_order_sub_type work_order_sub_type,

cwo.work_order_less_flag work_order_less_flag,

wwv.work_method_code work_method_code,

wwv.attribute_category wo_attribute_category,

wwv.attribute_char1 wo_attribute_char1,

wwv.attribute_char2 wo_attribute_char2,

wwv.attribute_char3 wo_attribute_char3,

wwv.attribute_char4 wo_attribute_char4,

wwv.attribute_char5 wo_attribute_char5,

wwv.attribute_char6 wo_attribute_char6,

wwv.attribute_char7 wo_attribute_char7,

wwv.attribute_char8 wo_attribute_char8,

wwv.attribute_char9 wo_attribute_char9,

wwv.attribute_char10 wo_attribute_char10,

wwv.attribute_char11 wo_attribute_char11,

wwv.attribute_char12 wo_attribute_char12,

wwv.attribute_char13 wo_attribute_char13,

wwv.attribute_char14 wo_attribute_char14,

wwv.attribute_char15 wo_attribute_char15,

wwv.attribute_char16 wo_attribute_char16,

wwv.attribute_char17 wo_attribute_char17,

wwv.attribute_char18 wo_attribute_char18,

wwv.attribute_char19 wo_attribute_char19,

wwv.attribute_char20 wo_attribute_char20,

wwv.attribute_number1 wo_attribute_number1,

wwv.attribute_number2 wo_attribute_number2,

wwv.attribute_number3 wo_attribute_number3,

wwv.attribute_number4 wo_attribute_number4,

wwv.attribute_number5 wo_attribute_number5,

wwv.attribute_number6 wo_attribute_number6,

wwv.attribute_number7 wo_attribute_number7,

wwv.attribute_number8 wo_attribute_number8,

wwv.attribute_number9 wo_attribute_number9,

wwv.attribute_number10 wo_attribute_number10,

wwv.attribute_date1 wo_attribute_date1,

wwv.attribute_date2 wo_attribute_date2,

wwv.attribute_date3 wo_attribute_date3,

wwv.attribute_date4 wo_attribute_date4,

wwv.attribute_date5 wo_attribute_date5,

wwv.attribute_timestamp1 wo_attribute_timestamp1,

wwv.attribute_timestamp2 wo_attribute_timestamp2,

wwv.attribute_timestamp3 wo_attribute_timestamp3,

wwv.attribute_timestamp4 wo_attribute_timestamp4,

wwv.attribute_timestamp5 wo_attribute_timestamp5

FROM cst_work_orders cwo,

wie_work_orders_v wwv

WHERE wwv.work_order_id = cwo.external_system_ref_id

AND cwo.external_system_reference = 'FUSION'