> >SELECT RQ.RQ_MOCNUMBER, > RQ.RQ_MOCREFNO, > RQ.RQ_IMKEY, > RQ.RQ_DATE_REQ, > RQ.RQ_DATE_PROM, > SUM(CASE WHEN sf.BookedQty IS NULL THEN 0 ELSE > CASE WHEN sf.RQ_DATE_REQ >= RQ.RQ_DATE_REQ AND sf.RQ_DATE_REQ <= RQ.RQ_DATE_PROM THEN sf.BookedQty ELSE 0 END > END) AS PeriodOrderedQty > FROM OH > INNER JOIN MOC ON OH.OH_NUMBER = MOC.MOC_OHNUMBER > INNER JOIN RQ ON MOC.MOC_OHNUMBER = RQ.RQ_MOCNUMBER AND > MOC.MOC_REF_NO = RQ.RQ_MOCREFNO > LEFT JOIN v_SalesForecastBookedQtyByDate sf ON RQ.RQ_IMKEY = sf.RQ_IMKEY > GROUP BY RQ.RQ_MOCNUMBER, RQ.RQ_MOCREFNO, RQ.RQ_IMKEY, RQ.RQ_DATE_REQ, RQ.RQ_DATE_PROM > HAVING RQ.RQ_MOCNUMBER LIKE 'FCST*' >>