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
|
select T1.intervenant, T1.profile ,T1.jours_prestes_ext, T2.jours_prestes_int
from
(Select
B.intervenant, emp.PROFILE,
to_number((sum(to_char(HEURES_PRESTEES_TACHE,'HH24'))*60+sum(to_char(HEURES_PRESTEES_TACHE,'MI')))/(8*60)) as jours_prestes_ext
from
ACTIVITE B, employer emp
where B.FIRNUM='INFEUROPE'
and B.INTERVENANT = emp.INTERVENANT
and EADNUM like 'Lot 4/%-ext'
and DESCRIPTION_TACHE is not null
and to_char(DATE_ACTIVITE,'YYYYMM')='200812'
and to_char(DATE_ACTIVITE,'DY') not in ('SAT','SUN')
and B.CENTRE_DE_COUT != 'Divers'
and emp.PROFILE in ('ENG.TEST','ENG.INT')
group by (B.intervenant, emp.profile)
) T1
inner join
(select B.intervenant,emp.PROFILE ,to_number((sum(to_char(HEURES_PRESTEES_TACHE,'HH24'))*60+sum(to_char(HEURES_PRESTEES_TACHE,'MI')))/(8*60)) as jours_prestes_int
from ACTIVITE B, employer emp
where
B.FIRNUM='INFEUROPE'
and B.INTERVENANT = emp.INTERVENANT
and EADNUM like 'Lot 4/%-int'
and DESCRIPTION_TACHE is not null
and to_char(DATE_ACTIVITE,'YYYYMM')='200812'
and to_char(DATE_ACTIVITE,'DY') not in ('SAT','SUN')
and B.CENTRE_DE_COUT != 'Divers'
and emp.PROFILE in ('ENG.TEST','ENG.INT')
group by (B.intervenant, emp.PROFILE)
) T2
on
T1.intervenant = T2.intervenant |
Partager