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
| SELECT
MAX(B2.PRB_SEQUENCE) TRI_SEQUENCE,
cast(floatdiv((SELECT sum(J.INV_PRIXUNITE *(floatdiv(UTJ_QTETOTJOUR1, 1)
+ floatdiv(UTJ_QTETOTJOUR2, 1) + floatdiv(UTJ_QTETOTJOUR3, 1) + floatdiv(
UTJ_QTETOTJOUR4, 1) + floatdiv(UTJ_QTETOTJOUR5, 1) + floatdiv(UTJ_QTETOTJOUR6,
1) + floatdiv(UTJ_QTETOTJOUR7, 1) + floatdiv(UTJ_QTETOTJOUR8, 1) + floatdiv(
UTJ_QTETOTJOUR9, 1) + floatdiv(UTJ_QTETOTJOUR10, 1) + floatdiv(
UTJ_QTETOTJOUR11, 1) + floatdiv(UTJ_QTETOTJOUR12, 1) + floatdiv(
UTJ_QTETOTJOUR13, 1) + floatdiv(UTJ_QTETOTJOUR14, 1) + floatdiv(
UTJ_QTETOTJOUR15, 1) + floatdiv(UTJ_QTETOTJOUR16, 1) + floatdiv(
UTJ_QTETOTJOUR17, 1) + floatdiv(UTJ_QTETOTJOUR18, 1) + floatdiv(
UTJ_QTETOTJOUR19, 1) + floatdiv(UTJ_QTETOTJOUR20, 1) + floatdiv(
UTJ_QTETOTJOUR21, 1) + floatdiv(UTJ_QTETOTJOUR22, 1) + floatdiv(
UTJ_QTETOTJOUR23, 1) + floatdiv(UTJ_QTETOTJOUR24, 1) + floatdiv(
UTJ_QTETOTJOUR25, 1) + floatdiv(UTJ_QTETOTJOUR26, 1) + floatdiv(
UTJ_QTETOTJOUR27, 1) + floatdiv(UTJ_QTETOTJOUR28, 1) + floatdiv(
UTJ_QTETOTJOUR29, 1) + floatdiv(UTJ_QTETOTJOUR30, 1) + floatdiv(
UTJ_QTETOTJOUR31, 1))) FROM INVUTILISATIONJOUR U WHERE UTJ_ANNEE * 12 +
UTJ_MOIS > 24132 AND UTJ_ANNEE * 12 + UTJ_MOIS < 24136 AND U.PRB_CODWRIN =
B.PRB_CODWRIN), 1) AS NUMERIC (12, 3)) PRIX_QTETOT
FROM HISPRODBRUT B2,
INVPRODGENERIQUE G,
HISPRODBRUT B
LEFT JOIN INVINVENTAIRE J ON (J.PRB_CODWRIN = B.PRB_CODWRIN AND
J.CAL_DTACTIVITE = '4/14/2011')
LEFT JOIN INVNIVEAUSTOCK K ON (K.PRB_CODWRIN = B.PRB_CODWRIN AND
K.NST_ANNEE = 2010 AND K.NST_MOIS = 12)
WHERE B.PRB_DTEFFET <= '4/14/2011' AND
(B.PRB_DTFINEFFET >= '4/14/2011' OR
B.PRB_DTFINEFFET IS NULL) AND
B.PRB_ACTIF = 'T' AND
B.PRB_PERIODEINV <= 0 AND
B.PRG_CODMRIN = G.PRG_COD AND
G.PRB_CODCALCULCOUT = B2.PRB_CODWRIN AND
G.PRG_RENDSTAT = 'T' AND
B2.PRB_DTEFFET <= '4/14/2011' AND
(B2.PRB_DTFINEFFET >= '4/14/2011' OR
B2.PRB_DTFINEFFET IS NULL) |
Partager