1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21
| Select P.BPR_0, PD.ITMREF_0, B.BPSNUM_0, IT.TSICOD_0, PD.ITMDES_0, P.INVTYP_0, PD.QTYSTU_0, PD.STU_0, P.CUR_0, PD.AMTNOTLIN_0, I.STOFCY_0, PD.ACCDAT_0, C1.STOFCY_0, C1.CSTTYP_0, C1.YEA_0, C1.VLTTOT_0, C2.VLTTOT_0, PR.DCGVAL_1, PD.NUM_0, PD.PIDLIN_0
From PINVOICE P, PINVOICED PD, BPSUPPLIER B, ITMFACILIT I, ITMMASTER IT, ITMCOST C1, ITMCOST C2
Where P.NUM_0=PD.NUM_0
And P.BPR_0=B.BPSNUM_0
And PD.ITMREF_0=I.ITMREF_0
And PD.ITMREF_0=IT.ITMREF_0
And PD.ITMREF_0=C1.ITMREF_0
And PD.ITMREF_0=C2.ITMREF_0
And P.BPR_0!=PR.PLICRI1_0
And PD.ITMREF_0!=PR.PLICRI2_0
And (P.BPR_0 between '{?fourdeb}' and '{?fourfin}')
And (PD.ACCDAT_0 between {?datedeb} and {?datefin})
And (PD.ITMREF_0 between '{?artdeb}' and '{?artfin}')
And P.CUR_0='EUR'
And I.STOFCY_0='LOU'
And C1.STOFCY_0='LOU'
And C1.CSTTYP_0=3
And C1.YEA_0=2012
And C2.STOFCY_0='LOU'
And C2.CSTTYP_0=2
And C2.YEA_0=2012 |
Partager