Posted on
1
|
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
| select 'Allocated - general or pending issue' as AllocType, CASE WHEN MANUFACTUREORDERST_I = '1' THEN 'quote' WHEN MANUFACTUREORDERST_I = '2' THEN 'open' WHEN MANUFACTUREORDERST_I = '3' THEN 'released' WHEN MANUFACTUREORDERST_I = '4' THEN 'hold' WHEN MANUFACTUREORDERST_I = '5' THEN 'cancelled' WHEN MANUFACTUREORDERST_I = '6' THEN 'complete' WHEN MANUFACTUREORDERST_I = '7' THEN 'partially rec.' WHEN MANUFACTUREORDERST_I = '8' THEN 'closed' END AS MOstatus, *from MOP1400 inner join dbo.WO010032 ON dbo.MOP1400 .MANUFACTUREORDER_I = dbo.WO010032.MANUFACTUREORDER_Iwhere ATYALLOC > 0 select 'Allocated - bin ' as AllocType, CASE WHEN MANUFACTUREORDERST_I = '1' THEN 'quote' WHEN MANUFACTUREORDERST_I = '2' THEN 'open' WHEN MANUFACTUREORDERST_I = '3' THEN 'released' WHEN MANUFACTUREORDERST_I = '4' THEN 'hold' WHEN MANUFACTUREORDERST_I = '5' THEN 'cancelled' WHEN MANUFACTUREORDERST_I = '6' THEN 'complete' WHEN MANUFACTUREORDERST_I = '7' THEN 'partially rec.' WHEN MANUFACTUREORDERST_I = '8' THEN 'closed' END AS MOstatus, *from MOP1900 inner join dbo.WO010032 ON dbo.MOP1900.MANUFACTUREORDER_I = dbo.WO010032.MANUFACTUREORDER_Iwhere ATYALLOC > 0select 'Allocated - lot or pending issue' as AllocType, CASE WHEN MANUFACTUREORDERST_I = '1' THEN 'quote' WHEN MANUFACTUREORDERST_I = '2' THEN 'open' WHEN MANUFACTUREORDERST_I = '3' THEN 'released' WHEN MANUFACTUREORDERST_I = '4' THEN 'hold' WHEN MANUFACTUREORDERST_I = '5' THEN 'cancelled' WHEN MANUFACTUREORDERST_I = '6' THEN 'complete' WHEN MANUFACTUREORDERST_I = '7' THEN 'partially rec.' WHEN MANUFACTUREORDERST_I = '8' THEN 'closed' END AS MOstatus, * from MOP1020 inner join dbo.WO010032 ON dbo.MOP1020.MANUFACTUREORDER_I = dbo.WO010032.MANUFACTUREORDER_I |
No comments:
Post a Comment