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 36 37 38 39 40 41 42 43 44 45 46 47 48
| Select s.soci,
s.risk,
s.origin,
s.destin,
s.pack,
s.dev,
s.flg_p_s,
s.term,
to_char(s.date_ship_deb, 'YYYY') "ANNEE_REF",
to_char(s.date_ship_deb, 'MM') "MOIS_REF",
sum(s.qte_EXEC_solde) "TOT_QTE_SHORT",
AVG(E.MT_COST_RISK /e.qte_appliquee) "AVG_PRIX_FLAT"
From Sect S, Term T, estcost E
Where s.soci = '56'
and s.qte_exec_solde <> 0
and s.risk = 'T711'
and s.Term = T.term
and T.BASIS = 'C'
and S.flg_p_s = 'S'
and s.contrat = E.CONTRAT(+)
and S.sect = E.sect
and e.qte_appliquee<>0
and e.mt_cost <> 0
and E.COST in ('FRET', 'BFRET')
group by s.soci,
s.risk,
s.origin,
s.destin,
s.pack,
s.dev,
s.flg_p_s,
s.term,
to_char(s.date_ship_deb, 'YYYY'),
to_char(s.date_ship_deb, 'MM')
order by s.soci,
s.risk,
s.origin,
s.destin,
s.pack,
s.dev,
s.flg_p_s,
s.term,
to_char(s.date_ship_deb, 'YYYY') asc,
to_char(s.date_ship_deb, 'MM') asc; |
Partager