MNT_FORECAST_IN_PROCESS_WO_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: MNT
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
INTERFACE_BATCH_ID INTERFACE_STATUS_CODE WORK_DEFINITION_ID PROGRAM_ID MNT_FORECAST_ID |
問合せ
| SQL_Statement |
|---|
|
select woi.interface_batch_id, woi.interface_status_code, woi.work_definition_id, mf.program_id, woi.mnt_forecast_id from wie_int_batches_b wib, wie_work_orders_int woi, mnt_forecasts mf where wib.interface_batch_id = woi.interface_batch_id and wib.interface_batch_status in ('READY','IN_PROCESS') and woi.work_method_code = 'MAINTENANCE' and woi.interface_status_code in ('READY','IN_PROCESS') and woi.mnt_forecast_id is not null and mf.forecast_id = woi.mnt_forecast_id |