1. SENZA FORNITORE ABITUALE
1.1. SELECT trim(cdarma) AS ARICOLO,dsarma AS DESCRIZIONE FROM mgart00f WHERE TPSTMA ='4' and CDPRMA ='0' and FOABMA = '' and statma = '' AND cdarma IN (SELECT CDCMDD FROM DTLEG00F df WHERE CDCMDD=CDARMA)
2. C/FORNITORE ABITUALE
2.1. C/LISTINO PREZZATO articolo ok
2.2. S/LISTINO PREZZI
2.2.1. SELECT FOABMA AS fornitore,DT01MA AS DATA,TRIM(cdarma) AS ARTICOLO ,DSARMA AS DESCRIZIONE FROM mgart00f WHERE TPSTMA ='4' and CDPRMA ='0' and FOABMA <> '' and statma = '' AND cdarma NOT IN (SELECT cdarml FROM MGLIS01F WHERE CDARML = CDARMA AND CLISML IN (SELECT FOABMA FROM MGART00F WHERE CDARMA=CDARML) AND DTLVML = 0) AND cdarma IN (SELECT cdcmdd FROM DTLEG00F df WHERE CDCMDD=CDARMA) ORDER BY TRIM(cdarma)
2.2.2. CON PREZZO DI LISTINO MA NON ABITUALE (modificare temporaneamente con il fornitore abituale che ha il prezzo e in fase di nuovo approvvigionamento chiedere offerta nuovo forniore se necessario)
2.2.2.1. SELECT FOABMA AS FornAbArt,(SELECT CLISML FROM MGLIS01F WHERE CDARML=CDARMA) AS ForListino, DT01MA AS DATA,TRIM(cdarma) AS ARTICOLO , DSARMA AS DESCRIZIONE FROM mgart00f WHERE TPSTMA ='4' and CDPRMA ='0' and FOABMA <> '' and statma = '' AND cdarma NOT IN (SELECT cdarml FROM MGLIS01F WHERE CDARML = CDARMA AND CLISML IN (SELECT FOABMA FROM MGART00F WHERE CDARMA=CDARML) AND DTLVML = 0) AND (SELECT count(*) FROM MGLIS01F WHERE CDARML = CDARMA) = 1 AND cdarma IN (SELECT cdcmdd FROM DTLEG00F df WHERE CDCMDD=CDARMA) ORDER BY TRIM(cdarma)