понедельник, 21 июня 2010 г.

8форма 9раздел 

8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66

select
--========================================== строка 1 ===========================================
(
select --Земельные участки на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"1ЗемНачПер" --Земельные участки на начало периода
,(
select --Земельные участки в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"1ЗемОтчетПер"
,(
select --Земельные участки закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"1ЗемПрекрОтчетПер"
,(
select --Земельные участки на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"1ЗемКонецПер"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93

--======================================== строка 2 ==============================================
,(
select --Земельные участки на начало периода 93ФЗ
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"2ЗемНачПер93ФЗ" --Земельные участки на начало периода
,(
select --Земельные участки в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"2ЗемОтчетПер93ФЗ"
,(
select --Земельные участки закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"2ЗемПрекрОтчетПер93ФЗ"
,(
select --Земельные участки на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '1_____' or RPR.TYPE_CODE like '1_______' or RPR.TYPE_CODE like '1______')
)"2ЗемКонецПер93ФЗ"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73

--======================================== строка 3 ==============================================
,(
select --Здания строения на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"3ЗданНачПер"
,(
select --Здания строения  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"3ЗданОтчетПер"
,(
select --Здания строения закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"3ЗданПрекрОтчетПер"
,(
select --Здания строения  на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"3ЗданКонПер"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
 
--======================================== строка 4 ==============================================
,(
select --Здания строения на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"4ЗданНачПер93ФЗ"
,(
select --Здания строения  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"4ЗданОтчетПер93ФЗ"
,(
select --Здания строения закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"4ЗданПрекрОтчетПер93ФЗ"
,(
select --Здания строения  на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
,app_applications ap
,app_rt apr
,app_switch asw
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and apr.rt_id = r.id
and apr.app_id=ap.id
and ASW.APP_ID=ap.id
and ASW.R_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '22____'
  or RPR.TYPE_CODE like '23____' or RPR.TYPE_CODE like '24____' or RPR.TYPE_CODE like '25____'
  or RPR.TYPE_CODE like '26____' or RPR.TYPE_CODE like '27____' or RPR.TYPE_CODE like '8_____')
)"4ЗданКонПер93ФЗ"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

--======================================== строка 5 ==============================================
,(
select --Сооружения на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
--and o.RE_OBJ_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
)"5СооружНачПер"
,(
select --Сооружения  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
--and o.RE_OBJ_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
 
)"5СооружОтчетПер"
,(
select --Сооружения закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
--and o.RE_OBJ_TYPE=1
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
)"5СооружПрекрОтчетПер"
,(
select --Сооружения на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
--and o.RE_OBJ_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
)"5СооружКонПер"

8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

--======================================== строка 6 ==============================================
,(
select --Сооружения на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.RE_OBJ_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
)"6СооружНачПерЛин"
,(
select --Сооружения  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.RE_OBJ_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
 
)"6СооружОтчетПерЛин"
,(
select --Сооружения закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.RE_OBJ_TYPE=1
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
)"6СооружПрекрОтчетПерЛин"
,(
select --Сооружения на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.RE_OBJ_TYPE=1
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '3_____')
)"6СооружКонПерЛин"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65

--======================================== строка 7 ==============================================
,(
select --Жилое на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"7ЖилНачПер"
,(
select --Жилое  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"7ЖилОтчетПер"
,(
select --Жилое закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"7ЖилПрекрОтчетПер"
,(
select --Жилое на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"7ЖилКонПер"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

--======================================== строка 8 ==============================================
,(
select --Жилое на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%жилой дом%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"8ЖилНачПерЖилД"
,(
select --Жилое  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%жилой дом%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"8ЖилОтчетПерЖилД"
,(
select --Жилое закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%жилой дом%'
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"8ЖилПрекрОтчетПерЖилД"
,(
select --Жилое на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%жилой дом%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"8ЖилКонПерЖилД"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69

--======================================== строка 9 ==============================================
,(
select --Жилое на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%квартир%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"9ЖилНачПерКв"
,(
select --Жилое  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%квартир%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"9ЖилОтчетПерКв"
,(
select --Жилое закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%квартир%'
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"9ЖилПрекрОтчетПерКв"
,(
select --Жилое на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%квартир%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"9ЖилКонПерКв"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70

--======================================== строка 10 ==============================================
,(
select --Жилое на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%комната%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"10ЖилНачПерКом"
,(
select --Жилое  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%комната%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"10ЖилОтчетПерКом"
,(
select --Жилое закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%комната%'
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"10ЖилПрекрОтчетПерКом"
,(
select --Жилое на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and lower (o.name) like '%комната%'
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '21____')
)"10ЖилКонПерКом"
 


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65

--======================================== строка 11 ==============================================
,(
select --ПИК на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '5_____')
)"11ПИКНачПер"
,(
select --ПИК  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '5_____')
)"11ПИКОтчетПер"
,(
select --ПИК закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '5_____')
)"11ПИКПрекрОтчетПер"
,(
select --ПИК на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '5_____')
)"11ПИККонПер"


8форма 9раздел
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
54
55
56
57
58
59
60
61
62
63
64
65

--======================================== строка 12 ==============================================
,(
select --Иные на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '4_____' or RPR.TYPE_CODE like '6_____' or RPR.TYPE_CODE like '7_____')
)"12ИныеНачПер"
,(
select --Иные  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '4_____' or RPR.TYPE_CODE like '6_____'  or RPR.TYPE_CODE like '7_____')
)"12ИныеОтчетПер"
,(
select --Иные закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '4_____' or RPR.TYPE_CODE like '6_____'  or RPR.TYPE_CODE like '7_____')
)"12ИныеПрекрОтчетПер"
,(
select --Иные на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
,re_purposes rpr
,re_purpose_voc rpv
where
O.ID = r.RE_ID
and RPR.RE_ID=o.id
and RPR.TYPE_CODE=RPV.CODE
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
and (RPR.TYPE_CODE like '4_____' or RPR.TYPE_CODE like '6_____' or RPR.TYPE_CODE like '7_____')
)"12ИныеКонПер"


8форма 9раздел
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

--======================================== строка 13 ==============================================
,(
select --Все на начало периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
where
O.ID = r.RE_ID
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&start#', 'dd.mm.yyyy')
)"13ВсеНачПер"
,(
select --Иные  в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
where
O.ID = r.RE_ID
and O.E_DATE is null
and O.S_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
)"13ВсеОтчетПер"
,(
select --Иные закрытые в отчетном периоде
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
where
O.ID = r.RE_ID
and o.E_DATE between TO_DATE ('&start#', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
)"13ВсеПрекрОтчетПер"
,(
select --Иные на конец периода
count(distinct o.ID) "КолОбъект"
from
re_objects o
,rt_rights r
where
O.ID = r.RE_ID
and O.E_DATE is null
and O.S_DATE between TO_DATE ('01.01.1999', 'dd.mm.yyyy') and TO_DATE ('&end#', 'dd.mm.yyyy')
)"13ВсеКонПер"
 
from dual
Автор: на

Комментариев нет:

Отправить комментарий

Подписаться на: Комментарии к сообщению (Atom)