>>>Ok, killing the programmer aside, I'm still stuck on this. I have verified the problem lies with the conversion of the IIF to CASE. I'm off by 4 rows.
>>
>>Try:
>>

>>WHERE PK_MOC.MOC_PART_NO) NOT LIKE '%-CR'  AND
>>      PK_MOC.MOC_PART_NO  NOT LIKE '%RMA%' AND
>>      PK_MOC.MOC_PART_NO  NOT LIKE '%RW'   AND
>>      PK_MOC.MOC_PART_NO  NOT LIKE '%RWK'  AND
>>      PK_MOC.MOC_OHNUMBER NOT LIKE 'FCST%' AND
>>      1 = CASE WHEN (PK_RQ.RQ_STATUS='C' OR  PK_RQ.RQ_QTY_ISS>=PK_RQ.RQ_QTY_REQ) AND
>>                    (PK_RQ.RQ_DATE_PROM>=Date()-365 OR PK_RQ.RQ_DATE_REQ>=Date()-365)
>>                    THEN 1
>>	       WHEN (PK_RQ.RQ_STATUS='C' OR PK_RQ.RQ_QTY_ISS>=PK_RQ.RQ_QTY_REQ)
>>	            THEN 0
>>	  ELSE 1 END                       AND
>>      PK_OH.OH_STATUS <= 3                 AND 
>>      PK_MOC.MOC_OHTYPE <> 'Q'             AND
>>      (PK_RQ.RQ_O_TYPE   <> 'X' OR PK_RQ.RQ_O_TYPE IS NULL)
>>

>
>I get the same results as I did using my interpretation of it.

I have one mistake: Date function

Try this:

....
1 = CASE WHEN (PK_RQ.RQ_STATUS='C' OR  PK_RQ.RQ_QTY_ISS>=PK_RQ.RQ_QTY_REQ) AND
              (PK_RQ.RQ_DATE_PROM >= DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-365) OR PK_RQ.RQ_DATE_REQ>=DATEADD(dd,DATEDIFF(dd,0,GETDATE()),-365))
....