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
|
1. insert into WRK_MD
2. (EQUIPEMENT_ID,
3. NB_MOC, NB_TARIFF,
4. QUARTER_START,
5. QUARTER_END,
6. TICKET_TYPE,
7. COLLECTION_SRC)
8. select
9. w.EQUIPEMENT_ID,
10. w.QUARTER_START,
11. w.QUARTER_END,
12. w.TICKET_TYPE,
13. w.COLLECTION_SRC,
14. nvl(sum(NB_MOC), 0), nvl(sum(NB_TARIFF), 0)
15. from XT_DISCONTINUITY d, WRK_MD3 w
16. where d.QUARTER_START (+) = w.QUARTER_START
17. and d.EQUIPEMENT_ID (+) = w.EQUIPEMENT_ID
18. and d.TICKET_TYPE (+) = w.TICKET_TYPE
19. and d.COLLECTION_SRC (+) = w.COLLECTION_SRC
20. and d.QUARTER_START (+) >= to_date('09/04/2008','DD/MM/YYYY
21. HH24:MI:SS')
22. and d.QUARTER_START (+) < to_date('14/04/2008','DD/MM/YYYY
23. HH24:MI:SS')
24. group by
25. w.EQUIPEMENT_ID,
26. w.QUARTER_START,
27. w.QUARTER_END,
28. w.TICKET_TYPE,
29. w.COLLECTION_SRC
30. order by
31. w.EQUIPEMENT_ID,
32. w.QUARTER_START,
33. w.TICKET_TYPE,
34. w.COLLECTION_SRC; |
Partager