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 45 46 47
| SELECT
Table__36.CDECIDEUR,
Table__36.CSECTEUR,
Table__15.LCOMMUNE,
Table__47.LVOIE,
Table__36.CSECTEUR||Table__36.COEIE,
Table__10.CAVIS,
Table__36.CDOMRES,
Table__10.CCENTRE,
Table__10.CZONE,
Table__10.CVOIE,
Table__36.CSSJUSTIF,
Table__36.CETAT,
Table__10.DEMANDE,
CENTRE_OEIE.LCENTRE,
Table__36.DTCREA,
Table__36.COMCRE,
Table__10.COMCRE,
Table__36.DTAGR,
Table__36.DTLIM,
Table__10.DTRETU,
Table__10.DTSCLI,
substr(Table__36.CREATEUR,1,8),
Table__463.CAFFREF,
Table__463.INDEST,
Table__463.DTENVETU
FROM
GP21Y.OEIE Table__36,
GP21Y.COMMUNE Table__15,
GP21Y.VOIE Table__47,
GP21Y.AVIS Table__10,
GP21Y.CENTRE CENTRE_OEIE,
GP21Y.OEIE_PIBL Table__463,
GP21Y.ZONE ZONE_OEIE
WHERE
( Table__10.CCOMMUNE=Table__47.CCOMMUNE AND Table__10.CVOIE = Table__47.CVOIE )
AND ( Table__36.CSECTEUR(+) = Table__10.CSECTEUR AND Table__36.COEIE(+) = Table__10.COEIE )
AND ( Table__36.CDOMRES = ZONE_OEIE.CDOMRES(+) AND Table__36.CCENTRE=ZONE_OEIE.CCENTRE(+) AND Table__36.CZONE = ZONE_OEIE.CZONE(+) )
AND ( Table__47.CCOMMUNE=Table__15.CCOMMUNE )
AND ( ZONE_OEIE.CDOMRES = CENTRE_OEIE.CDOMRES AND ZONE_OEIE.CCENTRE = CENTRE_OEIE.CCENTRE )
AND ( Table__36.CSECTEUR=Table__463.CSECTEUR(+) and Table__36.COEIE=Table__463.COEIE(+) )
AND
(
Table__36.CSSJUSTIF IN ( 'E8','DG','DI','CG','DP','E9' )
AND
Table__36.CETAT IN ( '1','2','3','4','5' )
) |
Partager