1 2 3 4 5 6 7 8 9 10 11 12
| select sum(detail.DET_MONTANT_NET),delai.DO_DOCVDEL_DATE_DELAI,(to_date(sysdate,'DD/MM/YYYY')-to_date(delai.DO_DOCVDEL_DATE_DELAi,'DD/MM/YYYY'))
from dwh_doc_det_cl detail
inner join dwh_doc_ent_cl entete on entete.ENT_DOC_ID=detail.ENT_DOC_ID
left join dwh_doc_delai_cl delai on detail.DET_ID=delai.DO_DOCVDEL_DO_DOCDET_ID
where detail.det_code_solde!=9
and entete.ENT_CODE_SOLDE=9
and entete.ENT_TYPE_DOC_ABR like 'CLC'
and detail.det_tdoc_abrege like 'CLC'
and detail.det_montant_net!=0
and delai.DO_DOCVDEL_DATE_DELAI is not null
group by delai.DO_DOCVDEL_DATE_DELAI
order by delai.DO_DOCVDEL_DATE_DELAI desc |
Partager