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
| SELECT lcfo_orfa_numero "Of"
, vlrf_arti_code_recu "art"
, lcfo_cdfo_numero "N° cde"
, lcfo_qte_commandee_ua "qté cdée"
, vlrf_dt_reception "dt recpt"
, vlrf_qte_recue_verif_ue "Qté recue"
, (SELECT MAX(tps_personnel_of.dt_cre)
FROM tps_personnel_of
WHERE tppo_phof_numero_phase = '499'
AND tppo_orfa_numero = lcfo_orfa_numero
) "dt ctl visu"
, tppo_tps_passe "tps passé"
FROM v_ligne_reception_fournisseur
LEFT OUTER JOIN ligne_cde_fournisseur
ON vlrf_cdfo_numero = lcfo_cdfo_numero
AND vlrf_arti_code_recu = lcfo_arti_code
AND lcfo_phof_numero_phase = '400'
LEFT OUTER JOIN tps_personnel_of
ON lcfo_orfa_numero = tppo_orfa_numero
AND lcfo_phof_numero_phase = tppo_phof_numero_phase
AND tppo_phof_numero_phase = '499'
WHERE vlrf_dt_reception > '15/01/2016'
AND lcfo_orfa_numero = '220633'
ORDER BY lcfo_orfa_numero
, vlrf_arti_code_recu
, lcfo_cdfo_numero |
Partager