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
| SELECT
phs.phs_d AS Date_mouv,
phs.phs_psk_bra_id AS Ets,
phs.phs_pmf_id AS Code_Marque,
phs.phs_pro_id AS Ref_art,
phs.phs_movement AS Mvt,
CASE phs.phs_movement
WHEN '01' THEN 'Réception'
WHEN '02' THEN 'Vente'
WHEN '03' THEN 'Remplacement'
WHEN '04' THEN 'Ajustement'
WHEN '05' THEN 'Inventaire'
WHEN '06' THEN 'Surplus'
WHEN '07' THEN 'Trf camion'
END AS Design_mvt,
phs.phs_odh_srh_doc AS Num_lot,
phs.oft_id AS Type_or,
phs.ofh_id AS Num_or,
phs.phs_csc_id AS Num_client,
phs.phs_csc_id AS Ets_cession,
phs.phs_q AS Qte_mvt,
phs.phs_cost AS Pu_mvt
FROM phs LEFT JOIN pdi ON (phs_pro_id = pdi.pro_id)
WHERE YEAR(phs.phs_d) IN('2009','2010')
AND pdi.lng_id = 1
AND phs.phs_psk_bra_id IN('OV01','OV02','OV03','BE01','BE02')
AND phs_pro_id = 'WA8307020874'
ORDER BY phs.phs_d |
Partager