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
| Select Distinct A.Id_Xfo, Min(B.Poste) Poste, Min(B.Date_Debut) Date_Debut,
A.Date_Planifiee, W.Xfo_Fab, A.Urgence, C.Orde_No, C.Orde_Line, C.Orde_Line_Seq,
E.Nom_Rap, S.Priorite_Prod, W.Priorite_Prod
from Planif_Etape_Xfo A
INNER JOIN Xfo X On
X.In_Entity = A.In_Entity AND
X.Id_Xfo = A.Id_Xfo
INNER JOIN Wo_Fab W On
W.In_Entity = X.In_Entity AND
W.Wo_No = X.Wo_No
INNER JOIN Specxfo D On
D.In_Entity = W.In_Entity AND
D.Xfo_Fab = W.Xfo_Fab AND
D.Revision = W.Revision
LEFT JOIN Xfochois C On
C.In_Entity = A.In_Entity AND
C.Id_Xfo = A.Id_Xfo
LEFT JOIN Wo_Vendu S On
S.In_Entity = C.In_Entity AND
S.Orde_No = C.Orde_No AND
S.Orde_Line = C.Orde_Line
LEFT JOIN Nomven N On
N.In_Entity = S.In_Entity AND
N.Xfo_Vendu = S.Xfo_Vendu AND
N.Version = S.Version
LEFT JOIN Certification E On
E.Id_Code = N.Id_Code
INNER JOIN Bt_Temps_Prod B On
B.In_Entity = A.In_Entity AND
B.Id_Xfo = A.Id_Xfo
where A.In_Entity = 'DG'
and A.Etape_No = 550
and A.Debut_Execution Is Null
and A.Prod_Etape = 'T'
And Exists (Select *
From Planif_Etape_Xfo B
Where B.In_Entity = A.In_Entity
And B.Id_Xfo = A.Id_Xfo
And B.Etape_No = 525
And Debut_Execution Is Not Null)
And B.Etape_No = 525
And D.Secteur = 'D'
Group By A.Id_Xfo, A.Date_Planifiee, W.Xfo_Fab, A.Urgence, C.Orde_No, C.Orde_Line,
C.Orde_Line_Seq, E.Nom_Rap, S.Priorite_Prod, W.Priorite_Prod
Order By A.Date_Planifiee, S.Priorite_Prod, W.Priorite_Prod; |
Partager