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
| SELECT lcfo_cdfo_numero "N°cde"
,lcfo_ligne "Ligne"
,TO_CHAR( ligne_cde_fournisseur.dt_cre,'DD/MM/YYYY') "Dt cde"
,four_nom "Fourn"
,lcfo_four_code "Code fourn"
,lcfo_arti_code "Art"
,arti_designation "Design"
,lcfo_qte_commandee_ua "Qté cdée"
,lrfo_qte_recue_verif_ua "Qté recue"
--,lrfo_refo_numero "Recpt"
,Lcfo_unit_code_ua "Unit"
,lcfo_dt_livraison_demande "A livrer le"
,lcfo_dt_livraison_confirme "Confirmée"
,lcfo_statut "Statut"
--, lcfo_dt_derniere_reception "Dt recpt"
--, lcfo_four_code "Code fourn"
--,four_coge_compte_tiers "cpte four"
FROM article, ligne_cde_fournisseur, fournisseur,ligne_reception_fournisseur
WHERE lcfo_arti_code = arti_code
AND lcfo_arti_code = lrfo_arti_code_recu (+)
AND lcfo_cdfo_numero = lrfo_cdfo_numero (+)
AND lcfo_ligne = lrfo_ligne (+)
AND four_code = lcfo_four_code
AND lcfo_statut <> 'SOL'
--AND lcfo_cdfo_numero = '13-01516'
--AND lrfo_qte_recue_verif_ua BETWEEN Null AND < lcfo_qte_commandee_ua
--AND lrfo_qte_recue_verif_ua < lcfo_qte_commandee_ua
ORDER BY 4,1; |
Partager