WIE_WORK_ORDERS_ON_HOLD_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: WIE
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
WORK_ORDER_ID WORK_ORDER_STATUS_ID PLANNED_COMPLETION_DATE ORGANIZATION_ID WORK_METHOD_CODE |
問合せ
| SQL_Statement |
|---|
|
SELECT wo.work_order_id, wo.work_order_status_id, wo.planned_completion_date, wo.organization_id, wm.work_method_code FROM wie_work_orders_b wo, wis_work_methods_b wm WHERE wo.work_order_status_id IN (SELECT wosts.wo_status_id FROM wie_wo_statuses_b wosts WHERE wosts.wo_system_status_code = 'ON_HOLD') AND wo.order_less_flag = 'N' AND wo.work_method_id = wm.work_method_id |