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
48
49
50
51
52
53
| select s.N_IDSITUATION,
s.N_IDDOCUMENT,
s.D_EFFET,
s.D_FIN_SIT,
s.N_MOTIFSIT,
s.D_FIN_ENG,
s.N_MTACCORD,
s.N_ECHEANCE,
s.N_MTFRANCHABS,
s.N_MINFRANCHI,
s.N_MTFRADECAN,
s.N_MTMXANASSU,
s.N_MTMXSINIST,
s.N_PLAFRANCHI,
s.N_TXFRADECAN,
s.N_TXFRANCHRE,
s.C_TAXASSUR,
s.D_DATEMAJ,
s.C_UTIL,
m.C_LIBELLE,
m.n_motif,
u.n_mtutilise,
u.d_deb_util
from lmc_Situatio s, lmc_motif m, lmc_utilisat u
where m.n_motif(+) = s.n_motifsit
and u.n_iddocument(+) = s.n_iddocument
and u.d_fin_util(+) is null
[color=red][b]and u.d_deb_util(+) <= NVL(s.d_fin_sit, to_date('31/12/2099', 'dd/mm/yyyy'))[/b][/color]
and s.n_iddocument = 14069
group by s.N_IDSITUATION,
s.N_IDDOCUMENT,
s.D_EFFET,
s.D_FIN_SIT,
s.N_MOTIFSIT,
s.D_FIN_ENG,
s.N_MTACCORD,
s.N_ECHEANCE,
s.N_MTFRANCHABS,
s.N_MINFRANCHI,
s.N_MTFRADECAN,
s.N_MTMXANASSU,
s.N_MTMXSINIST,
s.N_PLAFRANCHI,
s.N_TXFRADECAN,
s.N_TXFRANCHRE,
s.C_TAXASSUR,
s.D_DATEMAJ,
s.C_UTIL,
u.n_mtutilise,
u.d_deb_util,
m.C_LIBELLE,
m.n_motif
order by s.n_idsituation desc |
