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
| select plan.domaine_,
plan.code,
plan.nom,
NQI_CPPJ_PROJECT.TARGET_START_DATE,
NQI_CPPJ_PROJECT.TARGET_END_DATE,
plan.personel,
to_char(plan.jour,'mm'),
to_char(plan.jour,'month'),
to_char(plan.jour,'yyyy') annee,
plan.status,
sum(plan.budget)
from (table(RP_3.planification(:deb, :fin ))) plan,==>> ICI LES DATES
NQI_CPPJ_PROJECT
where NQI_CPPJ_PROJECT.code=plan.code
group by plan.domaine_,
plan.code,
plan.nom,
NQI_CPPJ_PROJECT.TARGET_START_DATE,
to_char(plan.jour,'mm'),
NQI_CPPJ_PROJECT.TARGET_END_DATE,
plan.status,
plan.personel,
to_char(plan.jour,'month'),
to_char(plan.jour,'yyyy')
order by 1,3,6,7 |
Partager