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