[#5052] Utiliser les mêmes filtres pour l'interro des cumuls et l'interro des détails
[auf_coda_additions.git] / db / procedures / auf_p_interro_detail.sql
CommitLineData
8813ca10
EMS
1ÿþU\0S\0E\0 \0[\0c\0o\0d\0a\0-\0p\0r\0o\0d\0]\0
2\0G\0O\0
3\0
8813ca10
EMS
4\0S\0E\0T\0 \0A\0N\0S\0I\0_\0N\0U\0L\0L\0S\0 \0O\0F\0F\0
5\0G\0O\0
6\0S\0E\0T\0 \0Q\0U\0O\0T\0E\0D\0_\0I\0D\0E\0N\0T\0I\0F\0I\0E\0R\0 \0O\0F\0F\0
7\0G\0O\0
8813ca10 8\0
94ce8e57 9\0A\0L\0T\0E\0R\0 \0P\0R\0O\0C\0E\0D\0U\0R\0E\0 \0[\0d\0b\0o\0]\0.\0[\0a\0u\0f\0_\0p\0_\0i\0n\0t\0e\0r\0r\0o\0_\0d\0e\0t\0a\0i\0l\0]\0
8813ca10
EMS
10\0 \0 \0 \0 \0@\0p\0r\0o\0j\0e\0t\0p\0o\0s\0t\0e\0 \0v\0a\0r\0c\0h\0a\0r\0(\07\0)\0,\0
11\0 \0 \0 \0 \0@\0a\0n\0n\0e\0e\0 \0i\0n\0t\0,\0
94ce8e57 12\0 \0 \0 \0 \0@\0t\0y\0p\0e\0 \0v\0a\0r\0c\0h\0a\0r\0(\03\0)\0
8813ca10 13\0A\0S\0
8813ca10
EMS
14\0S\0E\0T\0 \0N\0O\0C\0O\0U\0N\0T\0 \0O\0N\0
15\0
16\0C\0R\0E\0A\0T\0E\0 \0T\0A\0B\0L\0E\0 \0 \0#\0d\0e\0p\0e\0n\0s\0e\0_\0r\0e\0c\0e\0t\0t\0e\0 \0(\0
17\0 \0 \0 \0 \0e\0l\01\0 \0v\0a\0r\0c\0h\0a\0r\0(\02\00\0)\0
18\0)\0
19\0
9ef8c201 20\0I\0F\0 \0@\0t\0y\0p\0e\0 \0=\0 \0'\0D\0E\0P\0'\0
94ce8e57
EMS
21\0 \0 \0 \0 \0I\0N\0S\0E\0R\0T\0 \0I\0N\0T\0O\0 \0#\0d\0e\0p\0e\0n\0s\0e\0_\0r\0e\0c\0e\0t\0t\0e\0
22\0 \0 \0 \0 \0S\0E\0L\0E\0C\0T\0 \0c\0o\0d\0e\0
23\0 \0 \0 \0 \0F\0R\0O\0M\0 \0o\0a\0s\0_\0e\0l\0e\0m\0e\0n\0t\0
24\0 \0 \0 \0 \0W\0H\0E\0R\0E\0
25\0 \0 \0 \0 \0 \0 \0 \0 \0c\0m\0p\0c\0o\0d\0e\0 \0=\0 \0'\0A\0U\0F\0'\0
26\0 \0 \0 \0 \0 \0 \0 \0 \0A\0N\0D\0 \0e\0l\0m\0l\0e\0v\0e\0l\0 \0=\0 \01\0
27\0 \0 \0 \0 \0 \0 \0 \0 \0A\0N\0D\0 \0(\0c\0o\0d\0e\0 \0L\0I\0K\0E\0 \0'\02\0%\0'\0 \0O\0R\0 \0c\0o\0d\0e\0 \0L\0I\0K\0E\0 \0'\06\0%\0'\0 \0O\0R\0 \0c\0o\0d\0e\0 \0L\0I\0K\0E\0 \0'\09\0%\0'\0)\0
9ef8c201 28\0E\0L\0S\0E\0
94ce8e57
EMS
29\0 \0 \0 \0 \0I\0N\0S\0E\0R\0T\0 \0I\0N\0T\0O\0 \0#\0d\0e\0p\0e\0n\0s\0e\0_\0r\0e\0c\0e\0t\0t\0e\0
30\0 \0 \0 \0 \0S\0E\0L\0E\0C\0T\0 \0c\0o\0d\0e\0
31\0 \0 \0 \0 \0F\0R\0O\0M\0 \0o\0a\0s\0_\0e\0l\0e\0m\0e\0n\0t\0
32\0 \0 \0 \0 \0W\0H\0E\0R\0E\0
33\0 \0 \0 \0 \0 \0 \0 \0 \0c\0m\0p\0c\0o\0d\0e\0 \0=\0 \0'\0A\0U\0F\0'\0
34\0 \0 \0 \0 \0 \0 \0 \0 \0A\0N\0D\0 \0e\0l\0m\0l\0e\0v\0e\0l\0 \0=\0 \01\0
35\0 \0 \0 \0 \0 \0 \0 \0 \0A\0N\0D\0 \0(\0c\0o\0d\0e\0 \0L\0I\0K\0E\0 \0'\01\0%\0'\0 \0O\0R\0 \0c\0o\0d\0e\0 \0L\0I\0K\0E\0 \0'\07\0%\0'\0)\0
8813ca10
EMS
36\0
37\0S\0E\0L\0E\0C\0T\0
38\0 \0 \0 \0 \0h\0.\0d\0o\0c\0c\0o\0d\0e\0 \0A\0S\0 \0c\0o\0d\0e\0_\0d\0o\0c\0,\0
39\0 \0 \0 \0 \0h\0.\0d\0o\0c\0n\0u\0m\0 \0A\0S\0 \0n\0u\0m\0_\0d\0o\0c\0,\0
40\0 \0 \0 \0 \0h\0.\0y\0r\0 \0A\0S\0 \0e\0x\0e\0r\0c\0i\0c\0e\0,\0
41\0 \0 \0 \0 \0h\0.\0p\0e\0r\0i\0o\0d\0 \0A\0S\0 \0p\0e\0r\0i\0o\0d\0e\0,\0
f01c30f4 42\0 \0 \0 \0 \0C\0O\0N\0V\0E\0R\0T\0(\0v\0a\0r\0c\0h\0a\0r\0,\0 \0h\0.\0d\0o\0c\0d\0a\0t\0e\0,\0 \01\00\02\0)\0 \0A\0S\0 \0d\0a\0t\0e\0_\0d\0o\0c\0,\0
8813ca10 43\0 \0 \0 \0 \0l\0.\0e\0l\01\0 \0A\0S\0 \0p\0c\0g\0,\0
94ce8e57 44\0 \0 \0 \0 \0l\0.\0e\0l\02\0 \0A\0S\0 \0t\0i\0e\0r\0s\0_\0o\0p\0e\0r\0a\0t\0i\0o\0n\0,\0
8813ca10 45\0 \0 \0 \0 \0l\0.\0e\0l\03\0 \0A\0S\0 \0p\0r\0o\0j\0e\0t\0_\0p\0o\0s\0t\0e\0,\0
94ce8e57 46\0 \0 \0 \0 \0l\0.\0d\0e\0s\0c\0r\0 \0A\0S\0 \0d\0e\0s\0c\0r\0i\0p\0t\0i\0o\0n\0_\0l\0i\0g\0n\0e\0,\0
8813ca10
EMS
47\0 \0 \0 \0 \0h\0.\0c\0u\0r\0d\0o\0c\0 \0A\0S\0 \0d\0e\0v\0_\0d\0o\0c\0,\0
48\0 \0 \0 \0 \0l\0.\0v\0a\0l\0u\0e\0d\0o\0c\0 \0A\0S\0 \0m\0o\0n\0t\0a\0n\0t\0_\0d\0o\0c\0,\0
49\0 \0 \0 \0 \0l\0.\0v\0a\0l\0u\0e\0h\0o\0m\0e\0 \0A\0S\0 \0m\0o\0n\0t\0a\0n\0t\0_\0e\0u\0r\0,\0
50\0 \0 \0 \0 \0C\0A\0S\0E\0 \0l\0.\0d\0e\0b\0_\0c\0r\0e\0d\0_\0i\0n\0d\0
94ce8e57
EMS
51\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \01\06\00\0 \0T\0H\0E\0N\0 \0'\0C\0r\0é\0d\0i\0t\0'\0
52\0 \0 \0 \0 \0 \0 \0 \0 \0E\0L\0S\0E\0 \0'\0D\0é\0b\0i\0t\0'\0
8813ca10 53\0 \0 \0 \0 \0E\0N\0D\0 \0A\0S\0 \0d\0e\0b\0i\0t\0_\0c\0r\0e\0d\0i\0t\0,\0
9ef8c201
EMS
54\0 \0 \0 \0 \0l\0.\0r\0e\0f\01\0 \0A\0S\0 \0n\0u\0m\0e\0r\0o\0_\0f\0a\0c\0t\0u\0r\0e\0,\0
55\0 \0 \0 \0 \0'\0'\0 \0A\0S\0 \0n\0u\0m\0e\0r\0o\0_\0a\0v\0o\0i\0r\0,\0
94ce8e57 56\0 \0 \0 \0 \0l\0.\0r\0e\0f\03\0 \0A\0S\0 \0p\0a\0y\0e\0u\0r\0,\0
9ef8c201
EMS
57\0 \0 \0 \0 \0l\0.\0r\0e\0f\04\0 \0A\0S\0 \0s\0a\0l\0a\0r\0i\0e\0,\0
58\0 \0 \0 \0 \0l\0.\0r\0e\0f\05\0 \0A\0S\0 \0n\0u\0m\0e\0r\0o\0_\0c\0h\0e\0q\0u\0e\0,\0
8813ca10 59\0 \0 \0 \0 \0C\0A\0S\0E\0 \0l\0.\0s\0t\0a\0t\0p\0a\0y\0
94ce8e57
EMS
60\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \08\04\0 \0T\0H\0E\0N\0 \0'\0D\0 \0-\0 \0D\0i\0s\0p\0o\0n\0i\0b\0l\0e\0'\0
61\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \08\07\0 \0T\0H\0E\0N\0 \0'\0A\0 \0-\0 \0A\0t\0t\0e\0n\0t\0e\0'\0
62\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \01\07\01\0 \0T\0H\0E\0N\0 \0'\0X\0 \0-\0 \0F\0e\0r\0m\0é\0 \0(\0n\0o\0n\0 \0l\0e\0t\0t\0r\0a\0b\0l\0e\0)\0'\0
63\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \08\09\0 \0T\0H\0E\0N\0 \0'\0P\0 \0-\0 \0P\0a\0y\0é\0'\0
64\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \09\03\0 \0T\0H\0E\0N\0 \0'\0O\0 \0-\0 \0P\0r\0o\0p\0o\0s\0é\0'\0
65\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \05\01\0 \0T\0H\0E\0N\0 \0'\0C\0_\0N\0U\0L\0L\0'\0
66\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \03\06\09\0 \0T\0H\0E\0N\0 \0'\0C\0_\0D\0R\0A\0F\0T\0_\0A\0V\0A\0I\0L\0A\0B\0L\0E\0'\0
67\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \04\02\00\0 \0T\0H\0E\0N\0 \0'\0C\0_\0D\0R\0A\0F\0T\0_\0P\0A\0I\0D\0'\0
68\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \05\00\06\0 \0T\0H\0E\0N\0 \0'\0C\0_\0D\0R\0A\0F\0T\0_\0H\0E\0L\0D\0'\0
69\0 \0 \0 \0 \0 \0 \0 \0 \0E\0L\0S\0E\0 \0'\0-\0'\0
8813ca10 70\0 \0 \0 \0 \0E\0N\0D\0 \0A\0S\0 \0s\0t\0a\0t\0u\0t\0_\0p\0a\0i\0e\0m\0e\0n\0t\0,\0
f01c30f4 71\0 \0 \0 \0 \0C\0O\0N\0V\0E\0R\0T\0(\0v\0a\0r\0c\0h\0a\0r\0,\0 \0l\0.\0d\0u\0e\0d\0a\0t\0e\0 \0,\0 \01\00\02\0)\0 \0A\0S\0 \0d\0a\0t\0e\0_\0e\0c\0h\0e\0a\0n\0c\0e\0,\0
8813ca10
EMS
72\0 \0 \0 \0 \0l\0.\0u\0s\0r\0n\0a\0m\0e\0 \0A\0S\0 \0u\0t\0i\0l\0i\0s\0a\0t\0e\0u\0r\0,\0
73\0 \0 \0 \0 \0C\0A\0S\0E\0 \0h\0.\0s\0t\0a\0t\0u\0s\0
94ce8e57
EMS
74\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \07\07\0 \0T\0H\0E\0N\0 \0'\0T\0 \0-\0 \0A\0c\0t\0i\0f\0'\0
75\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \07\08\0 \0T\0H\0E\0N\0 \0'\0M\0 \0-\0 \0I\0m\0p\0u\0t\0é\0'\0
76\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \07\09\0 \0T\0H\0E\0N\0 \0'\0C\0_\0D\0O\0C\0S\0T\0A\0T\0_\0C\0A\0N\0C\0E\0L\0'\0
77\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \01\01\06\0 \0T\0H\0E\0N\0 \0'\0C\0 \0-\0 \0C\0o\0r\0b\0e\0i\0l\0l\0e\0'\0
78\0 \0 \0 \0 \0 \0 \0 \0 \0W\0H\0E\0N\0 \02\03\05\0 \0T\0H\0E\0N\0 \0'\0V\0 \0-\0 \0R\0é\0s\0e\0r\0v\0é\0'\0
79\0 \0 \0 \0 \0 \0 \0 \0 \0E\0L\0S\0E\0 \0'\0-\0'\0
8813ca10 80\0 \0 \0 \0 \0E\0N\0D\0 \0A\0S\0 \0s\0t\0a\0t\0u\0t\0_\0d\0o\0c\0,\0
f01c30f4 81\0 \0 \0 \0 \0C\0O\0N\0V\0E\0R\0T\0(\0v\0a\0r\0c\0h\0a\0r\0,\0 \0h\0.\0i\0n\0p\0d\0a\0t\0e\0 \0,\0 \01\00\02\0)\0 \0A\0S\0 \0d\0a\0t\0e\0_\0s\0a\0i\0s\0i\0e\0
94ce8e57
EMS
82\0F\0R\0O\0M\0 \0o\0a\0s\0_\0d\0o\0c\0h\0e\0a\0d\0 \0h\0,\0 \0o\0a\0s\0_\0d\0o\0c\0l\0i\0n\0e\0 \0l\0
83\0W\0H\0E\0R\0E\0
84\0 \0 \0 \0 \0h\0.\0c\0m\0p\0c\0o\0d\0e\0 \0=\0 \0'\0A\0U\0F\0'\0
85\0 \0 \0 \0 \0A\0N\0D\0 \0l\0.\0c\0m\0p\0c\0o\0d\0e\0 \0=\0 \0'\0A\0U\0F\0'\0
86\0 \0 \0 \0 \0A\0N\0D\0 \0h\0.\0y\0r\0 \0=\0 \0@\0a\0n\0n\0e\0e\0
87\0 \0 \0 \0 \0A\0N\0D\0 \0h\0.\0p\0e\0r\0i\0o\0d\0 \0B\0E\0T\0W\0E\0E\0N\0 \01\0 \0A\0N\0D\0 \01\02\0
88\0 \0 \0 \0 \0A\0N\0D\0 \0h\0.\0d\0o\0c\0c\0o\0d\0e\0 \0=\0 \0l\0.\0d\0o\0c\0c\0o\0d\0e\0
89\0 \0 \0 \0 \0A\0N\0D\0 \0h\0.\0d\0o\0c\0n\0u\0m\0 \0=\0 \0l\0.\0d\0o\0c\0n\0u\0m\0
90\0 \0 \0 \0 \0A\0N\0D\0 \0l\0.\0e\0l\01\0 \0N\0O\0T\0 \0L\0I\0K\0E\0 \0'\09\06\0%\0'\0
91\0 \0 \0 \0 \0A\0N\0D\0 \0l\0.\0e\0l\01\0 \0N\0O\0T\0 \0L\0I\0K\0E\0 \0'\09\07\0%\0'\0
92\0 \0 \0 \0 \0A\0N\0D\0 \0l\0.\0e\0l\01\0 \0N\0O\0T\0 \0L\0I\0K\0E\0 \0'\09\08\0%\0'\0
93\0 \0 \0 \0 \0A\0N\0D\0 \0L\0E\0F\0T\0(\0l\0.\0e\0l\03\0,\02\0)\0 \0<\0>\0 \0'\09\05\0'\0
94\0 \0 \0 \0 \0A\0N\0D\0 \0l\0.\0e\0l\03\0 \0L\0I\0K\0E\0 \0@\0p\0r\0o\0j\0e\0t\0p\0o\0s\0t\0e\0+\0'\0%\0'\0
95\0 \0 \0 \0 \0A\0N\0D\0 \0l\0.\0e\0l\01\0 \0I\0N\0 \0(\0S\0E\0L\0E\0C\0T\0 \0e\0l\01\0 \0F\0R\0O\0M\0 \0#\0d\0e\0p\0e\0n\0s\0e\0_\0r\0e\0c\0e\0t\0t\0e\0)\0
8813ca10
EMS
96\0O\0R\0D\0E\0R\0 \0B\0Y\0 \0 \0l\0.\0e\0l\02\0,\0 \0l\0.\0e\0l\01\0,\0 \0h\0.\0y\0r\0,\0 \0h\0.\0p\0e\0r\0i\0o\0d\0
97\0
9ef8c201 98\0D\0R\0O\0P\0 \0T\0A\0B\0L\0E\0 \0#\0d\0e\0p\0e\0n\0s\0e\0_\0r\0e\0c\0e\0t\0t\0e\0
8813ca10
EMS
99\0G\0O\0
100\0