SELECT DISTINCT ZOZA.SOCDOS, ZOZA.CDENTI, ZOZA.CDEXPL, ZOZA.LIBMOI, ZOZA.ANNEE0, ZOZA.MONTD1, ZOZA.MONTD2, ZOZA.MONTD3, ZOZA.MONTD4, ZOZA.MONTD5, ZOZA.DEVIS, ZOZA.NBVIRE, ZOZA.MONTE1, ZOZA.MONTE2, ZOZA.MONTE3, ZOZA.MONTE4, ZOZA.MONTE5, ZOZA.MONTE6, ZD01_1.LIBLON, rpad(ZD0I.COMPT1,4) , substrb(ZD0I.COMPT1,5) , ZD0I.BANDOR, ZDAG.CDSIRE||ZDAG.CDNICS, ZDBC.DAVIR FROM HR.ZD00 ZD00, HR.ZD00 ZD00_1, HR.ZD01 ZD01, HR.ZD01 ZD01_1, HR.ZD0I ZD0I, HR.ZDAG ZDAG, HR.ZDZF ZDZF, HR.ZOZA ZOZA, HR.ZDBC ZDBC, ( select distinct (LIBMOI), decode(LIBMOI, 'JANVIER ','01', 'FEVRIER ','02', 'MARS ','03', 'AVRIL ','04', 'MAI ','05', 'JUIN ','06', 'JUILLET ','07', 'AOUT ','08', 'SEPTEMBRE','09', 'OCTOBRE ','10', 'NOVEMBRE ','11', 'DECEMBRE ','12', ' ') as mois from hr.zoza) c, HR.ZD00 d WHERE (ZD01.NUDOSS=ZD00.nudoss) AND (ZD00.CDSTCO='YBQ') AND (ZD00.CDREGL='M01') AND (ZD00.CDCODE=ZOZA.CDEXPL) AND (ZD01_1.NUDOSS=ZD00_1.nudoss) AND (ZD00_1.CDSTCO='UAA') AND (ZD00_1.CDREGL='M01') AND (ZD00_1.CDCODE=ZOZA.CDENTI) AND (ZD0I.NUDOSS=ZD00_1.nudoss) AND (ZDAG.NUDOSS=ZD00_1.NUDOSS) AND c.libmoi = ZOZA.libmoi and d.cdregl = 'M01' and d.CDSTCO = 'DR7' and d.cdcode = 'AN'||c.mois||' ' and ZDBC.typass = 'N' and ZDBC.CDPEPA = substrb(ZOZA.annee0,3,2)||c.mois and ZDBC.nudoss = d.nudoss union SELECT DISTINCT ZOZA.SOCDOS, ZOZA.CDENTI, ZOZA.CDEXPL, ZOZA.LIBMOI, ZOZA.ANNEE0, ZOZA.MONTD1, ZOZA.MONTD2, ZOZA.MONTD3, ZOZA.MONTD4, ZOZA.MONTD5, ZOZA.DEVIS, ZOZA.NBVIRE, ZOZA.MONTE1, ZOZA.MONTE2, ZOZA.MONTE3, ZOZA.MONTE4, ZOZA.MONTE5, ZOZA.MONTE6, ' ' , ' ' ,' ' ,' ' , ' ' , ZDBC.DAVIR FROM HR.ZOZA ZOZA, HR.ZDBC ZDBC, ( select distinct (LIBMOI), decode(LIBMOI, 'JANVIER ','01', 'FEVRIER ','02', 'MARS ','03', 'AVRIL ','04', 'MAI ','05', 'JUIN ','06', 'JUILLET ','07', 'AOUT ','08', 'SEPTEMBRE','09', 'OCTOBRE ','10', 'NOVEMBRE ','11', 'DECEMBRE ','12', ' ') as mois from hr.zoza) c, HR.ZD00 d WHERE ZOZA.CDENTI='CAS' AND c.libmoi = ZOZA.libmoi and d.cdregl = 'M01' and d.CDSTCO = 'DR7' and d.cdcode = 'AN'||c.mois||' ' and ZDBC.typass = 'N' and ZDBC.CDPEPA = substrb(ZOZA.annee0,3,2)||c.mois and ZDBC.nudoss = d.nudoss
Partager