1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
| SELECT Q.sonbralt, P.descr, sch.prodid, ps.descr , sch.prodstatusid2, sch.amount,
sch.deliveryno, z.name, sch.schdate, sch.deliverydate, schwc.nbhours, C.fermes
FROM workcenter w
INNER JOIN rsscheduledtlwc schwc ON w.wcid = schwc.wcid
INNER JOIN rsscheduledtl sch ON schwc.rsschdtlid = sch.rsschdtlid
LEFT JOIN zuser z ON sch.techuserid = z.userid
INNER JOIN prodstatus ps ON sch.prodstatusid = ps.prodstatusid
INNER JOIN QOHdr Q ON sch.qonbr = Q.qonbr
INNER JOIN projecttype P ON Q.projtypeid = P.projtypeid
INNER JOIN vContractSummary C ON Q.sonbralt = C.sonbralt
WHERE sch.prodstatusid IN (4,1,6)
AND sch.isactive = 1
AND Q.isActive = 0
AND sch.prodid = " & noprod & "
AND Q.sonbralt IS NOT NULL
AND sch.schdate > '" & dateD & "'
AND schwc.wcid = 2 |
Partager