SELECT forecast_qty,forecast_status FROM dbo.tbl_MFR_TPF_Detail WHERE MFR_ID = 1 AND tpartnerType = 'OPR' AND tpartnerID = #select.OperatorID# AND productLevel = 'SKU' AND productItemCode = '#select.sku#' AND forecast_year = '#select.forecast_year#' AND forecast_month = '#select.forecast_month#' gt1 : #check.forecast_status# :: #check.forecast_qty# (#select.forecast_qty#)
Update : #check.forecast_status# :: #check.forecast_qty# (#select.forecast_qty#)
--->