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
|
AND (
EXISTS
(SELECT 1
FROM affair, doss, pfac_fele, unt_doss, pte_cmde,
cmde, lieu, zon_geo
WHERE doss_codsit = ven_facture_fn.vfaf_codsit
AND doss_numdos = ven_facture_fn.vfaf_numdos
AND doss_tgm = ven_facture_fn.vfaf_tgm
AND pffe_numpeefacint = ven_facture_fn.vfaf_numpeefacint
AND udos_numintuntdos = pffe_numintuntdos
AND pcde_codoricde = udos_codoricde
AND pcde_numcde = udos_numcde
AND pcde_numptecde = udos_numptecde
AND cmde_codoricde = pcde_codoricde
AND cmde_numcde = pcde_numcde
AND lieu_codleu = doss_codpordch
AND zgeo_codzongeo = lieu_codzongeo
AND affr_codsit = ven_facture_fn.vfaf_codsit
AND affr_codaff = @affaire
AND (affr_cdeusiexp = pcde_cdeusiexp OR affr_cdeusiexp IS NULL)
AND (affr_codporebq IN
(SELECT voya_codporebq
FROM voyage
WHERE voya_codsit = dossier.doss_codsit
AND voya_numvyg = dossier.doss_numvyg
) OR affr_codporebq IS NULL
)
AND (affr_codpordch = doss.doss_codpordch OR affr_codpordch IS NULL)
AND (affr_codleudes = cmde_codleudes OR affr_codleudes IS NULL)
AND (affr_codclides = cmde_codclides OR affr_codclides IS NULL)
AND (affr_codclifac = pcde_codclifacman
OR affr_codclifac = pcde_codclifacfet
OR affr_codclifac = pcde_codclifacppt
OR affr_codclifac = pcde_codclifacexp
OR affr_codclifac = pcde_codclifactra
OR affr_codclifac = pcde_codclifaccon
OR affr_codclifac IS NULL
)
AND (affr_codzongeo = zgeo_codzongeo OR affr_codzongeo IS NULL)
AND (affr_codcontinent = zgeo_codcontinent OR affr_codcontinent IS NULL)
AND (affr_codpay = lieu_codpay OR affr_codpay IS NULL)
) ) |
