Bonjour à tous,
dans le code suivant je n'ai pas le bon nombre de Ok et Rebuts qui remontent. Je n'arrive pas à trouver les bons paramètre dans les sous-requêtes, je ne comprends pas d'ou vient mon erreur.


Code : Sélectionner tout - Visualiser dans une fenêtre à part
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
 SELECT ress.NAME MACHINE 
,       ress.ID_RESOURCE
,       wo.id_wo
,       wo.id_article
,       ress.RATE_PREPARE_SALE
,       wo_op.seq
,       (select sum(WIP.QTY_COMPLETED)
         from WIP 
         where WIP.ID_WO = WO.ID_WO
         and  WIP.ID_WO_OP = WO_OP.ID_WO_OP
         ) OK
,       (select sum(WIP.QTY_defective)
         from WIP 
         where WIP.ID_WO = WO.ID_WO 
         and WIP.ID_WO_OP = WO_OP.ID_WO_OP
         ) Rebuts
,      ROUND(WO_INSTRUCTION.WORK_TIME_HC,3) TPS_CYCLE_UNITAIRE
FROM   TOPPDM.RESOURCES ress 
,      TOPMES.WIP
,      TOPMES.WO
,      TOPMES.WO_INSTRUCTION
,      TOPMES.WO_OP
WHERE  ress.ID_RESOURCE = wip.id_resource
and    WIP.ID_WO = WO.ID_WO(+)
AND    WIP.ID_WO_OP = WO_OP.ID_WO_OP (+)
AND    WO_OP.ID_WO_INSTRUCTION = WO_INSTRUCTION.ID_WO_INSTRUCTION (+)
and    WIP.END_AT_DATE >=TO_DATE ('01/09/2021', 'DD-MM-YYYY') 
and    WIP.END_AT_DATE <TO_DATE ('01/10/2021', 'DD-MM-YYYY')
and    ress.type = 2
and    ress.ID_RESOURCE = 1481
and    wo.id_wo  = 21278
GROUP BY ress.NAME
, ress.ID_RESOURCE, wo.id_wo
, ress.RATE_PREPARE_SALE
, WO_INSTRUCTION.WORK_TIME_HC
, ROUND(WO_INSTRUCTION.WORK_TIME_HC,3)
, wo_op.seq
, wo.id_article
, WO_OP.ID_WO_OP
, WIP.QTY_COMPLETED
, WO_OP.ID_WO_INSTRUCTION
, WO_INSTRUCTION.ID_WO_INSTRUCTION
, WIP.QTY_defective
;