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 |
Partager