3 Replies Latest reply: Jul 10, 2013 8:33 AM by amal mathlouthi RSS

    Help : Expression imbriqué setAnalysis

      SVP j'essaie de traduire cette requete en setAnalysis imbriqué mais j trouve pas de solution qui marche :

       

      select nvl(SUM (invbalances.curbal),0) AS qte_stock

      where

      (nvl(poline.receivedqty,0) < nvl(poline.orderqty,0))

      AND poline.receiptscomplete = 0

      AND NVL(TO_CHAR(poline.vendeliverydate,'YYYYMMDD'),TO_CHAR(poline.reqdeliverydate,'YYYYMMDD')) <= TO_CHAR(SYSDATE,'YYYYMMDD')

       

      Merci pour tout aide