1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
| WHERE
( GPPAR_co_fm.SCLE=*PERB1.PCONT )
AND ( GPPAR_co_fm.NTAB = CO )
AND ( GPPAR_k1_fm.NTAB=K1 )
AND ( GPPAR_k1_fm.SCLE=*PERB1.PCRI1 )
AND ( GPPAR_me_fm.SCLE=*PERB1.PMEMB )
AND ( GPPAR_me_fm.NTAB=ME )
AND ( GPPAR_mr_fm.SCLE=*PERB1.PMOTI )
AND ( GPPAR_mr_fm.NTAB=MR )
AND ( PERB1.MULBP=MULBP.IDENT and PERB1.IDENT=MULBP.PERB1 )
AND ( LIEU_uo_fm.LIEU=*PERB2.PLIEU )
AND ( PERB1.PMATR=PERB2.PMATR and PERB1.IDENT=PERB2.IDENT )
AND ( GPPAR_kb_fm.NTAB=KB )
AND ( PERB2.PCPR5*=GPPAR_kb_fm.SCLE )
AND ( SER_service_fm.SNUME=*PERB1.PSEC2 )
AND ( SER_service_fm.SCODE = 2 )
AND ( substring(PERB1.PSEC2,1,3)*=substring(SER_direction_fm.SNUME,1,3) )
AND ( SER_direction_fm.SCODE=1 )
AND ( ( MULBP.PMATR=PER1.PMATR ) AND MULBP.PCENR=M )
AND (
PERB1.PDAT2 BETWEEN @prompt ('Date de recherche 1','D',,MONO,FREE) AND @prompt ['Date de recherche 2','D',,MONO,FREE]
AND PERB1.PDAT2 BETWEEN MULBP.PDEBM AND MULBP.DTRAI
) |
Partager