"SELECT ARTICLE_ID, ARTICLE.CODE_ARTICLE as CODE_ARTICLE, REVISION, ARTICLE.SOURCE as SOURCE, ARTICLE.DESIGNATION as DESIGNATION, PLAN, ARTICLE.UNITE as UNITE, TARIF.PRIX_DE_VENTE as PRIX_DE_VENTE, TARIF.GROUPE_REMISE as GROUPE_REMISE, TARIF.GROUPE_STATS as GROUPE_STATS, TARIF.CODE_SIGNAL as CODE_SIGNAL, REMPLACEMENT.CODE_ARTICLE as REMPLACEMENT, NOMENCLATURE_ID, PLANCHE_LIST_ID, NOTE_LIST_ID, IMAGE_ID, DIVERS, DESCRIPTION FROM ARTICLE,TARIF,SOURCE,REMPLACEMENT WHERE upper(ARTICLE.CODE_ARTICLE) like upper('"+ reference + "') AND ARTICLE.CODE_ARTICLE =
TARIF.CODE_ARTICLE(+) AND ARTICLE.CODE_ARTICLE =
REMPLACEMENT.OLD_ARTICLE(+) AND ARTICLE.SOURCE = SOURCE.SOURCE order by CODE_ARTICLE";
Partager