# `viw_mftproductionplan_workorder` (view)


- **Updatable:** NO

## Columns

| # | Name | Type | Null |
|---|---|---|---|
| 1 | `sWorkOrderId` | `varchar(100)` | NO |
| 2 | `sSrcNo` | `varchar(255)` | NO |
| 3 | `sState` | `varchar(255)` | NO |
| 4 | `imorder` | `int` | YES |
| 5 | `sid` | `varchar(100)` | NO |
| 6 | `bFrozen` | `bit(1)` | NO |

## Definition

```sql
select `mftproductionplan`.`sWorkOrderId` AS `sWorkOrderId`,`mftproductionplan`.`sSrcNo` AS `sSrcNo`,`mftproductionplan`.`sState` AS `sState`,min(`mftproductionplan`.`iOrder`) AS `imorder`,`mftproductionplan`.`sId` AS `sid`,`mftproductionplan`.`bFrozen` AS `bFrozen` from `mftproductionplan` where (`mftproductionplan`.`sState` in (1,2,3,7)) group by `mftproductionplan`.`sWorkOrderId`,`mftproductionplan`.`sSrcNo`,`mftproductionplan`.`sState`,`mftproductionplan`.`iOrder` order by `mftproductionplan`.`iOrder`
```

## Narrative

_No human-written narrative yet._
