CST_WORK_ORDERS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: CST
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 FROM CST_WORK_ORDERS CWO ,WIS_WORK_METHODS_VL CWM WHERE CWO.WORK_METHOD_ID = CWM.WORK_METHOD_ID |