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
|
SELECT DISTINCT
T3.name as business_line,
T1.project_name as projet
FROM
incident T1,
business_line T3,
parent_child_links T3mm,
project T2
WHERE
T1.dbid <> 0
AND T1.business_line <> 0
AND T1.submit_date is not NULL
AND T1.project_name = T2.name
AND T2.dbid = T3mm.child_dbid (+)
AND 16778549 = T3mm.child_fielddef_id (+)
AND T3mm.parent_dbid = T3.dbid (+)
AND T1.project_name not in (
SELECT
T4.name
FROM
incident T5,
project T4
WHERE
T4.name = T5.project_name
AND T5.dbid <>0
AND T4.dbid <> 0
AND T5.submit_date < {ts '2008-07-01 00:00:01' }
)
ORDER BY T3.name |
