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
| select
ETPPROD.N_IDETPPROD,
ETPPROD.N_IDPLANDISPOPROD,
PLANDISPOPROD.N_IDCLIENT_R,
PLANDISPOPROD.N_IDFOURNI_R,
ETPPROD.D_ETPPROD,
ARTVG.N_IDVARIETE,
SERIE.N_IDSERIE,
SERIE.S_NOSERIE,
PF.S_LBLPF,
ETPCONT.N_IDCONTVG as N_IDCONTVGETPCONT,
PF.N_IDCONTVG as N_IDCONTVGPF,
ETPPROD.F_QTETOTAPRODUIRE,
ETPCONT.S_IDETP,
ETPCONT.N_NOORDETPCONTCYCLEV,
ETPCONT.N_IDETPCONT,
TR_EPLPRODCHOISI.S_IDEPLPROD,
TR_EPLPRODCHOISI.N_QTECONTVGEPLPRODCHOISI,
sum(TR_REGLELIBEEPLPROD.N_QTEVENDUREGLELIBEEPLPROD) SumQteVenduEpl ,
ETPCONT.F_DENSITECONTVG,
ETPCONT.S_LBLDENSITECONTVG,
ETPCONT.F_NBCPSANTCPSE,
ETPCONT.F_PDSGRAINEPLAQUE,
ETPCONT.B_EXPRIMEGRAINE,
ETPPROD.S_SUIVIETPPROD,
PLANDISPOPROD.S_SUIVIDISPOPROD,
ETPCONT.N_IDSUPCULT,
ETPCONT.F_DELAIETPSUIV,
ETPCONT.N_NBGOUTTEURPARCONT,
ETPCONT.N_NBPERSONNESETPCONT,
ETPCONT.N_IDMA,
ETPCONT.N_IDEQUIPEMENTMA,
ETPCONT.S_LBLETPCONT,
B_GererQteEnFonctionALivrer
from ETPPROD
JOIN PLANDISPOPROD
ON PLANDISPOPROD.N_IDPLANDISPOPROD = ETPPROD.N_IDPLANDISPOPROD
JOIN SERIE
ON SERIE.N_IDSERIE = PLANDISPOPROD.N_IDSERIE
JOIN PF
ON PF.N_IDPF = PLANDISPOPROD.N_IDPF_R
JOIN ARTVG
ON PLANDISPOPROD.N_IDARTVG = ARTVG.N_IDARTVG
JOIN PF
ON PLANDISPOPROD.N_IDPF_R = PF.N_IDPF
JOIN ETPCONT
ON ETPPROD.N_IDETPCONT = ETPCONT.N_IDETPCONT
JOIN ETP
ON ETPCONT.S_IDETP = ETP.S_IDETP
JOIN TR_EPLPRODCHOISI ON ETPCONT.N_IDETPCONT = TR_EPLPRODCHOISI.N_IDETPCONT
JOIN EPLPROD ON EPLPROD.S_IDEPLPROD = TR_EPLPRODCHOISI.S_IDEPLPROD
LEFT OUTER JOIN REGLELIBERATION on REGLELIBERATION.N_IDETPCONT = ETPCONT.N_IDETPCONT
LEFT OUTER JOIN TR_REGLELIBEEPLPROD on (TR_REGLELIBEEPLPROD.N_IDREGLELIBERATION = REGLELIBERATION.N_IDREGLELIBERATION and TR_REGLELIBEEPLPROD.S_IDEPLPROD = TR_EPLPRODCHOISI.S_IDEPLPROD)
where
ETPPROD.S_STATUTPRETPPROD = 'R'
and S_SuiviDispoPROD <> 'T'
and S_SuiviDispoPROD <> 'ANN'
and (
ETP.S_IDETP
=
'SEM'
)
and ETPPROD.D_ETPPROD between '06/27/2005'and'02/22/2006'
GROUP BY
ETPPROD.N_IDPLANDISPOPROD,
ETPCONT.N_NOORDETPCONTCYCLEV,
ETPPROD.N_IDETPPROD,
PLANDISPOPROD.N_IDCLIENT_R,
PLANDISPOPROD.N_IDFOURNI_R,
ETPPROD.D_ETPPROD,
ARTVG.N_IDVARIETE,
SERIE.N_IDSERIE,
SERIE.S_NOSERIE,
PF.S_LBLPF,
ETPCONT.N_IDCONTVG,
PF.N_IDCONTVG,
ETPPROD.F_QTETOTAPRODUIRE,
ETPCONT.S_IDETP,
ETPCONT.N_IDETPCONT,
TR_EPLPRODCHOISI.S_IDEPLPROD,
TR_EPLPRODCHOISI.N_QTECONTVGEPLPRODCHOISI,
ETPCONT.F_DENSITECONTVG,
ETPCONT.S_LBLDENSITECONTVG,
ETPCONT.F_NBCPSANTCPSE,
ETPCONT.F_PDSGRAINEPLAQUE,
ETPCONT.B_EXPRIMEGRAINE,
ETPPROD.S_SUIVIETPPROD,
PLANDISPOPROD.S_SUIVIDISPOPROD,
ETPCONT.N_IDSUPCULT,
ETPCONT.F_DELAIETPSUIV,
ETPCONT.N_NBGOUTTEURPARCONT,
ETPCONT.N_NBPERSONNESETPCONT,
ETPCONT.N_IDMA,
ETPCONT.N_IDEQUIPEMENTMA,
ETPCONT.S_LBLETPCONT,
B_GererQteEnFonctionALivrer
order by
ETPPROD.N_IDPLANDISPOPROD,
ETPCONT.N_NOORDETPCONTCYCLEV,
ETPPROD.N_IDETPPROD |
Partager