1 2 3 4 5 6 7 8 9 10 11 12 13 14
| TX_H_N0 AS (select iwmmcu, iwmcu, IWSTLF*0.01 Direct_MO , IWSTFF*0.01"Réglage", iwstrf*0.01"Direct MO", iwstrz*0.01"Fixe MO", iwmsfr*0.01"Machine", iwmstf*0.01"Direct Machine", iwmssf*0.01"Fixe Machine"
from proddta.F30008
where IWledg = '07'and trim(iwmmcu) like '%02040'),
OFMAX_N7 AS (SELECT ART_N0,PC_N0,SEQ_N0,LIB_OPE_N0,TMO_N0,CompSant_N1,libellé_Cpsant_N1, OFMAX_N1,PC_N1,SEQ_N1,LIB_OPE_N1,TMO_N1,CompSant_N2, libellé_Cpsant_N2,
OFMAX_N2, PC_N2, SEQ_N2, LIB_OPE_N2, TMO_N2, CompSant_N3, libellé_Cpsant_N3, OFMAX_N3, PC_N3, SEQ_N3, LIB_OPE_N3, TMO_N3,CompSant_N4, libellé_Cpsant_N4,
OFMAX_N4, PC_N4, SEQ_N4, LIB_OPE_N4, TMO_N4, CompSant_N5, libellé_Cpsant_N5, OFMAX_N5, PC_N5, SEQ_N5, LIB_OPE_N5, TMO_N5, CompSant_N6, libellé_Cpsant_N6,
OFMAX_N6, PC_N6, SEQ_N6, LIB_OPE_N6, TMO_N6, CompSant_N7, libellé_Cpsant_N7, OFMAX_N0.OFMAX_N0 OFMAX_N7
FROM NOMEN_N7 LEFT join OFMAX_N0 on OFMAX_N0.WAAITM=CompSant_N7 where ART_N0='016884')
Select ART_N0,PC_N0,SEQ_N0,LIB_OPE_N0, TMO_N0, Direct_MO, TMO_N0*Direct_MO CT_MO_0,CompSant_N1,libellé_Cpsant_N1, PC_N1,SEQ_N1,LIB_OPE_N1,TMO_N1,CompSant_N2, libellé_Cpsant_N2,
PC_N2, SEQ_N2, LIB_OPE_N2, TMO_N2, CompSant_N3, libellé_Cpsant_N3, PC_N3, SEQ_N3, LIB_OPE_N3, TMO_N3, CompSant_N4, libellé_Cpsant_N4,
PC_N4, SEQ_N4, LIB_OPE_N4, TMO_N4, CompSant_N5, libellé_Cpsant_N5, PC_N5, SEQ_N5, LIB_OPE_N5, TMO_N5, CompSant_N6, libellé_Cpsant_N6,
PC_N6, SEQ_N6, LIB_OPE_N6, TMO_N6, CompSant_N7, libellé_Cpsant_N7
from OFMAX_N7 Left join TX_H_N0 tx1 on iwmcu=PC_N0
Left join TX_H_N0 tx2 on iwmcu=PC_N1 |
Partager