CST_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 WORK_METHOD_ID WORK_ORDER_TYPE WORK_ORDER_SUB_TYPE WORK_ORDER_LESS_FLAG WORK_METHOD_CODE MNT_COMPLETE_TO_INV_FLAG MNT_ALLOW_MULTIPLE_ASSETS_FLAG

Query

SQL_Statement

SELECT 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.WORK_METHOD_ID WORK_METHOD_ID ,CWO.WORK_ORDER_TYPE WORK_ORDER_TYPE ,CWO.WORK_ORDER_SUB_TYPE WORK_ORDER_SUB_TYPE ,CWO.WORK_ORDER_LESS_FLAG WORK_ORDER_LESS_FLAG ,CWM.WORK_METHOD_CODE ,CWO.MNT_COMPLETE_TO_INV_FLAG ,CWO.MNT_ALLOW_MULTIPLE_ASSETS_FLAG FROM CST_WORK_ORDERS CWO ,WIS_WORK_METHODS_VL CWM WHERE CWO.WORK_METHOD_ID = CWM.WORK_METHOD_ID