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 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111
| SELECT
workorder_parent.wonum,
workorder_parent.Description,
workorder_parent_c.wonum,
workorder_parent_c.Description,
dbo.workorder.wol1,
dbo.workorder.statusdate,
convert(datetime,convert(char(10),( dbo.workorder.statusdate ),112)),
datepart(cwk,( convert(datetime,convert(char(10),( dbo.workorder.statusdate ),112)) )),
datepart(hh,dbo.workorder.statusdate) * 10000 + datepart(mi,dbo.workorder.statusdate) * 100 + datepart(ss,dbo.workorder.statusdate),
dbo.workorder.Description,
DESCRIPTION_longdesc.ldtext,
DESCRIPT_longdesc_exist.ldtext,
dbo.workorder.Wo9,
DEPANNAGE_longdesc.ldtext,
dbo.workorder.wopm1,
dbo.workorder.wonum,
dbo.workorder.parent,
dbo.workorder.wo19,
dbo.workorder.Wo18,
dbo.workorder.Wo2,
dbo.workorder.reportdate,
convert(datetime,convert(char(10),( dbo.workorder.reportdate ),112)),
datepart(cwk,( convert(datetime,convert(char(10),( dbo.workorder.reportdate ),112)) )),
convert(datetime,convert(varchar(12),(dateadd(dd,-datepart(day,dbo.workorder.reportdate)+1,dbo.workorder.reportdate)))),
datepart(hh,dbo.workorder.reportdate) * 10000 + datepart(mi,dbo.workorder.reportdate) * 100 + datepart(ss,dbo.workorder.reportdate),
dbo.workorder.Wo20,
dbo.workorder.status,
dbo.workorder.WO16,
dbo.workorder.location,
datepart(cwk,dbo.workorder.reportdate),
dbo.workorder.reportedby,
dbo.labor.name,
dbo.workorder.Wol2,
dbo.workorder.wo1,
dbo.workorder.Wo10,
MODIMPACT_longdesc.ldtext,
dbo.workorder.Wo11,
dbo.workorder.Wo8,
ANASOLUT_longdesc.ldtext,
dbo.workorder.leadcraft,
dbo.workorder.supervisor,
dbo_laborreal.name,
dbo.workorder.WO17,
dbo.workorder.wo3,
dbo.workorder.wo12,
JUSTIFIGAIN_longdesc.ldtext,
dbo.workorder.schedstart,
dbo.workorder.schedfinish,
dbo.workorder.wo6,
dbo.workorder.wo6,
dbo.workorder.wopm3,
dbo.workorder.wopm4,
dbo.workorder.wo15,
dbo.workorder.wo15,
dbo.workorder.targstartdate,
dbo.workorder.targcompdate,
dbo.workorder.historyflag,
dbo.workorder.wopm5,
dbo.workorder.haschildren,
dbo.workorder.wopriority
FROM
dbo.labor,
dbo.labor dbo_laborreal,
dbo.workorder workorder_parent,
dbo.workorder workorder_parent_c,
dbo.workorder,
dbo.longdescription DESCRIPTION_longdesc,
dbo.longdescription DESCRIPT_longdesc_exist,
dbo.longdescription DEPANNAGE_longdesc,
dbo.longdescription MODIMPACT_longdesc,
dbo.longdescription ANASOLUT_longdesc,
dbo.longdescription JUSTIFIGAIN_longdesc,
locancestor
WHERE
( DESCRIPTION_longdesc.ldownercol = 'DESCRIPTION' and DESCRIPTION_longdesc.ldownertable = 'WORKORDER' )
AND ( DESCRIPTION_longdesc.ldkey=*dbo.workorder.ldkey )
AND ( DEPANNAGE_longdesc.ldkey=*dbo.workorder.ldkey )
AND ( DEPANNAGE_longdesc.ldownercol = 'Wo9' and DEPANNAGE_longdesc.ldownertable = 'WORKORDER' )
AND ( MODIMPACT_longdesc.ldownercol = 'Wo10' and MODIMPACT_longdesc.ldownertable = 'WORKORDER' )
AND ( dbo.workorder.ldkey*=MODIMPACT_longdesc.ldkey )
AND ( ANASOLUT_longdesc.ldownercol = 'Wo8' and ANASOLUT_longdesc.ldownertable = 'WORKORDER' )
AND ( ANASOLUT_longdesc.ldkey=*dbo.workorder.ldkey )
AND ( JUSTIFIGAIN_longdesc.ldkey=*dbo.workorder.ldkey )
AND ( JUSTIFIGAIN_longdesc.ldownercol = 'Wo12' and JUSTIFIGAIN_longdesc.ldownertable = 'WORKORDER' )
AND ( dbo.workorder.parent*=workorder_parent.wonum )
AND ( DESCRIPT_longdesc_exist.ldownercol = 'DESCRIPTION' and DESCRIPT_longdesc_exist.ldownertable = 'WORKORDER' )
AND ( DESCRIPT_longdesc_exist.ldkey=dbo.workorder.ldkey )
AND ( dbo.workorder.location=locancestor.location )
AND ( workorder_parent_c.wonum=dbo.workorder.parent )
AND ( dbo.labor.laborcode=dbo.workorder.reportedby )
AND ( dbo.workorder.supervisor*=dbo_laborreal.laborcode )
AND (
dbo.workorder.wopm1 != 'ASTREINTE'
AND dbo.workorder.historyflag = 'N'
AND (locancestor.ancestor = 'POLI GMAO'
OR dbo.workorder.leadcraft = 'GMAO-MP'
OR dbo.workorder.parent = ANY (SELECT
dbo.workorder.wonum
FROM
dbo.workorder
WHERE
(
dbo.workorder.supervisor = 'P002872'
AND dbo.workorder.historyflag = 'N'
)
)
OR dbo.workorder.supervisor = 'E001691')
AND dbo.workorder.WO17 IS NOT NULL
AND dbo.workorder.status != '10 SOLDE'
) |
Partager