1. Tables and Views for SCM
  2. MNT_FORECAST_IN_PROCESS_WO_V

MNT_FORECAST_IN_PROCESS_WO_V

Details

  • Schema: FUSION

  • Object owner: MNT

  • Object type: VIEW

Columns

Name

INTERFACE_BATCH_ID

INTERFACE_STATUS_CODE

WORK_DEFINITION_ID

PROGRAM_ID

MNT_FORECAST_ID

Query

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