Code :
SELECT ssfpro "Collection", codpro "Code", nompro "Nom court", coddou "Code douanier", codpay "Pays d'origine", poids "Poids brut", large "Largeur brute", longue "Longueur brute", haute "Hauteur", volume "Volume brut", to_number(REPLACE(nvl(trim(codzn5), '0'), '.', ',')) "Largeur nette", to_number(REPLACE(nvl(trim(codzn4), '0'), '.', ',')) "Longueur nette", to_number(REPLACE(nvl(trim(codzn6), '0'), '.', ',')) "Hauteur nette", to_number(REPLACE(nvl(trim(codzn7), '0'), '.', ',')) "Volume net", poidsnet "Poids net" FROM pro WHERE codsoc = 2 AND suistk = 'S' AND codpro NOT LIKE 'SAV%' AND codblocage NOT IN ('ECH', 'INT') AND (ssfpro NOT IN (' ', 'SANS') OR ssfpro IN (' ', 'SANS') AND fampro = 'BOU') AND (pro.codblocage NOT IN ('STO', 'SOM', 'FDS', 'NAP', 'SOL') OR (pro.codblocage IN ('STO', 'SOM', 'FDS', 'NAP', 'SOL') AND EXISTS (SELECT NULL FROM dsk WHERE dsk.codsoc = pro.codsoc AND dsk.codpro = pro.codpro AND dsk.sigdep IN (SELECT sigtie FROM tie WHERE tie.codsoc = dsk.codsoc AND tie.typtie = 'DEP' AND tie.codett = 'ACT' AND tie.codzn1 = 'O') AND (dsk.c01 > 0 OR dsk.c02 > 0 OR dsk.c03 > 0 OR dsk.c04 > 0 OR dsk.c05 > 0)))) ORDER BY ssfpro, codpro
|